CA Anurag Sharma
Excel is one of the most powerful spreadsheets for your calculation, graphing tools, pivot tables, and macro programming needs. Continuing our series regarding excel shortcut, here's a list of 25 excel shortcuts using the Alt Key.
1. Alt+Tab : Move to other applications
2. Alt+H+I+S : New worksheet
3. Alt+H+H : Cell color
4. Alt+H+FC : Font Color
5. Alt+H+FS : Font Size
6. Alt+N+V :Insert Pivot Table
7. Alt+N+C : Insert Column Chart
8. Alt+H+D+S : Delete a worksheet.
9. Alt+H+O+U+S : Hide a sheet
10. Alt+H+O+U+H : Unhide a sheet
11. Alt+H :Go to Home tab
12. Alt+W : Go to View Tab
13. Alt+M : Go to Formula Tab
14. Alt+P : Open the page layout
15. Ctrl+Alt+ : Zoom in
16. Ctrl+Alt- : Zoom Out
17. Alt+ Enter : Start a new line in the same cell.
18. Alt+F8 : Macros
19. Alt+F : Open the File Page
20. Alt+M+D : Formula Tracing
21. Alt+A+E+F : Text to Column
22. Alt+W+F+F : Freeze and unfreeze panes
23. Ctrl+ Alt+ Shift : Check dependent Formula
24. Alt+F1 : Insert a chart
25. Alt+Backspace : Undo the last action.
Also Read: Learning Excel: Shortcut keys using Ctrl Tab
CAclubindia
