Microsoft Excel Keyboard Shortcuts
Below is a list of Microsoft Excel keyboard shortcuts. With KillerKeys, you can always have the shortcuts you want for practically any application right in front of you. Learn more
| Modifier Key | Key | Description of shortcut |
| Ctrl | 0 | Hides the selected columns. |
| Ctrl Shift | 0 | Unhides any hidden columns within the selection. |
| Ctrl Shift | 1 | Apply the number format with two decimal places, thousands separator, and minus sign (–) for negative values. |
| Ctrl | 1 | Displays the format cells dialog box. |
| Ctrl Shift | 2 | Applies the time format with the hour and minute, and am or pm. |
| Ctrl Shift | 3 | Applies the date format with the day, month, and year. |
| Ctrl Shift | 4 | Applies the currency format with two decimal places (negative numbers in parentheses). |
| Ctrl | 5 | Applies or removes strikethrough. |
| Ctrl Shift | 5 | Applies the percentage format with no decimal places. |
| Ctrl Shift | 6 | Applies the scientific number format with two decimal places. |
| Ctrl | 6 | Alternates between hiding and displaying objects. |
| Ctrl Shift | 7 | Applies the outline border to the selected cells. |
| Ctrl | 8 | Displays or hides the outline symbols. |
| Ctrl Shift | 8 | Selects an entire sheet or report. |
| Ctrl Shift | 8 | Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a pivottable, it selects the entire pivottable report. |
| Ctrl | 9 | Hides the selected rows. |
| Ctrl Shift | 9 | Unhide any hidden rows within the selection. |
| Ctrl Shift | * | Select the current region around the active cell (the data area enclosed by blank rows and blank columns). In a pivottable report, select the entire pivottable report. |
| Ctrl | / | Select the array containing the active cell. |
| Ctrl | [ | Select all cells directly referenced by formulas in the selection. |
| Ctrl | \ | In a selected row, select the cells that don't match the formula or static value in the active cell. |
| Ctrl Shift | \ | In a selected column, select the cells that don't match the formula or static value in the active cell. |
| Ctrl | ] | Select cells that contain formulas that directly reference the active cell. |
| Ctrl Shift | ] | Select cells that contain formulas that directly or indirectly reference the active cell. |
| = | Start a formula. | |
| Alt | = | Insert an autosum formula with the sum function. |
| Ctrl Shift | = | Displays the insert dialog box to insert blank cells. |
| Ctrl | A | Select the entire worksheet. If the worksheet contains data, ctrl+a selects the current region. Pressing ctrl+a a second time selects the entire worksheet. |
| Ctrl | Apostrophe | Copies a formula from the cell above the active cell into the cell or the formula bar. |
| Ctrl Shift | Apostrophe | Copies the value from the cell above the active cell into the cell or the formula bar. |
| Alt | B | Apply or remove the bottom border. |
| Ctrl | B | Applies or removes bold formatting. |
| BACKSPACE | Deletes one character to the left in the formula bar. Also clears the content of the active cell. | |
| Ctrl | C | Copies the selected cells. |
| Ctrl | D | Fill down |
| Ctrl | Delete | Delete text to the end of the line. |
| Delete | In cell editing mode, it deletes the character to the right of the insertion point or clears cell contents. | |
| Ctrl | Down Arrow | Move to the edge of the current data region down. |
| Down Arrow | Move one cell/character/menu item down | |
| Ctrl Shift | Down Arrow | Extend the selection to the last nonblank cell down in the same column or row as the active cell. |
| Shift | Down Arrow | Extends the selection of cells by one cell down. |
| END | End turns end mode on. In end mode, you can then press an arrow key to move to the next nonblank cell in the same column or row as the active cell. If the cells are blank, pressing end followed by an arrow key moves to the last cell in the row or column. End also selects the last command on the menu when a menu or submenu is visible and moved to the end of a field. | |
| Ctrl | END | Moves to the last cell on a worksheet, to the lowest used row of the rightmost used column. If the cursor is in the formula bar, ctrl+end moves the cursor to the end of the text. |
| Shift | End | Select from the insertion point to the end of the entry. |
| Ctrl Shift | END | Extends the selection of cells to the last used cell on the worksheet (lower-right corner). |
| Ctrl | ENTER | Fills the selected cell range with the current entry. |
| Alt | ENTER | Starts a new line in the same cell. |
| ENTER | In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the ok button). | |
| Shift | ENTER | Completes a cell entry and selects the cell above. |
| Escape | Cancel the current action |
These shortcuts are just a sample of the shortcuts available for this application. KillerKeys includes the complete list of shortcuts and is updated automatically with each new release of software.
