Learning Excel: Shortcut keys using Alt Key



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

 

17154 Views 9 Likes Comment   Share Students   Report


About the Author

CA

CA, MBA(Finance), DISA, FAFD, writer of two novels and also run a youtube channel Concept Decoded. Twitter handle caanuragwriter

Comments :

Related Articles


Loading


Popular Articles





CCI Pro

CCI Articles

submit article


Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Article Assistant

Jitendra Agarwal & Associates

Bengaluru

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details