Excel Keyboard Shortcuts Cheat Sheet
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 |
| Deselect 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 |
Move and Scroll in 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 the row | Home |
| Move to the beginning of the worksheet | Ctrl+Home |
| Move to the last cell on the worksheet | Ctrl+End |
| Move down one screen | PageDown |
| Move up one screen | PageUp |
| Move right one screen | Alt+PageDown |
| Move left one screen | 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 |
Move in a Selection
| Shortcut | Description |
|---|---|
| Move from top to bottom in the selection | Enter |
| Move from bottom to top in the selection | Shift+Enter |
| Move from left to right in the selection | Tab |
| Move from right to left in the selection | Shift+Tab |
| Move clockwise to the next corner of the selection | Ctrl+Period |
| Move to the right to the next non-adjacent selection | Ctrl+Alt+Right Arrow |
| Move to the left to the next non-adjacent selection | Ctrl+Alt+Left Arrow |
Move or Scroll 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) | 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 | Scroll Lock |
| 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 |
Select Cells, Rows, and Columns
| Shortcut | Description |
|---|---|
| Select the entire column | Ctrl+Spacebar |
| Select the 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 the worksheet | Ctrl+Shift+Spacebar |
| Toggle between hiding, showing, and showing placeholders for objects | Ctrl+6 |
Select 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 value in the active cell | Ctrl+ \ |
| Select cells in a column that don’t match the value in 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 in the selection | 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) |
Extend a Selection
| Shortcut | Description |
|---|---|
| Turn extend 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 the selection to the last non-empty cell in the row/column | 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 (bottom-right) | Ctrl+Shift+End |
| Extend the selection down one screen | Shift+PageDown |
| Extend the selection up one screen | Shift+PageUp |
| Extend the selection to the last used cell (bottom-right) | End+Shift+Home |
| Extend the selection to the last cell in the current row | End+Shift+Enter |
Data Formatting and Calculation
| Shortcut | Description |
|---|---|
| Complete cell entry and select the next cell below | 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 select the previous cell above | Shift+Enter |
| Complete cell entry and select the next cell to the right | Tab |
| Complete cell entry and select the previous cell to the 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 values in the current column | Alt+Down Arrow |
| Undo the last action | Ctrl+Z |
Enter Special Characters
| Shortcut | Description |
|---|---|
| Enter cent character ￠ | Alt+0162 |
| Enter pound character ￡ | Alt+0163 |
| Enter yen symbol ￥ | Alt+0165 |
| Enter euro symbol € | Alt+0128 |
Enter and Calculate Formulas
| Shortcut | Description |
|---|---|
| Start a formula | = (Equal sign) |
| Move the insertion point to the formula bar | 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” dialog box | Ctrl+A |
| Insert argument names and parentheses | Ctrl+Shift+A |
| Paste a defined name into a formula | F3 |
| Insert an “AutoSum” formula with the SUM function | Alt+= (Equal sign) |
| Copy the value from the cell above into the active cell | Ctrl+Shift+" (Double quote) |
| Copy the formula from the cell above into the active cell | Ctrl+’ (Apostrophe) |
| Toggle between showing cell values and showing formulas | Ctrl+` (Grave accent) |
| Calculate all worksheets in all open workbooks | F9 |
| Calculate the active worksheet | Shift+F9 |
| Calculate all worksheets in open workbooks (full) | Ctrl+Alt+F9 |
| Recheck formulas and calculate all cells | Ctrl+Alt+Shift+F9 |
Edit Data
| Shortcut | Description |
|---|---|
| Edit the active cell and put insertion point at the end | F2 |
| Start a new line in the same cell | Alt+Enter |
| Delete characters or clear cell | Backspace |
| Delete character to the right or delete selection | Del |
| Delete text to the end of the line | Ctrl+Del |
| Display the “Spelling” dialog box | F7 |
| Edit a cell comment | Shift+F2 |
| Complete cell entry and select next cell below | Enter |
| Undo last action | Ctrl+Z |
| Cancel cell entry | Esc |
| Undo/Redo last auto-correct | Ctrl+Shift+Z |
Cells
| Shortcut | Description |
|---|---|
| Copy selected cells | Ctrl+C |
| Show Office Clipboard | Ctrl+C twice |
| Cut selected cells | Ctrl+X |
| Paste copied/cut cells | Ctrl+V |
| Clear content of selected cells | Del |
| Delete selected cells | Ctrl+Hyphen |
| Insert blank cells | Ctrl+Shift+Plus |
Format 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 (two decimal places) | Ctrl+Shift+$ |
| Apply “Percentage” format (no decimal places) | Ctrl+Shift+% |
| Apply “Scientific” number format | Ctrl+Shift+^ |
| Apply “Date” format (day, month, year) | Ctrl+Shift+# |
| Apply “Time” format (hour and minute, AM/PM) | Ctrl+Shift+@ |
| Apply “Number” format (two decimal places, thousand 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 hidden rows in the selection | Ctrl+Shift+( |
| Hide selected columns | Ctrl+0 (Zero) |
| Unhide hidden columns in the selection | Ctrl+Shift+) |
| Apply outline border | 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 | Alt+H |
| Apply or remove vertical divider | Alt+V |
| Apply or remove down-diagonal border | Alt+D |
| Apply or remove up-diagonal border | Alt+U |
Charts and Chart Elements
| Shortcut | Description |
|---|---|
| Create a chart of data in the current region | F11 or Alt+F1 |
| Select next sheet in workbook | Ctrl+Page Down |
| Select previous sheet in workbook | Ctrl+Page Up |
| 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 the group | Right Arrow |
| Select the previous element in the group | Left Arrow |
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 between fields and command buttons | Tab and Shift+Tab |
| Move to the first field in the next record | Enter |
| Move to the first field in the previous record | Shift+Enter |
| Move to the same field 10 records ahead | Page Down |
| Start a new blank record | Ctrl+Page Down |
| Move to the same field 10 records back | Page Up |
| Move to the first record | Ctrl+Page Up |
| Move to the beginning or end of a field | Home or End |
| Extend selection to end of field | Shift+End |
| Extend selection to beginning of field | Shift+Home |
| Move one character left or right in field | Left Arrow or Right Arrow |
| Select character to the left | Shift+Left Arrow |
| Select character to the right | Shift+Right Arrow |
Filtering Regions
| Shortcut | Description |
|---|---|
| Display “AutoFilter” list for current column | Alt+Down Arrow |
| Select next item in AutoFilter list | Down Arrow |
| Select previous item in AutoFilter list | Up Arrow |
| Close AutoFilter list | Alt+Up Arrow |
| Select the first item (“All”) in list | Home |
| Select the last item in list | End |
| Filter region based on selection | Enter |
Outline 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 hidden rows in selection | Ctrl+Shift+( |
| Hide selected columns | Ctrl+0 (Zero) |
| Unhide hidden columns in selection | Ctrl+Shift+) |