50 Excel Shortcuts That You Should Know in 2023

SHORTCUT KEYS IN MS-EXCEL - https://youtu.be/Ew2gNb2Y_Gw 



50 Excel Shortcuts That You Should Know in 2023

Description

Excel Shortcuts 

1. To create a new workbook

Ctrl + N

2. To open an existing workbook

Ctrl + O

3. To save a workbook/spreadsheet

Ctrl + S

4. To close the current workbook

Ctrl + W

5. To close Excel

Ctrl + F4

6. To move to the next sheet

Ctrl + PageDown

7. To move to the previous sheet

Ctrl + PageUp

8. To go to the Data tab

Alt + A

9. To go to the View tab

Alt + W

10. To go the Formula tab

Alt + M

11. To edit a cell

F2

12. To copy and paste cells

Ctrl + C, Ctrl + V

13. To italicize and make the font bold

Ctrl + I, Ctrl + B

14. To center align cell contents

Alt + H + A + C

15. To fill color

Alt + H + H

16. To add a border

Alt + H + B

17. To remove outline border

Ctrl + Shift + _

18. To add an outline to the select cells

Ctrl + Shift + &

19. To move to the next cell

Tab

20. To move to the previous cell

Shift + Tab

21. To select all the cells on the right

Ctrl + Shift + Right arrow

22. To select all the cells on the left

Ctrl + Shift + Left Arrow

23. To select the column from the selected cell to the end of the table

Ctrl + Shift + Down Arrow

24. To select all the cells above the selected cell

Ctrl + Shift + Up Arrow

25. To select all the cells below the selected cell

Ctrl + Shift + Down Arrow

26. To add a comment to a cell

Shift + F2

27. To delete a cell comment

Shift + F10 + D

28. To display find and replace

Ctrl + H

29. To activate the filter

Ctrl + Shift + L

Alt + Down Arrow

30. To insert the current date

Ctrl + ;

31. To insert current time

Ctrl + Shift + :

32. To insert a hyperlink

Ctrl + k

33. To apply the currency format

Ctrl + Shift + $

34. To apply the percent format

Ctrl + Shift + %

35. To go to the “Tell me what you want to do” box

Alt + Q

36. To select the entire row

Shift + Space

37. To select the entire column

Ctrl + Space

38. To delete a column

Alt+H+D+C

39. To delete a row

Shift + Space, Ctrl + - 

40. To hide selected row

Ctrl + 9

41. To unhide selected row

Ctrl + Shift + 9

42. To hide a selected column

Ctrl + 0

43. To unhide a selected column

Ctrl + Shift + 0

44. To group rows or columns

Alt + Shift + Right arrow

45. To ungroup rows or columns

Alt + Shift + Left arrow

46. To group pivot table items

Alt + Shift + Right arrow

47. To ungroup pivot table items

Alt + Shift + Left arrow

48. To hide pivot table items

Ctrl + -

49. To create a pivot chart on the same sheet

Alt + F1

50. To create a pivot chart on a new worksheet

F11      


THERE ARE MANY MORE WHICH YOU CAN SEE IN OUR VIDEO : - SHORTCUT KEYS IN MS-EXCEL - https://youtu.be/Ew2gNb2Y_Gw

 

Comments

Post a Comment

Popular posts from this blog

PRINTING TWO BANK DETAILS IN TALLY

Image
PRINTING TWO BANK DETAILS IN TALLY When we Print a BILL OF SUPPLY i.e. a sales bill we can activate to print our account details in the bill. But what if we want to print Two account details in Tally. For this we have to add a TDL file to our Tally which will allow us to print two account details in a Sales Bill. THIS SHOULD APPEAR ON THE BILL First of all we have to download a bank details TDL file (which you can download from internet). Place the file in a folder and copy its location by clicking on properties of the file. In security tab one can find the details of the file. Now open Tally and press CTRL+ALT+T to open TDL Management. Press F4 to enter Manage Local TDLs. Now in Tally 9.0 ERP you have to use CTRL+ALT+V to paste the file details. But in Tally Prime you can directly specify path and select the file.  THIS WILL APPEAR CTRL+ALT+T THIS WILL APPEAR -  F4 (Manage Local TDLs) Once your file is properly loaded restart your Tally now you can see a new option under Disp...
Read more

CONVERTING TEXT TO TABLE

Image
 CONVERTING TEXT TO TABLE BEFORE LEARING CONVERTING TEXT TO TABLE LETS KNOW ABOUT SOME FACTS OF  TABLES IN MS-WORD Table by default have 2 Rows & 5 Columns. Maximum number of Columns that can be inserted is 63 Maximum number of Rows that can be inserted is 32767 Table can be converted to simple text & vice-versa, options are available in 1.    INSERT MENU - TABLE - CONVERT TEXT TO TABLE 2.   W hen we have our cursor on table we get option of CONVERT TABLE TO TEXT under LAYOUT MENU. For converting simple text to table you can use any symbol of your choice to make a difference between data. EXAMPLE NAME,CLASS,SEC RAM,10,A HARI,10,B LILA,10,A Simply select the above data and go to table tab under insert menu and click on convert text to table. You will get a dialogue box where you have to choose the separate text at if you have given any other symbol other than comma (,). In other you have to define that symbol. Else you simply ...
Read more

10 common uses of computers

  10 common uses of computers: Communication: Computers are widely used for communication purposes, including sending emails, instant messaging, video conferencing, and social media platforms. Internet Browsing: Computers enable users to browse the internet, search for information, read news articles, watch videos, and access various online services. Education: Computers play a crucial role in education, providing access to online courses, digital textbooks, educational software, and research materials. Entertainment: Computers are used for various forms of entertainment, such as playing video games, streaming movies and TV shows, listening to music, and reading e-books. Business and Finance: Computers are extensively used in business environments for tasks like accounting, inventory management, data analysis, financial modeling, and online banking. Graphic Design and Multimedia: Computers are indispensable in graphic design, digital art creation, photo editing, video editing, anim...
Read more