| 1. Navigate Worksheets | |
|---|---|
| Arrow Keys | Navigate by one cell at a time in any direction |
| Page Down/Page Up | Move one screen down/ up |
| Alt+Page Down/Page Up | Move one screen right/ left |
| Tab/Shift+Tab | Move one cell to the right/ to the left in a worksheet |
| Ctrl+Arrow Keys | Move to the edge of next data region (cells that contains data) |
| Home | Move to the beginning of row |
| Ctrl+Home | Move to the beginning of worksheet |
| Ctrl+End | Move to the last cell with content of worksheet |
| Ctrl+G | Display the GoTo dialog box |
| Ctrl+G then type e.g. A50 | Go to line 50, Column A |
| Ctrl+G then type e.g. G1 | Go to column G, Line 1 |
| 2. Select Cells |
|---|
 Shift+Arrow Keys | Extend selection by one cell | |
|---|---|---|
| Shift+Page Down/Page Up | Extend selection one screen down/ up | |
| Ctrl+Shift+Arrow Keys | Extend selection to next non-blank cell | |
| Shift+Home | Extend selection to beginning of the row (unfortunately, there is no Shift+End equivalent) | |
| Ctrl+A with no data nearby current cell | Select all | |
| Ctrl+A with data nearby current cell | Select all cells in data-containing area. Press twice to select everything | |
| Ctrl+Shift+Home | Extend selection to first cell of the worksheet | |
| Ctrl+Shift+End | Extend selection to last used cell on the worksheet (lower-right corner) | |
| Shift+F8 | Lock Selection Extend Mode – Select Cell Range, press Shift+F8, move around, add to selection with Shift+Arrow Keys, etc | |
| Ctrl+G | Manual selection by row/ column via GoTo menu. A:B selects column A thru C, 1:3 selects row 1 thru 3 , A1:B3 select cells A1 thru B3, etc | |
| Shift+Space | Select current row | |
|---|---|---|
| Shift+Space, then Shift+Arrow Down/ Arrow Up | Select current row, then expand selection by one row down/ up | |
| Shift+Space, then Shift+Page Down/ Page Up | Select current row, then expand selection by one page down/ up | |
| Ctrl+Space | Select current column | |
| Shift+Space, then Shift+Arrow Right/ Arrow Left | Select current column, then expand selection by one column right/ left | |
| Shift+Space, then Shift+Alt+Page Down/ Page Up | Select current column, then expand selection by one screen right/ left | |
| 3. Juggle Rows, Columns, and Cells | |
|---|---|
| Shift+Space, then Ctrl+– | Select single row; then delete |
| Shift+Space, Shift+Arrow Up/Arrow Down, then Ctrl+– | Select multiple rows; then delete |
| Shift+Space, Ctrl+Shift++ | Select single row; then insert one row above |
| Shift+Space, Shift+Arrow Up/Arrow Down, then Ctrl+Shift++ | Select multiple rows; then insert the same number rows below |
| Ctrl+Space, then Ctrl+– | Select single (or multiple) columns, then delete |
| Ctrl+Space, then Ctrl+Shift++ | Select single row, then insert row below. Select multiple rows to insert multiple rows |
| Ctrl+Shift++ with row(s) in clipboard and a row selected | Paste Insert – paste row(s) from clipboard and shift existing content downward |
| Ctrl+Shift++ with column(s) in clipboard and column selected | Paste Insert – paste column(s) from clipboard and shift existing content to the right |
| Ctrl+Shift++ | With cells that are not complete rows/columns – Open insert cell/ row/ column menu |
| Ctrl+– | With cells that are not complete rows/columns – Open delete cell/ row/ column menu |
| Shift+Arrow Down, F2, then Ctrl+Enter | Fill single cell content down to all cells selected with Shift+Arrow Down |
| Shift+Arrow Up, F2, then Ctrl+Enter | Fill single cell content upto all cells selected with Shift+Arrow Down |
| These assume you are inside a cell. | |
|---|---|
| F2 | Edit cell. Press Escape to cancel |
| Home/End | Jump to beginning/ end of cell |
| Arrow Keys | Navigate by one character left/ right or one line up/ down |
| Ctrl+Arrow Left/ Arrow Right | Navigate by one word left/ right |
| Shift+Arrow Keys | Select one character to the left/ right (or one line up/down) |
| Shift+ Home/End | Select from the insertion point to beginning/ end of cell |
| Ctrl+Shift+Arrow Left/Arrow Right | Select or unselect one word to the left/ right |
| Delete/Backspace | Delete one character to the right/ left of cursor |
| Ctrl+Delete | Delete from cursor to end of cell |
| Alt+Enter | Start a new line inside cell |
| Enter/Shift+Enter | Complete cell entry and move one cell down/ up |
| Tab/Shift+Tab | Complete cell entry and move one cell right/ left |
| Ctrl+Enter | Complete cell entry and don’t move selection |
| Ctrl+‘ | Duplicate value from Cell above into current cell at cursor position |
| Ctrl+; | Insert current date at cursor position |
| Ctrl+Shift+; | Insert current time at cursor position |
| Ctrl+D | Fill Down from cell(s) above into current cell(s) | |
|---|---|---|
| Ctrl+D with a row selected | Duplicate row via fill down – Fill current row with content from row above. | |
| Ctrl+D with multiple empty cells selected | Duplicate content of first cell(s) in first row to all cells in selection downward. | |
| Ctrl+R | Fill Rright from cell(s) on the left into current cell(s) | |
| Ctrl+R with a column selected | Duplicate column via fill right – Fill current column with content from column on the left. | |
| Ctrl+D with multiple empty cells selected | Duplicate content first cell(s) in first column to all cells in selection to the right. | |
| Ctrl+‘ | Duplicate formula from cell above | |
▲ up
| With Excel 2016 ‘redo’ (undo an undo) and ‘repeat’ (repeat last action) became a bit confus. Ctrl+Y is a repeat if no undo is present. | |
|---|---|
| Ctrl+Z | Undo |
| Ctrl+Y | Redo (after undo) or Repeat (e.g. when applying formats) |
| Alt+2 | Undo list (via quick access). Use Arrow Down to extend undo range. |
| Alt+3 | Redo list (via quick access). Use Arrow Down to extend redo range. |
| Alt+Enter outside edit cell mode | Repeat last action. E.g. try to set a cell bold with Ctrl+B, then go to a different cell and press Alt+Enter; great to cascade formatting across multiple cells |
| Ctrl+X | Cut cell(s) to clipoard | |
|---|---|---|
| Ctrl+C | Copy cell(s) to clipboard | |
| Ctrl+V | Paste cell(s) from clipboard | |
| Ctrl++ | Insert Paste – Paste cell and push content downward or rightward. Works great for entire rows and columns. | |
| Ctrl+Alt+V | Open Paste Special Menu (requires a prior copy to Clipboard) | |
| Ctrl+Alt+V, then V, Enter | Paste Values | |
| Ctrl+Alt+V, then T, Enter | Paste Formats | |
| Ctrl+Alt+V, then E, Enter | Paste Transposed | |
| Ctrl+Alt+V, then W, Enter | Paste Column Width | |
| Ctrl+Alt+V, then U, Enter | Paste Values and Number Formats | |
| F3 | Paste a defined name into a formula
| |
