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.
CAclubindia
Very useful sir.This is the first article I am seeing in a gap of few years. Thank you so much sir.
Thank you so much for your kind words...