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

MAIL MERGE IN PAGEMAKER

Image
  MAIL MERGE IN PAGEMAKER We all know about Mail Merge feature in MS-Word. Like Word PageMaker also provides us the facility to Mail Merge which is here known as Data Merge.  Data Merge can be found under Window Menu - Plug-in Palettes - Show Data Merge Palette . When we click on Show Data Merge Palette we get a new Tool Bar on Screen as Data Merge. On Data Merge Tool Bar we have to click on Select Data Source. Where we get a dialogue box which provides option to choose a file with extension CSV or TXT.  For making a CSV file we can easily use excel and feed the data required accordingly.  Now type a letter which has to be commonly send or matter on which data is to be merged. Here I will explain Data Merge with an Example. I had fed the following data in MS-Excel & save it as .CSV in my computer. .CSV which I had chosen shows as .CSV (comma delimited) While entering data always start with the very first cell of the sheet. And first row will always contain the headings. As I have
Read more

Paste Special in MS-Excel

Image
Paste Special in MS-Excel Paste Special in MS-Excel provides many options. When we copy any data and simply paste it to some other cell it is copied with all its settings such as formula, font size, comments, etc. which are in it.  But Paste Special provides us the facility to not to copy things which we don't want. Here I would try to describe all basic points.  First of all we will see how Paste Special looks like when we copy any data and open the Paste Special Window. It may differ from the type of data copied.  Here we can see under paste many things are written. I have already described all above. Formulas: When we copy a cell which contains formula and we want to only paste that formula on a particular cell we use this.  Value: When we want to copy the value in cell to any other place than we have to use this.  Formats: This is used to copy the formatting of a cell to another cell. For example if we have changed the font size of a cell or change the format of data to date fr
Read more

How to use Whatsapp on your Computer?

Image
How to use Whatsapp on your Computer? Most of us know that we can use Whatsapp on mobile only. In this blog I would like to share how to use Whatsapp on Computer. For using Whatsapp on Computer we should have  1. Mobile with Whatsapp installed. 2. Computer with Internet facility. 3. Browser installed on Computer (normally all computers have it). We have to open our preferred browser, you can use any Google Chrome, Microsoft Edge, Torch, etc.  Here in the address bar you have to type:  web.whatsapp.com  Once you entered this a page would appear  with QR Code  as given below: In computer following instructions appear: Once you follow the above instructions properly you can see your mobile groups and contacts on computer on left side and in right side you can see your chat.  It makes easy for you to get your data downloaded on computer or sending any computer file to your contacts.  You can send following things as attachments: 1. Create Room: With this option you can create a room for a
Read more