100 Excel shortcuts

November 26, 2024

By: ATB Team

100 Excel shortcuts

Below is an extensive list of Excel keyboard shortcuts to help you work more efficiently. You can either scroll through the entire list or use the Index to jump directly to the section you need.

ShortcutDescription
1. Ctrl + Arrow keysMove to the edge of data in the direction of the arrow (left, right, up, or down).
2. HomeMove to the beginning of the current row.
3. Ctrl + HomeMove to the first cell (A1) of the worksheet.
4. Ctrl + EndMove to the last cell with data.
5. Page UpMove up one screen in the worksheet.
6. Page DownMove down one screen in the worksheet.
7. Ctrl + Page UpMove to the previous worksheet.
8. Ctrl + Page DownMove to the next worksheet.
9. Alt + TabSwitch between open applications.
10. Ctrl + ASelect all cells in the worksheet.
11. Shift + SpacebarSelect the entire row of the active cell.
12. Ctrl + SpacebarSelect the entire column of the active cell.
13. Ctrl + Shift + Arrow keysSelect all data in the direction of the arrow.
14. Shift + Arrow keysExtend the selection one cell at a time in the direction of the arrow.
15. Ctrl + Shift + LToggle AutoFilter on or off for the selected range.
16. Ctrl + Shift + “+”Insert a new row or column.
17. Ctrl + “-“Delete the selected row or column.
18. Ctrl + Shift + 9Unhide rows.
19. Ctrl + 9Hide selected rows.
20. Ctrl + Shift + 0Unhide columns.
21. Ctrl + 0Hide selected columns.
22. Ctrl + CCopy the selected data.
23. Ctrl + XCut the selected data.
24. Ctrl + VPaste the copied or cut data.
25. Ctrl + ZUndo the last action.
26. Ctrl + YRedo the last undone action.
27. DeleteClear the contents of the selected cell(s).
28. Ctrl + DFill down (copy the content from the cell above).
29. Ctrl + RFill right (copy the content from the left cell).
30. Alt + E, S, VPaste values only (useful when you want to paste data without formulas or formatting).
31. F2Edit the active cell.
32. Ctrl + BToggle bold formatting.
33. Ctrl + IToggle italic formatting.
34. Ctrl + UToggle underline formatting.
35. Ctrl + 1Open the Format Cells dialog box.
36. Ctrl + Shift + $Apply the currency format to the selected cells.
37. Ctrl + Shift + %Apply the percentage format to the selected cells.
38. Ctrl + Shift + #Apply the date format to the selected cells.
39. Ctrl + Shift + !Apply number format with two decimal places.
40. Alt + E, S, FPaste special and open the Format Cells dialog box.
41. Ctrl + Shift + &Add borders to the selected cells.
42. Ctrl + Shift + _Remove borders from the selected cells.
43. Alt + Equals (=)Automatically insert a SUM formula for the selected range.
44. F4Repeat the last action (or toggle between absolute and relative references in a formula).
45. Ctrl + ` (grave accent)Toggle between displaying formulas and the result of the formulas.
46. Ctrl + Shift + EnterEnter an array formula.
47. Ctrl + Shift + UExpand or collapse the formula bar.
48. Ctrl + Shift + F3Open the Name Manager dialog box.
49. Ctrl + F3Open the Name Manager dialog box to define or manage named ranges.
50. Ctrl + FOpen the Find dialog box to search for specific content.
51. Ctrl + HOpen the Find and Replace dialog box to search and replace content.
52. Ctrl + POpen the Print dialog box.
53. Ctrl + KInsert a hyperlink.
54. Ctrl + SSave the current workbook.
55. Alt + F4Close the Excel application.
56. Ctrl + TCreate a table from the selected range.
57. Ctrl + NOpen a new workbook.
58. Ctrl + OOpen an existing workbook.
59. Ctrl + WClose the current workbook.
60. Ctrl + QShow the Quick Analysis tool (when a range is selected).
61. Ctrl + F2Open Print Preview mode.
62. Ctrl + F7Move the current workbook window.
63. Ctrl + F8Resize the current workbook window.
64. Ctrl + F9Minimize the workbook window.
65. Ctrl + F10Maximize the workbook window.
66. Alt + HGo to the Home tab on the ribbon.
67. Alt + EGo to the Edit menu.
68. Alt + IGo to the Insert menu.
69. Alt + WGo to the View menu.
70. Alt + MGo to the Formulas tab.
71. Ctrl + Shift + FOpen the Format Cells dialog box directly to the Font tab.
72. Ctrl + Shift + POpen the Format Cells dialog box directly to the Protection tab.
73. Alt + F1Create a chart of the selected data in the current worksheet.
74. F3Paste a defined name into a formula.
75. Ctrl + Shift + LTurn on or off AutoFilter.
76. Ctrl + Shift + TCreate a new worksheet.
77. Ctrl + Alt + VOpen the Paste Special dialog box.
78. Ctrl + Shift + OSelect all cells with comments.
79. Ctrl + Shift + KInsert a hyperlink.
80. Ctrl + Shift + ZUndo the last Zoom action.
81. Alt + F8Open the Macro dialog box.
82. F11Create a chart based on selected data in a new worksheet.
83. Ctrl + Shift + 5Apply percentage formatting.
84. Ctrl + F11Insert a new macro sheet.
85. Alt + AGo to the Data tab on the ribbon.
86. Alt + NGo to the Insert tab on the ribbon.
87. Ctrl + Shift + “+”Insert a new row or column.
88. Ctrl + Shift + “-“Delete the selected row or column.
89. Ctrl + Shift + 1Apply number formatting with two decimal places.
90. Ctrl + Shift + EExpand the Excel options in the ribbon.
91. Ctrl + Alt + Shift + F9Recalculate all open workbooks.
92. Ctrl + Alt + DOpen the Data tab of the ribbon.
93. Ctrl + Alt + MOpen the Macro dialog box.
94. Alt + Shift + F1Insert a new worksheet.
95. Alt + N + VInsert a PivotTable.
96. Ctrl + Shift + 7Add or remove borders from selected cells.
97. Ctrl + Shift + FOpen the Format Cells dialog box for font settings.
98. CtrlFill the selected cells with the content from the cell above.
99. Ctrl + Shift + EApply “E” style formatting (currency, percentage, etc.).
100. Ctrl + Shift + HHide the selected columns or rows.

Leave a Comment