Mega Offer Avail 65% Off in CA IPCC and 50% Off in all CA CS CMA subjects.Coupon- IPCEXAM65 & EXAM50. Call: 088803-20003

CA Final Online Classes
CA Classes

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Learning Excel: Shortcut keys using Alt Key

CA ANURAG 
Updated on 22 March 2021

LinkedIn


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.

Learning Excel: Shortcut keys using 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

 

Tags :



Category Students
Other Articles by -
CA ANURAG 

Report Abuse

LinkedIn



Comments


update