Excel is one of the most powerful spreadsheets for your calculation, graphing tools, pivot tables, and macro programming needs.
![Learning Excel: Shortcut keys using Ctrl Tab Learning Excel: Shortcut keys using Ctrl Tab](/img/preview/custom/20210314162705_excel.jpg)
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.