Excel provides a wide range of keyboard shortcuts to help you work more efficiently and quickly. Here are 150 useful keyboard shortcuts for Excel for Windows:
Navigation and Selection Shortcuts
- Ctrl + A: Selects all cells in the current worksheet.
- Ctrl + Home: Moves to the beginning of the worksheet.
- Ctrl + End: Moves to the last cell in the worksheet.
- Ctrl + Arrow Key: Moves to the last filled cell in the direction of the arrow key.
- Shift + Arrow Key: Extends the selection by one cell in the direction of the arrow key.
- Ctrl + Shift + Arrow Key: Extends the selection to the last filled cell in the direction of the arrow key.
- Ctrl + Shift + Home: Selects all cells from the current position to the beginning of the worksheet.
- Ctrl + Shift + End: Selects all cells from the current position to the last cell in the worksheet.
- F5: Opens the Go To dialog box.
- Ctrl + G: Opens the Go To dialog box.
- Ctrl + F2: Displays the Print Preview window.
- Ctrl + Shift + F2: Prints the current worksheet.
- Ctrl + F6: Switches to the next workbook window.
- Ctrl + Shift + F6: Switches to the previous workbook window.
- Ctrl + Page Up: Moves to the previous worksheet.
- Ctrl + Page Down: Moves to the next worksheet.
- Ctrl + Shift + Page Up: Selects the current and previous worksheets.
- Ctrl + Shift + Page Down: Selects the current and next worksheets.
- Ctrl + Tab: Switches to the next worksheet.
- Ctrl + Shift + Tab: Switches to the previous worksheet.
- F2: Edits the current cell.
- Shift + F2: Adds a comment to the current cell.
- Ctrl + D: Copies the value from the cell above to the current cell.
- Ctrl + R: Copies the value from the cell to the left to the current cell.
- Ctrl + Shift + &: Applies an outline border to the selected cells.
- Ctrl + Shift + _: Removes a border from the selected cells.
- Ctrl + Shift + +: Inserts cells, rows, or columns.
- Ctrl + -: Deletes cells, rows, or columns.
- Ctrl + Spacebar: Selects the current column.
- Shift + Spacebar: Selects the current row.
- Ctrl + Shift + Spacebar: Selects the entire worksheet.
- F4: Repeats the last action.
- F6: Switches between the worksheet, ribbon, task pane, and zoom controls.
- F7: Opens the Spelling dialog box.
- Shift + F10: Displays the right-click menu.
Editing Shortcuts
- Ctrl + X: Cuts the selected cells
- Ctrl + C: Copies the selected cells.
- Ctrl + V: Pastes the copied cells.
- Ctrl + Alt + V: Displays the Paste Special dialog box.
- Ctrl + D: Fills the selected cells with the value from the cell above.
- Ctrl + R: Fills the selected cells with the value from the cell to the left.
- Ctrl + ;: Enters the current date in the selected cell.
- Ctrl + Shift + ;: Enters the current time in the selected cell.
- Ctrl + “: Copies the value from the cell above to the current cell.
- Ctrl + “: Copies the formula from the cell above to the current cell.
- Ctrl + Shift + “: Inserts the value from the cell above into the current cell.
- Ctrl + Shift + ” +”: Inserts the formula from the cell above into the current cell.
- Ctrl + Enter: Fills the selected cells with the value from the active cell.
- Alt + Enter: Adds a line break to the current cell.
- Ctrl + Shift + ~: Applies the General number format.
- Ctrl + Shift + $: Applies the Currency number format.
- Ctrl + Shift + %: Applies the Percentage number format.
- Ctrl + Shift + #: Applies the Date number format.
- Ctrl + Shift + ^: Applies the Scientific number format.
- Ctrl + Shift + @: Applies the Time number format.
- Ctrl + Shift + F: Opens the Format Cells dialog box.
- Ctrl + 1: Opens the Format Cells dialog box.
- Ctrl + E: Flash fills the selected cells.
- Ctrl + Alt + F9: Calculates all worksheets in all open workbooks.
- Ctrl + Alt + Shift + F9: Rebuilds the calculation chain in all open workbooks.
- F9: Recalculates the active worksheet.
- Shift + F9: Recalculates all worksheets in all open workbooks.
- Ctrl + Shift + U: Toggles the formula bar on or off.
- Ctrl + Shift + O: Displays the Outlining toolbar.
- Ctrl + Shift + F10: Displays the shortcut menu for a selected item.
- Ctrl + J: Opens the Fill dialog box.
- Alt + =: Inserts a sum formula.
- Ctrl + Shift + &: Applies a border to the selected cells.
- Ctrl + Shift + _: Removes a border from the selected cells.
- Ctrl + Shift + +: Inserts cells, rows, or columns.
- Ctrl + -: Deletes cells, rows, or columns.
- Ctrl + F3: Opens the Name Manager dialog box.
- Ctrl + Shift + F3: Creates a name for the selected cells.
- F3: Displays the Paste Name dialog box.
- Ctrl + Shift + F3: Displays the Create Names dialog box.
- Ctrl + Shift + F6: Hides the selected workbook window.
- Ctrl + F7: Moves the current workbook window.
- Ctrl + F8: Resizes the current workbook window.
- Ctrl + F10: Maximizes or restores the current workbook window.
- Alt + F4: Closes Excel.
- Formula Shortcuts 81. F4: Repeats the last action or function.
- Ctrl + A: Selects all cells in the formula.
- Ctrl + C: Copies the formula.
- Ctrl + V: Pastes the formula.
- Ctrl + X: Cuts the formula.
- Ctrl + Z: Undoes the last action.
- Ctrl + Y: Redoes the last action.
- Ctrl + Shift + Enter: Enters an array formula.
- F2: Edits the formula.
- F9: Calculates the formula.
- Ctrl + Shift + A: Inserts the argument names in a function.
- Ctrl + Shift + L: Displays the function arguments dialog box.
- Shift + F3: Opens the Insert Function dialog box.
- Ctrl + Shift + U: Toggles the formula bar on or off.
- Ctrl + `: Toggles between displaying formulas and displaying values.
- F7: Opens the Spelling dialog box.
- Worksheet Shortcuts 97. Ctrl + Page Up: Moves to the previous worksheet.
- Ctrl + Page Down: Moves to the next worksheet.
- Ctrl + Shift + Page Up: Selects the current and previous worksheets.
- Ctrl + Shift + Page Down: Selects the current and next worksheets.
- Ctrl + Home: Moves to the beginning of the worksheet.
- Ctrl + End: Moves to the last cell in the worksheet.
- Ctrl + Shift + Home: Selects all cells from the current position to the beginning of the worksheet.
- Ctrl + Shift + End: Selects all cells from the current position to the last cell in the worksheet.
- Ctrl + Shift + F6: Switches to the previous workbook window.
- Ctrl + Shift + F12: Opens the Save As dialog box.
- F4: Repeats the last action.
- F6: Switches between the worksheet, ribbon, task pane, and zoom controls.
- F9: Calculates the active worksheet.
- Shift + F9: Calculates all worksheets in all open workbooks.
- Ctrl + Shift + U: Toggles the formula bar on or off.
- Ctrl + Shift + O: Displays the Outlining toolbar.
- Ctrl + Shift + F10: Displays the shortcut menu for a selected item.
- Ctrl + J: Opens the Fill dialog box.
- Alt + =: Inserts a sum formula.
- Ctrl + Shift + &: Applies a border to the selected cells.
- Ctrl + Shift + _: Removes a border from the selected cells.
- Ctrl + Shift + +: Inserts cells, rows, or columns.
- Ctrl + -: Deletes cells, rows, or columns.
- Ctrl + F3: Opens the Name Manager dialog box.
- Ctrl + Shift + F3: Creates a name for the selected cells.
- F3: Displays the Paste Name dialog box.
- Ctrl + Shift + F3: Displays the Create Names dialog box.
- Ctrl + Shift + F6: Hides the selected workbook window.
- Ctrl + F7: Moves the current workbook window.
- Ctrl + F8: Resizes the current workbook window.
- Ctrl + F10: Maximizes or restores the current workbook window.
- Alt + F4: Closes Excel.
Miscellaneous Shortcuts
- Alt + F: Displays the File tab.
- Alt + H: Displays the Home tab.
- Alt + N: Displays the Insert tab.
- Alt + P: Displays the Page Layout tab.
- Alt + M: Displays the Formulas tab.
- Alt + A: Displays the Data tab.
- Alt + R: Displays the Review tab.
- Alt + W: Displays the View tab.
- Alt + Q: Opens the Tell me box.
- Ctrl + Tab: Switches to the next workbook.
- Ctrl + Shift + Tab: Switches to the previous workbook.
- Shift + F11: Inserts a new worksheet.
- Alt + Shift + F1: Opens the Insert Function dialog box.
- Alt + Shift + F2: Opens the Save As dialog box.
- Ctrl + Shift + C: Copies the format of the selected cells.
- Ctrl + Shift + V: Pastes the format of the copied cells.
- Ctrl + Shift + W: Toggles between displaying multiple workbook windows and a single workbook window.
- Ctrl + Shift + T: Inserts a new table.
- Ctrl + Shift + F5: Opens the Go To dialog box.
- Ctrl + Shift + F12: Prints the current worksheet.
- Ctrl + Shift + F11: Creates a new chart sheet.
Any that are missing? Let us know!