Learning Excel: Shortcut keys using Ctrl Tab

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

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.