Excel Shortcuts
1. To edit a cell
F2
2. To copy and paste cells
Ctrl + C, Ctrl + V
3. To italicize and make the font bold
Ctrl + I, Ctrl + B
4. To center align cell contents
Alt + H + A + C
5. To fill color
Alt + H + H
6. To add a border
Alt + H + B
7. To remove outline border
Ctrl + Shift + _
8. To add an outline to the select cells
Ctrl + Shift + &
9. To move to the next cell
Tab
10. To move to the previous cell
Shift + Tab
11. To select all the cells on the right
Ctrl + Shift + Right arrow
12. To select all the cells on the left
Ctrl + Shift + Left Arrow
13. To select the column from the selected cell to the end of the table
Ctrl + Shift + Down Arrow
14. To select all the cells above the selected cell
Ctrl + Shift + Up Arrow
15. To select all the cells below the selected cell
Ctrl + Shift + Down Arrow
16. To add a comment to a cell
Shift + F2
17. To delete a cell comment
Shift + F10 + D
18. To display find and replace
Ctrl + H
19. To activate the filter
Ctrl + Shift + L
Alt + Down Arrow
20. To insert the current date
Ctrl + ;
21. To insert current time
Ctrl + Shift + :
22. To insert a hyperlink
Ctrl + k
23. To apply the currency format
Ctrl + Shift + $
24. To apply the percent format
Ctrl + Shift + %
25. To go to the “Tell me what you want to do” box
Alt + Q