All shortcuts
Browse every published shortcut. Start here if you want the full catalog instead of the interactive tools.
Select current and next sheet
Selects the current sheet and the next sheet in the workbook, creating a group selection.
Select current and previous sheet
Selects the current sheet and the previous sheet in a workbook, creating a group of two sheets.
Extend Selection by One Cell
Extends the current cell selection by one cell in the direction of the arrow key.
Extend Selection to Last Nonblank Cell
Extends the selection from the active cell to the last nonblank cell in the same column or row. If the next cell is blank, extends to the next nonblank cell.
Toggle Extend Mode
Press F8 to turn extend mode on, then use arrow keys to extend the selection. Press F8 again to turn off.
Add non-adjacent cell or range to selection
Press Shift+F8 to add a non-adjacent cell or range to an existing selection using arrow keys.
Start a new line in the same cell
Insert a line break within a cell to create multi-line text.
Fill selected cell range with current entry
Enter the same data into multiple selected cells at once. After typing the value, press Ctrl+Enter to fill all selected cells with that entry.
Complete cell entry and select cell above
Completes the current cell entry and moves the selection to the cell directly above.
Select an entire column in a worksheet
Selects the entire column of the active cell in an Excel worksheet.
Select an entire row in a worksheet
Selects the entire row of the active cell in an Excel worksheet.
Extend selection to worksheet start
Extends the current cell selection from the active cell to the first cell (A1) of the worksheet.
Select current region around active cell
Selects the entire contiguous data region (range of cells surrounded by empty rows and columns) around the active cell.
Select First Command on Menu
When a menu or submenu is open, press Home to select the first command.
Repeat Last Command or Action
Repeats the last command or action performed in Excel, if possible.
Toggle formula check tooltips
Turn on or off tooltips that appear when checking formulas directly in cells.
Expand or collapse the formula bar
Toggle the formula bar between expanded and collapsed states to view or edit long formulas.
Calculate all worksheets in all open workbooks
Press F9 to recalculate all worksheets in all open workbooks.
Calculate Active Worksheet
Recalculates all formulas in the active worksheet.
Force Recalculate All Worksheets
Forces a full recalculation of all worksheets in every open workbook, ignoring the 'changed since last calculation' flag.
Check dependent formulas and calculate all cells in all open workbooks
Forces a complete recalculation of all formulas in all open workbooks, including those that depend on other cells.
Display Error Checking Menu
Opens the menu or message for the Error Checking button on a cell with a potential error.
Insert Function Arguments
After typing a function name in a formula, press Ctrl+Shift+A to automatically insert the argument names and parentheses.
Insert the Sum formula
Quickly insert the SUM formula to add up a range of cells.