Learning Excel: Shortcut keys using Ctrl Tab



Quick Summary
This article provides a comprehensive guide to 41 essential Excel shortcuts utilising the Ctrl key. These shortcuts cover a wide range of functions, from basic operations like copying and pasting to more advanced tasks such as formatting cells, managing worksheets, and navigating your workbook efficiently. Learning these commands can significantly speed up your work in Excel.

Excel is one of the most powerful spreadsheets for your calculation, graphing tools, pivot tables, and macro programming needs.

Excel Ctrl Tab Shortcuts: Boost Your Productivity

In this article, we will discuss 41 shortcuts on excel that can be done using the Ctrl Tab

1. Ctrl+A : Select all contents of a worksheet.

2. Ctrl+B : Bold all cells in the highlighted section.

3. Ctrl+C : Copy

4. Ctrl+V : Paste

5. Ctrl+O :Open an existing workbook.

6. Ctrl+N : Create a new workbook.

7. Ctrl+S : Save

8. Ctrl+W : Close a workbook.

9. Ctrl+F : Search the current sheet.

10. Ctrl+H : Find and replace.

11. Ctrl+Z : Undo a section

12. Ctrl+Y : Redo a section.

13. Ctrl+K : Inserts a hyperlink

14.Ctrl+X : Cuts the contents of a cell or a selected content.

15. Ctrl+B : Do/redo Bold.

16. Ctrl+I : Do/Redo Italics

17. Ctrl+U : Underline

18.Ctrl+F1 : Show or hide the ribbon.

19. Ctrl+F2 : Open Print preview

20. Ctrl+F4 : Close Excel.

21. Ctrl+F9 : Minimize workbook.

22. Ctrl+F10 : Restore workbook.

23. Ctrl+Shift+; : Insert the time in the active cell.

24. Ctrl+Shift+# : Insert the date format in dd/mm/year format

25. Ctrl+Shift+( : Unhides any rows in the selected area.

26. Ctrl+Shift+) : Unhides any column in the selected area.

27.Ctrl+9 : Hide Row.

28. Ctrl+0 : Hide column.

29.Ctrl+Shift+$ : Currency format.

30. Ctrl+Shift+% : Percentage format.

31. Ctrl+Shift+& : Apply Outline border.

32. Ctrl+Shift+_ : Remove Outline border.

33. Ctrl+Space : Select the entire column

34.Ctrl+Shift+Space : Select the entire workbook

35. Shift+Space : Select the entire row.

36. Ctrl+Home : Move to the beginning of the workbook.

37. Ctrl+PgUp : Move to the previous sheet.

38. Ctrl+PgDn : Move to the next sheet.

39. Ctrl+End : Move to the most bottom right used cell. :

40. Ctrl+UP arrow : Move to the top cell of the column.

41.Ctrl+Down arrow : Move to the bottom of the column.

 
 

23307 Views 17 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
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details