Shortcuts save hours over a year, and they are noticed in timed Excel tests. These Windows shortcuts are the ones data analysts use daily.
Navigation and selection
- Ctrl + Arrow: jump to the edge of your data.
- Ctrl + Shift + Arrow: select to the edge of the data.
- Ctrl + A: select the whole data region (press twice for the sheet).
- Ctrl + Home: go to cell A1.
- Ctrl + Space and Shift + Space: select a column or a row.
Editing
- F2: edit the active cell.
- Ctrl + Z and Ctrl + Y: undo and redo.
- Ctrl + D and Ctrl + R: fill down and fill right.
- Ctrl + Enter: fill the same entry in all selected cells.
- Ctrl + Alt + V: Paste Special.
Data tools
- Ctrl + Shift + L: turn filters on or off.
- Alt + =: AutoSum.
- Ctrl + T: convert data to a table.
- Alt + N + V: insert a PivotTable.
- Alt + H + O + I: auto-fit column width.
Formulas
- F4: cycle through absolute and relative references.
- Ctrl + `: show all formulas on the sheet.
- Ctrl + Shift + Enter: enter an array formula in older Excel versions.
- Ctrl + [: jump to the cells a formula refers to.
- F9: evaluate the selected part of a formula.