15 Advanced Excel Shortcut Keys

• Navigation
1. Move to last used cell → Ctrl + End
2. Move to first cell → Ctrl + Home
3. Select to last used cell → Ctrl + Shift + End
4. Select to first cell → Ctrl + Shift + Home

• Rows  Columns
5. Insert entire row → Ctrl + Shift + +
6. Delete entire row → Ctrl + -
7. Hide selected rows → Ctrl + 9
8. Unhide rows → Ctrl + Shift + 9
9. Hide selected columns → Ctrl + 0
10. Unhide columns → Ctrl + Shift + 0

• Formatting
11. Open Format Cells → Ctrl + 1
12. Apply General format → Ctrl + Shift + ~
13. Apply Number format → Ctrl + Shift + !
14. Apply Percentage format → Ctrl + Shift + %
15. Apply Currency format → Ctrl + Shift + $

Double Tap ♥️ For More