In the realm of Excel mastery, efficiency is key. Knowing the right keyboard shortcuts can transform your Excel experience from mundane to magical. Whether you’re a spreadsheet novice or a seasoned pro, these 100 keyboard shortcuts will elevate your Excel game to new heights.

1. Ctrl + A: Select all – This selects the entire worksheet.
2. Ctrl + B: Bold – Applies bold formatting to the selected text.
3. Ctrl + C: Copy – Copies the selected cells or text to the clipboard.
4. Ctrl + D: Fill down – Copies the contents of the topmost cell in a selected range into the cells below.
5. Ctrl + F: Find – Opens the Find dialog box to search for specific content within the worksheet.
6. Ctrl + G: Go to – Opens the Go To dialog box to navigate to a specific cell or range.
7. Ctrl + H: Replace – Opens the Replace dialog box to find and replace specific content within the worksheet.
8. Ctrl + I: Italic – Applies italic formatting to the selected text.
9. Ctrl + K: Insert hyperlink – Inserts a hyperlink into the selected cell.
10. Ctrl + N: New workbook – Opens a new Excel workbook.
11. Ctrl + O: Open – Opens an existing Excel workbook.
12. Ctrl + P: Print – Opens the Print dialog box to print the current worksheet.
13. Ctrl + R: Fill right – Copies the contents of the leftmost cell in a selected range into the cells to the right.
14. Ctrl + S: Save – Saves the current workbook.
15. Ctrl + U: Underline – Applies underline formatting to the selected text.
16. Ctrl + V: Paste – Pastes the contents of the clipboard into the selected cells.
17. Ctrl + W: Close – Closes the current workbook.
18. Ctrl + X: Cut – Cuts the selected cells or text and copies them to the clipboard.
19. Ctrl + Y: Redo – Redoes the last undone action.
20. Ctrl + Z: Undo – Undoes the last action.
21. Ctrl + 1: Format cells dialog box – Opens the Format Cells dialog box for the selected cells.
22. Ctrl + 2: Bold – Applies bold formatting to the selected text.
23. Ctrl + 3: Italic – Applies italic formatting to the selected text.
24. Ctrl + 4: Underline – Applies underline formatting to the selected text.
25. Ctrl + 5: Strikethrough – Applies strikethrough formatting to the selected text.
26. Ctrl + 6: Show/hide objects – Shows or hides objects such as charts, pictures, etc.
27. Ctrl + 7: Show/hide standard toolbar – Shows or hides the standard toolbar.
28. Ctrl + 8: Toggle outline symbols – Toggles the display of outline symbols.
29. Ctrl + 9: Hide rows – Hides the selected rows.
30. Ctrl + 0: Hide columns – Hides the selected columns.
31. Ctrl + ‘ (apostrophe): Copy value from cell above – Copies the value from the cell directly above the active cell.
32. Ctrl + Shift + ” (double quotation marks): Copy formula from cell above – Copies the formula from the cell directly above the active cell.
33. Ctrl + Shift + +: Insert – Inserts new cells, rows, or columns depending on the selection.
34. Ctrl + –: Delete – Deletes the selected cells, rows, or columns.
35. Ctrl + Shift + &: Apply outline border – Applies an outline border to the selected cells.
36. Ctrl + Shift + _: Remove outline border – Removes the outline border from the selected cells.
37. Ctrl + Shift + ~: General format – Applies the general number format to the selected cells.
38. Ctrl + Shift + $: Currency format – Applies the currency format to the selected cells.
39. Ctrl + Shift + %: Percentage format – Applies the percentage format to the selected cells.
40. Ctrl + Shift + ^: Exponential format – Applies the exponential format to the selected cells.
41. Ctrl + Shift + #: Date format – Applies the date format to the selected cells.
42. Ctrl + Shift + @: Time format – Applies the time format to the selected cells.
43. Ctrl + Shift + !: Number format – Applies the number format to the selected cells.
44. **Ctrl + Shift + ***: Select current region around active cell – Selects the current region around the active cell.
45. **Ctrl + Shift + &: Outline border – Applies an outline border to the selected cells.
46. Ctrl + Shift + _: Remove outline border – Removes the outline border from the selected cells.
47. Ctrl + Shift + ~: Apply general number format – Applies the general number format to the selected cells.
48. Ctrl + Shift + $: Apply currency format – Applies the currency format to the selected cells.
49. Ctrl + Shift + %: Apply percentage format – Applies the percentage format to the selected cells.
50. Ctrl + Shift + ^: Apply exponential format – Applies the exponential format to the selected cells.
51. Ctrl + Shift + #: Apply date format – Applies the date format to the selected cells.
52. Ctrl + Shift + @: Apply time format – Applies the time format to the selected cells.
53. Ctrl + Shift + !: Apply number format – Applies the number format to the selected cells.
54. **Ctrl + Shift + ***: Select visible cells – Selects only the visible cells within the selected range.
55. **Ctrl + Shift + <: Unhide rows – Unhides the hidden rows within the selected range.
56. Ctrl + Shift + >: Unhide columns – Unhides the hidden columns within the selected range.
57. Ctrl + Shift + ?: Open Insert Function dialog – Opens the Insert Function dialog box to insert a function into the formula.
58. Ctrl + Shift + A: Insert argument names into formula – Inserts the argument names of a function into the formula.
59. Ctrl + Shift + L: Toggle AutoFilter – Applies or removes the AutoFilter feature.
60. Ctrl + Shift + S: Apply or remove strikethrough formatting – Applies or removes strikethrough formatting from the selected text.
61. Ctrl + Shift + F: Apply or remove bold formatting – Applies or removes bold formatting from the selected text.
62. Ctrl + Shift + I: Insert new worksheet – Inserts a new worksheet into the workbook.
63. Ctrl + Shift + O: Select all cells with comments – Selects all cells within the worksheet that contain comments.
64. Ctrl + Shift + U: Expand formula bar – Expands the formula bar to display lengthy formulas.
65. Ctrl + Shift + F3: Create names from values in selected cells – Creates named ranges based on the values in the selected cells.
66. Ctrl + Shift + F6: Previous workbook – Switches to the previous open workbook.
67. Ctrl + Shift + F9: Calculate all worksheets in all open workbooks – Recalculates all worksheets in all open workbooks.
68. Ctrl + Shift + F10: Activate the ruler – Activates the ruler for use in formatting.
69. Ctrl + Shift + F11: New workbook – Inserts a new workbook into the current Excel instance.
70. Ctrl + Shift + F12: Open – Opens an existing workbook.
71. Ctrl + Shift + F2: Save – Saves the current workbook.
72. Ctrl + Shift + F3: Paste function into formula – Pastes a function into the formula.
73. Ctrl + Shift + F4: Find next – Finds the next occurrence of the search term.
74. Ctrl + Shift + F5: Find – Opens the Find dialog box to search for specific content within the worksheet.
75. Ctrl + Shift + F6: Next workbook – Switches to the next open workbook.
76. Ctrl + Shift + F7: Move window – Allows you to move the Excel window.
77. Ctrl + Shift + F8: Add to selection – Adds the current selection to the existing selection.
78. Ctrl + Shift + F9: Calculate active worksheet – Recalculates the active worksheet.
79. Ctrl + Shift + F10: Maximize window – Maximizes the Excel window.
80. Ctrl + Shift + F11: Insert new worksheet – Inserts a new worksheet into the workbook.
81. Ctrl + Shift + F12: Print – Opens the Print dialog box to print the current worksheet.
82. Ctrl + Shift + F1: What’s This? – Displays Help information about the selected command or control.
83. Ctrl + Shift + F2: Save As – Saves the current workbook with a new filename.
84. Ctrl + Shift + F3: Define name – Opens the New Name dialog box to define a new named range.
85. Ctrl + Shift + F4: Close workbook – Closes the current workbook.
86. Ctrl + Shift + F5: Edit – Opens the Go To dialog box.
87. Ctrl + Shift + F6: Previous window – Switches to the previous Excel window.
88. Ctrl + Shift + F7: Move window – Allows you to move the Excel window.
89. Ctrl + Shift + F8: Add to selection – Adds the current selection to the existing selection.
90. Ctrl + Shift + F9: Calculate active worksheet – Recalculates the active worksheet.
91. Ctrl + Shift + F10: Maximize window – Maximizes the Excel window.
92. Ctrl + Shift + F11: Insert new worksheet – Inserts a new worksheet into the workbook.
93. Ctrl + Shift + F12: Print – Opens the Print dialog box to print the current worksheet.
94. Ctrl + Shift + N: Create new workbook – Creates a new Excel workbook.
95. Ctrl + Shift + O: Select entire column – Selects the entire column containing the active cell.
96. Ctrl + Shift + P: Break – Inserts a page break above the selected cell.
97. Ctrl + Shift + R: Fill right – Copies the contents of the leftmost cell in a selected range into the cells to the right.
98. Ctrl + Shift + S: Apply or remove strikethrough formatting – Applies or removes strikethrough formatting from the selected text.
99. Ctrl + Shift + T: Add or remove strikethrough from cell – Applies or removes strikethrough formatting from the selected cell.
100. Ctrl + Shift + V: Paste special – Opens the Paste Special dialog box to paste copied content with various options.

These shortcuts cover a wide range of tasks in Excel, from basic formatting to more advanced features like navigating the workbook and applying formulas. Learning and using these shortcuts can greatly improve your efficiency and productivity when working with Excel. So, go ahead, try them out, and unlock the full potential of Excel at your fingertips!