Learning Excel: Shortcut keys using Alt Key

CA Anurag Sharma | Last updated: 22 March 2021

Save Share

Quick Summary

Discover 25 essential Excel shortcuts using the Alt key to significantly speed up your workflow. This guide covers shortcuts for navigating tabs, formatting cells, inserting charts and pivot tables, managing worksheets, and even performing advanced tasks like text to columns and macro execution. Mastering these shortcuts can transform your Excel productivity.

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.

Excel Alt Key Shortcuts: Boost Your Productivity

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

FAQ :

You can quickly access different tabs by pressing Alt followed by the letter for that tab, such as Alt+H for the Home tab, Alt+W for the View tab, Alt+M for the Formula tab, and Alt+P for the Page Layout tab. Alt+Tab allows you to switch between different applications.

To change the cell colour, use Alt+H+H. For font colour, press Alt+H+FC. To adjust the font size, use the shortcut Alt+H+FS.

You can create a new worksheet with Alt+H+I+S, delete a worksheet using Alt+H+D+S, hide a sheet with Alt+H+O+U+S, and unhide a sheet by pressing Alt+H+O+U+H.

To insert a pivot table, use Alt+N+V. For a column chart, press Alt+N+C. You can insert any chart with Alt+F1.

Yes, the shortcut Alt+A+E+F is used for the 'Text to Column' feature, and Alt+M+D is for Formula Tracing.

To start a new line within the same cell, press Alt+Enter.