Excel Keyboard Shortcuts Cheat Sheet

Complete guide to Excel keyboard shortcuts.

Worksheet

Shortcut	Description
Insert a new worksheet	`Shift` + `F11` or `Alt` + `Shift` + `F1`
Move to the next sheet in the workbook	`Ctrl` + `PageDown`
Move to the previous sheet in the workbook	`Ctrl` + `PageUp`
Select the current and next sheet	`Shift` + `Ctrl` + `PageDown`
Cancel selection of multiple sheets	`Ctrl` + `PageDown`
Select other sheets	`Ctrl` + `PageUp`
Select the current and previous sheet	`Shift` + `Ctrl` + `PageUp`
Rename the current sheet	`Alt` + `O` `H` `R`
Move or copy the current sheet	`Alt` + `E` `M`
Delete the current sheet	`Alt` + `E` `L`

Moving and Scrolling in a Worksheet

Shortcut	Description
Move one cell up, down, left, or right	`Arrow keys`
Move to the edge of the current data region	`Ctrl` + `Arrow keys`
Move to the beginning of a row	`Home`
Move to the beginning of a worksheet	`Ctrl` + `Home`
Move to the last cell on a worksheet (bottom-right used cell)	`Ctrl` + `End`
Move down one screen	`PageDown`
Move up one screen	`PageUp`
Move one screen to the right	`Alt` + `PageDown`
Move one screen to the left	`Alt` + `PageUp`
Move to the next pane in a split worksheet	`Ctrl` + `F6`
Move to the previous pane in a split worksheet	`Shift` + `F6`
Scroll to display the active cell	`Ctrl` + `Backspace`
Display the “Go To” dialog box	`F5`
Display the “Find” dialog box	`Shift` + `F5`
Find next	`Shift` + `F4`
Move between unlocked cells on a protected worksheet	`Tab`

Moving within a Selection

Shortcut	Description
Move from top to bottom within the selection	`Enter`
Move from bottom to top within the selection	`Shift` + `Enter`
Move from left to right within the selection (or down in a single column)	`Tab`
Move from right to left within the selection (or up in a single column)	`Shift` + `Tab`
Move clockwise to the next corner of the selection	`Ctrl` + `.` (period)
Move to the next non-adjacent selection to the right	`Ctrl` + `Alt` + `Right Arrow`
Move to the next non-adjacent selection to the left	`Ctrl` + `Alt` + `Left Arrow`

Moving or Scrolling in “End” Mode

Shortcut	Description
Turn “End” mode on or off	`End`
Move by block of data within a row or column	`End` + `Arrow keys`
Move to the last cell on the worksheet (bottom-right used cell)	`End` + `Home`
Move to the last non-empty cell in the current row	`End` + `Enter`

Scroll Lock

Shortcut	Description
Turn Scroll Lock on or off	`ScrollLock`
Move to the cell in the upper-left corner of the window	`Home`
Move to the cell in the lower-right corner of the window	`End`
Scroll one row up or down	`Up Arrow` or `Down Arrow`
Scroll one column left or right	`Left Arrow` or `Right Arrow`

Selecting Cells, Rows, and Columns

Shortcut	Description
Select an entire column	`Ctrl` + `Spacebar`
Select an entire row	`Shift` + `Spacebar`
Select the entire worksheet	`Ctrl` + `A`
Select only the active cell when multiple cells are selected	`Shift` + `Backspace`
Select all objects on a worksheet when an object is selected	`Ctrl` + `Shift` + `Spacebar`
Toggle between hiding objects, displaying objects, and placeholders	`Ctrl` + `6`

Selecting Specific Cells

Shortcut	Description
Select the current region around the active cell	`Ctrl` + `Shift` + `*` (asterisk)
Select the array containing the active cell	`Ctrl` + `/`
Select all cells with comments	`Ctrl` + `Shift` + `O`
Select cells in a row that don’t match the active cell	`Ctrl` + `\`
Select cells in a column that don’t match the active cell	`Ctrl` + `Shift` + `
Select all cells directly referenced by formulas in the selection	`Ctrl` + `[`
Select all cells directly or indirectly referenced by formulas	`Ctrl` + `Shift` + `{`
Select cells with formulas that directly reference the active cell	`Ctrl` + `]`
Select cells with formulas that directly or indirectly reference the active cell	`Ctrl` + `Shift` + `}`
Select visible cells in the current selection	`Alt` + `;` (semicolon)

Extending a Selection

Shortcut	Description
Turn “Extend Selection” mode on or off	`F8`
Add another range of cells to the selection	`Shift` + `F8`
Extend the selection by one cell	`Shift` + `Arrow keys`
Extend to the last non-empty cell in the same column/row	`Ctrl` + `Shift` + `Arrow keys`
Extend the selection to the beginning of the row	`Shift` + `Home`
Extend the selection to the beginning of the worksheet	`Ctrl` + `Shift` + `Home`
Extend the selection to the last used cell on the worksheet	`Ctrl` + `Shift` + `End`
Extend the selection down one screen	`Shift` + `PageDown`
Extend the selection up one screen	`Shift` + `PageUp`
Extend to the last non-empty cell in the same column/row (End mode)	`End` + `Shift` + `Arrow keys`
Extend the selection to the last used cell (End mode)	`End` + `Shift` + `Home`
Extend the selection to the last cell in the current row (End mode)	`End` + `Shift` + `Enter`
Extend the selection to the upper-left cell of the window (Scroll Lock)	`ScrollLock` + `Shift` + `Home`
Extend the selection to the lower-right cell of the window (Scroll Lock)	`ScrollLock` + `Shift` + `End`

Data Entry and Calculation

Shortcut	Description
Complete cell entry and move down	`Enter`
Start a new line in the same cell	`Alt` + `Enter`
Fill the selected cell range with the current entry	`Ctrl` + `Enter`
Complete cell entry and move up	`Shift` + `Enter`
Complete cell entry and move right	`Tab`
Complete cell entry and move left	`Shift` + `Tab`
Cancel cell entry	`Esc`
Move one character up, down, left, or right	`Arrow keys`
Move to the beginning of the line	`Home`
Repeat the last action	`F4` or `Ctrl` + `Y`
Create names from row and column labels	`Ctrl` + `Shift` + `F3`
Fill down	`Ctrl` + `D`
Fill right	`Ctrl` + `R`
Define a name	`Ctrl` + `F3`
Insert a hyperlink	`Ctrl` + `K`
Activate a hyperlink	`Enter` (in a cell with a hyperlink)
Enter the date	`Ctrl` + `;` (semicolon)
Enter the time	`Ctrl` + `Shift` + `:` (colon)
Display the drop-down list for the current column	`Alt` + `Down Arrow`
Undo the last action	`Ctrl` + `Z`

Entering Special Characters

Shortcut	Description
Enter cent symbol ￠	`Alt` + `0162`
Enter pound symbol ￡	`Alt` + `0163`
Enter yen symbol ￥	`Alt` + `0165`
Enter euro symbol €	`Alt` + `0128`

Entering and Calculating Formulas

Shortcut	Description
Start a formula	`=` (equal sign)
Move the insertion point to the formula bar after editing	`F2`
Delete one character to the left in the formula bar	`Backspace`
Complete cell entry in the cell or formula bar	`Enter`
Enter a formula as an array formula	`Ctrl` + `Shift` + `Enter`
Cancel entry in the cell or formula bar	`Esc`
Display the “Insert Function” dialog box	`Shift` + `F3`
Display “Function Arguments” (when cursor is right of function name)	`Ctrl` + `A`
Insert parameter names and parentheses	`Ctrl` + `Shift` + `A`
Paste a defined name into a formula	`F3`
Insert an “AutoSum” formula	`Alt` + `=` (equal sign)
Copy value from above cell to current cell/formula bar	`Ctrl` + `Shift` + `"` (double quote)
Copy formula from above cell to current cell/formula bar	`Ctrl` + `'` (apostrophe)
Toggle between showing cell values and formulas	`Ctrl` + ` (backtick)
Calculate all sheets in all open workbooks	`F9`
Calculate the active worksheet	`Shift` + `F9`
Calculate all sheets in all open workbooks (regardless of changes)	`Ctrl` + `Alt` + `F9`
Recheck formulas and calculate all cells (including un-marked)	`Ctrl` + `Alt` + `Shift` + `F9`

Editing Data

Shortcut	Description
Edit the active cell and put cursor at the end	`F2`
New line in cell	`Alt` + `Enter`
Clear the cell or delete previous character while editing	`Backspace`
Delete character to the right or delete selection	`Del`
Delete text from cursor to end of line	`Ctrl` + `Del`
Display the “Spelling” dialog box	`F7`
Edit cell comment	`Shift` + `F2`
Complete entry and move down	`Enter`
Undo last action	`Ctrl` + `Z`
Cancel cell entry	`Esc`
Undo/Redo “AutoCorrect” when smart tag appears	`Ctrl` + `Shift` + `Z`

Cells

Shortcut	Description
Copy selected cells	`Ctrl` + `C`
Show Microsoft Office Clipboard (multiple copy/paste)	`Ctrl` + `C`, then `Ctrl` + `C` again
Cut selected cells	`Ctrl` + `X`
Paste copied cells	`Ctrl` + `V`
Clear content of selected cells	`Del`
Delete selected cells	`Ctrl` + `-` (hyphen)
Insert blank cells	`Ctrl` + `Shift` + `+` (plus sign)

Formatting Data

Shortcut	Description
Display the “Style” dialog box	`Alt` + `'` (apostrophe)
Display the “Format Cells” dialog box	`Ctrl` + `1`
Apply “General” number format	`Ctrl` + `Shift` + `~`
Apply “Currency” format with two decimal places	`Ctrl` + `Shift` + `$`
Apply “Percentage” format with no decimal places	`Ctrl` + `Shift` + `%`
Apply “Scientific” format with two decimal places	`Ctrl` + `Shift` + `^`
Apply “Date” format with day, month, and year	`Ctrl` + `Shift` + `#`
Apply “Time” format with hour, minute, and AM/PM	`Ctrl` + `Shift` + `@`
Apply “Number” format with two decimals and separator	`Ctrl` + `Shift` + `!`
Apply or remove bold formatting	`Ctrl` + `B`
Apply or remove italic formatting	`Ctrl` + `I`
Apply or remove underline	`Ctrl` + `U`
Apply or remove strikethrough	`Ctrl` + `5`
Hide selected rows	`Ctrl` + `9`
Unhide rows within the selection	`Ctrl` + `Shift` + `(`
Hide selected columns	`Ctrl` + `0` (zero)
Unhide columns within the selection	`Ctrl` + `Shift` + `)`
Apply an outline border to selected cells	`Ctrl` + `Shift` + `&`
Remove outline border	`Ctrl` + `Shift` + `_`

“Border” Tab

Shortcut	Description
Apply or remove top border	`Alt` + `T`
Apply or remove bottom border	`Alt` + `B`
Apply or remove left border	`Alt` + `L`
Apply or remove right border	`Alt` + `R`
Apply or remove horizontal divider (multiple rows)	`Alt` + `H`
Apply or remove vertical divider (multiple columns)	`Alt` + `V`
Apply or remove downward diagonal border	`Alt` + `D`
Apply or remove upward diagonal border	`Alt` + `U`

Creating Charts and Selecting Chart Elements

Shortcut	Description
Create a chart of data in the current region	`F11` or `Alt` + `F1`
Select chart sheet	Select next/previous sheet until chart is found
Move to next/previous sheet for chart	`Ctrl` + `PageDown` / `Ctrl` + `PageUp`
Select the previous group of elements in a chart	`Down Arrow`
Select the next group of elements in a chart	`Up Arrow`
Select the next element in a group	`Right Arrow`
Select the previous element in a group	`Left Arrow`

Using Data Forms

Shortcut	Description
Move to the same field in the next record	`Down Arrow`
Move to the same field in the previous record	`Up Arrow`
Move to each field, then to each command button	`Tab` and `Shift` + `Tab`
Move to the first field of the next record	`Enter`
Move to the first field of the previous record	`Shift` + `Enter`
Move to the same field 10 records ahead	`PageDown`
Start a new blank record	`Ctrl` + `PageDown`
Move to the same field 10 records back	`PageUp`
Move to the first record	`Ctrl` + `PageUp`
Move to the start or end of a field	`Home` or `End`
Extend selection to the end of a field	`Shift` + `End`
Extend selection to the start of a field	`Shift` + `Home`
Move left or right one character within a field	`Left Arrow` or `Right Arrow`
Select character to the left within a field	`Shift` + `Left Arrow`
Select character to the right within a field	`Shift` + `Right Arrow`

Filter Area

Shortcut	Description
Display “AutoFilter” list for the current column	`Alt` + `Down Arrow`
Select the next item in the “AutoFilter” list	`Down Arrow`
Select the previous item in the “AutoFilter” list	`Up Arrow`
Close the “AutoFilter” list	`Alt` + `Up Arrow`
Select the first item (“All”) in the “AutoFilter” list	`Home`
Select the last item in the “AutoFilter” list	`End`
Filter the region based on the “AutoFilter” list selection	`Enter`

Outlining Data

Shortcut	Description
Group rows or columns	`Alt` + `Shift` + `Right Arrow`
Ungroup rows or columns	`Alt` + `Shift` + `Left Arrow`
Show or hide outline symbols	`Ctrl` + `8`
Hide selected rows	`Ctrl` + `9`
Unhide rows within selection	`Ctrl` + `Shift` + `(`
Hide selected columns	`Ctrl` + `0` (zero)
Unhide columns within selection	`Ctrl` + `Shift` + `)`