excel shortcuts for lightning-fast data entry

Comprehensive list of Excel shortcuts for lightning-fast data entry

These shortcuts cover a range of common tasks in Excel and can help you become more efficient and productive when working with large amounts of data.

1. AutoFill: Use the fill handle to quickly copy a formula or data pattern down a column or across a row. To do this, simply select the cell(s) with the pattern you want to copy, hover over the bottom right corner of the selection until the fill handle appears, and drag it in the desired direction.
2. Alt + “=” (equal sign): This shortcut automatically creates a SUM formula for the selected cells.
3. Ctrl + “;” (semicolon): This shortcut inserts the current date into a cell.
4. Ctrl + Shift + “:” (colon): This shortcut inserts the current time into a cell.
5. F2: Use this key to quickly edit the contents of a cell.
6. Ctrl + D: This shortcut copies the contents of the cell above the current cell into the current cell.
7. Ctrl + R: This shortcut copies the contents of the cell to the left of the current cell into the current cell.
8. Tab: Use this key to quickly move to the next cell in a row.
9. Enter: Use this key to quickly move to the next cell in a column.
10. Ctrl + Enter: This shortcut fills the selected cells with the contents of the active cell.
11. Alt + Enter: This shortcut allows you to enter multiple lines of text within a single cell.
12. Ctrl + Shift + A: This shortcut inserts the argument names and parentheses of a selected function into the formula bar.
13. Ctrl + Spacebar: This shortcut selects the entire column of the active cell.
14. Shift + Spacebar: This shortcut selects the entire row of the active cell.
15. Ctrl + Shift + “+”: This shortcut inserts a new row or column into the worksheet.
16. Ctrl + “-“: This shortcut deletes the selected row(s) or column(s) from the worksheet.
17. Ctrl + Home: This shortcut moves the cursor to the first cell of the worksheet (A1).
18. Ctrl + End: This shortcut moves the cursor to the last cell of the worksheet that contains data.
19. Ctrl + Page Up/Down: These shortcuts allow you to switch between worksheets in a workbook.
20. Ctrl + Shift + L: This shortcut applies or removes filters in a table.
21. Alt + Down Arrow: This shortcut opens the drop-down menu of a selected cell or toolbar button.
22. Ctrl + “`” (grave accent): This shortcut toggles between displaying formulas and values in cells.
23. Ctrl + Shift + “~” (tilde): This shortcut applies the General number format to the selected cells.
24. Ctrl + Shift + “$”: This shortcut applies the Currency number format to the selected cells.
25. Ctrl + Shift + “%”: This shortcut applies the Percentage number format to the selected cells.
26. Ctrl + Shift + “#”: This shortcut applies the Date number format to the selected cells.
27. Ctrl + Shift + “@”: This shortcut applies the Time number format to the selected cells.
28. F4: This shortcut repeats the last action performed in Excel.
29. Ctrl + Shift + F: This shortcut opens the Find and Replace dialog box.
30. Ctrl + Shift + $ or % or ^ for superscript or & for subscript: Applies currency, percentage, exponentiation or subscript formatting to the selected cells.

31. Ctrl + Shift + & (ampersand): This shortcut applies the border outline to the selected cells.
32. Ctrl + Shift + _ (underscore): This shortcut removes the border from the selected cells.
33. Ctrl + Shift + * (asterisk): This shortcut selects the current region around the active cell.
34. Ctrl + Shift + T: This shortcut converts a range of data into a table.
35. Ctrl + Shift + O: This shortcut selects all the cells with formulas that directly reference the active cell.
36. Ctrl + Shift + P: This shortcut opens the Format Cells dialog box.
37. Ctrl + Shift + E: This shortcut activates the Flash Fill feature, which automatically fills in values based on patterns it recognizes in your data.
38. Ctrl + Shift + K: This shortcut inserts a hyperlink.
39. Ctrl + Y: This shortcut redoes the last undone action.
40. Ctrl + Z: This shortcut undoes the last action.
41. Alt + H + F + F: This shortcut opens the Font dialog box.
42. Alt + H + A + C: This shortcut clears the contents of the selected cells.
43. Ctrl + Shift + H: This shortcut applies or removes highlighting to the selected cells.
44. Ctrl + Shift + G: This shortcut opens the Go To dialog box.
45. Ctrl + B: This shortcut applies bold formatting to the selected cells.

46. Ctrl + I: This shortcut applies italic formatting to the selected cells.
47. Ctrl + U: This shortcut applies underline formatting to the selected cells.
48. Ctrl + Shift + F3: This shortcut creates a name from the selected cells.
49. F9: This shortcut calculates all worksheets in all open workbooks.
50. Shift + F11: This shortcut inserts a new worksheet into the workbook.
51. Ctrl + Shift + F6: This shortcut switches to the previous workbook window.
52. Ctrl + Shift + F12: This shortcut opens the Save As dialog box.
53. Ctrl + 1: This shortcut opens the Format Cells dialog box.
54. Ctrl + 5: This shortcut applies or removes strikethrough formatting to the selected cells.
55. Alt + H + O + I: This shortcut hides the selected rows.
56. Alt + H + O + U: This shortcut unhides the selected rows.
57. Alt + H + O + C: This shortcut hides the selected columns.
58. Alt + H + O + R: This shortcut unhides the selected columns.
59. Ctrl + F4: This shortcut closes the active workbook window.
60. Ctrl + Shift + F11: This shortcut inserts a new worksheet as a copy of the current worksheet.

61. Ctrl + Shift + F9: This shortcut calculates the active worksheet.
62. Ctrl + Shift + F10: This shortcut displays the right-click menu.
63. Alt + H + B + A: This shortcut adds a border to the selected cells.
64. Alt + H + F + C: This shortcut clears the formatting from the selected cells.
65. Ctrl + Shift + { or }: These shortcuts select all cells that contain precedents or dependents of the active cell.
66. Ctrl + Shift + ~ (tilde): This shortcut toggles between displaying the values and displaying the formulas in cells.
67. Ctrl + J: This shortcut opens the Fill dialog box.
68. Ctrl + T: This shortcut converts a range of data into a table.
69. Ctrl + Shift + F2: This shortcut saves a workbook as a PDF file.
70. Ctrl + Shift + F11: This shortcut inserts a new worksheet as a copy of the current worksheet.
71. Alt + H + H: This shortcut opens the Home tab on the ribbon.
72. Alt + W + N: This shortcut opens the View tab on the ribbon.
73. Alt + N + M: This shortcut opens the Formulas tab on the ribbon.
74. Alt + D + L: This shortcut opens the Data tab on the ribbon.
75. Alt + R + P: This shortcut opens the Review tab on the ribbon.

76. Ctrl + Shift + F7: This shortcut opens the Spelling dialog box.
77. Ctrl + Alt + V: This shortcut opens the Paste Special dialog box.
78. Ctrl + 9: This shortcut hides the selected rows.
79. Ctrl + Shift + ( or ): These shortcuts select all cells within a row or column that contains the active cell.
80. Ctrl + A: This shortcut selects all cells in the worksheet.
81. Ctrl + Shift + L: This shortcut displays or hides the filter drop-down arrows in a table or range of cells.
82. Ctrl + Shift + C: This shortcut copies the formatting from the selected cells.
83. Ctrl + Shift + V: This shortcut pastes the formatting into the selected cells.
84. Ctrl + Shift + U: This shortcut toggles the formula bar on and off.
85. Ctrl + K: This shortcut opens the Insert Hyperlink dialog box.
86. Ctrl + F1: This shortcut toggles the ribbon on and off.
87. Ctrl + F6: This shortcut switches to the next workbook window.
88. Ctrl + Shift + F12: This shortcut saves the workbook.
89. Ctrl + Shift + F4: This shortcut closes the active workbook without prompting to save changes.
90. Alt + H + M: This shortcut merges the selected cells.

91. Ctrl + Shift + F8: This shortcut toggles the Extend Selection mode on and off.
92. Ctrl + Backspace: This shortcut moves the cursor to the beginning of the word in the formula bar.
93. Ctrl + Shift + Backspace: This shortcut moves the cursor to the end of the word in the formula bar.
94. Alt + H + F + W: This shortcut opens the Page Setup dialog box.
95. Alt + W + T + F: This shortcut opens the Freeze Panes dropdown.
96. Shift + F3: This shortcut opens the Insert Function dialog box.
97. Ctrl + Shift + F5: This shortcut opens the Go To Special dialog box.
98. Ctrl + Shift + F12: This shortcut opens the Save As dialog box.
99. Ctrl + Shift + F11: This shortcut inserts a new worksheet as a copy of the current worksheet.
100. Ctrl + Shift + L: This shortcut displays or hides the filter drop-down arrows in a table or range of cells.

Related posts:

HLOOKUP Function in Excel How to Filter by Color in Excel vlookup vs hlookup Repeat Last Action in Excel