The most easy and effective way to learn MS Excel is learning the most useful and basic Shortcuts of it, which can help to speed up your work.
So,
Here, You will find the entire list of easy and useful shortcuts that can help you work faster with MS Excel. Hope this shortcuts helps you to have your hour's work to complete in minute's time.
You can also learn it by yourself.Open MS Excel, after it's ready, Just Press " ALT ". Now You will see Alphabet with Underline all over. This are all shortcuts you see.
Below mentioned are 35 Most Basic and Useful Shortcuts, you can try it.
1. To Edit Cell: F2
2. To Change Cell Height: ALT + H + O + H
3. To Change Column Width: ALT + H + O + W
4. Auto Fit Cell Height: ALT + H + O + A
5. Auto Fit Column Width: ALT + H + O + I
6. To Add or Edit Comment of Cell: F2 + SHIFT
7. For Cell Border: ALT + H + B
8. For More Cell border: ALT + H + B + M
9. For Cell Color fill: ALT + H + H
10. Align cell text in Center: ALT + H + A + C
11. Align cell text in Right: ALT + H + A + R
12. Align cell text in Left: ALT + H + A + L
13. Align cell text in Middle: ALT + H + A + M
14. Align cell text in Top: ALT + H + A + T
15. Align cell text in Bottom: ALT + H + A + B
16. To Wrap Text: ALT + H + W
17. Increase Font: ALT + H + F + G
18. Decrease Font: ALT + H + F + K
19. To Insert Date: CRTL + ( ; )
20. To Insert Time: (PRESS AND HOLD CRTL + SHIFT) + ( ; )
21. Multiple Cell Selection: SHIFT(PRESS & HOLD) + USE ARROW KEY
22. Quick Cell Selection of Row or Column: (PRESS & HOLD CRTL + SHIFT) + USE ARROW KEY
23. To select entire Row: CRTL + SPACEBAR
24. To select entire Column: SHIFT + SPACEBAR
25. To Add Entire Row or Entire Column: CTRL + (+)
26. To Delete Entire Row or Entire Column: CTRL + (-)
27. To Merge cells: ALT + H + M + M
28. To Unmerge cells: ALT + H + M + U
29. To Add new Sheet: SHIFT + F11
30. To Delete Sheet: ALT + H + D + S
31. To Rename Sheet:ALT + H + O + R
32. Move to Next Sheet: CTRL + PG DOWN
33. Move to Previous Sheet: CTRL + PG UP
34. Change Text to Upper Case: Formula=UPPER(cell)
35. Change Text to Lower Case: Formula=Lower(cell)
Good Luck..!!
0 Comments