Excel Keyboard Shortcuts 43 shortcuts · Windows & macOS · Last updated Nov 2026
Mouse-free Excel is 10x faster. This cheat sheet collects the shortcuts spreadsheet pros rely on daily — jumping across data, selecting ranges, formatting numbers and editing formulas — with Windows and macOS keys side by side.
Navigation7
| Action | Windows | macOS |
|---|---|---|
| Jump to edge of data region | CtrlArrow | CmdArrow |
| Go to cell A1 | CtrlHome | CmdHome |
| Go to last used cell | CtrlEnd | CmdEnd |
| Go To dialog | CtrlG | CtrlG |
| Find | CtrlF | CmdF |
| Next / previous worksheet | CtrlPagethenDownorCtrlPagethenUp | CmdPagethenDownorCmdPagethenUp |
| Go to start of row | Home | FnLeft |
Selection5
| Action | Windows | macOS |
|---|---|---|
| Select to edge of data region | CtrlShiftArrow | CmdShiftArrow |
| Select all cells | CtrlA | CmdA |
| Extend selection by one cell | ShiftArrow | ShiftArrow |
| Select entire column | CtrlSpace | CtrlSpace |
| Select entire row | ShiftSpace | ShiftSpace |
Editing9
| Action | Windows | macOS |
|---|---|---|
| Edit active cell | F2 | CtrlU |
| New line inside a cell | AltEnter | OptionReturn |
| Fill selected cells with entry | CtrlEnter | CmdReturn |
| Fill down from cell above | CtrlD | CmdD |
| Fill right from cell left | CtrlR | CmdR |
| Paste Special dialog | CtrlAltV | CmdCtrlV |
| Undo / redo | CtrlZorCtrlY | CmdZorCmdY |
| Cancel entry / exit edit mode | Esc | Esc |
| Insert current date / time | Ctrl;orCtrlShift; | Ctrl;orCtrlShift; |
Formatting8
| Action | Windows | macOS |
|---|---|---|
| Bold / italic / underline | CtrlBorCtrlIorCtrlU | CmdBorCmdIorCmdU |
| Open Format Cells dialog | Ctrl1 | Cmd1 |
| Apply number format (two decimals) | CtrlShift1 | CtrlShift1 |
| Apply time format | CtrlShift2 | CtrlShift2 |
| Apply date format | CtrlShift3 | CtrlShift3 |
| Apply currency format | CtrlShift4 | CtrlShift4 |
| Apply percentage format | CtrlShift5 | CtrlShift5 |
| Apply outline border | CtrlShift7 | CmdOption0 |
Formulas & Functions5
| Action | Windows | macOS |
|---|---|---|
| Toggle absolute / relative references | F4 | CmdT |
| Recalculate all worksheets | F9 | FnF9 |
| Recalculate active worksheet | ShiftF9 | ShiftFnF9 |
| Show / hide formulas | Ctrl` | Cmd` |
| AutoSum | Alt= | CmdShiftT |
Rows & Columns4
| Action | Windows | macOS |
|---|---|---|
| Hide selected rows | Ctrl9 | Cmd9 |
| Unhide selected rows | CtrlShift9 | CmdShift9 |
| Delete selected cells / rows | Ctrl- | Ctrl- |
| Group selected rows / columns | ShiftAltRight | CmdShiftK |
Workbook5
| Action | Windows | macOS |
|---|---|---|
| New / open workbook | CtrlNorCtrlO | CmdNorCmdO |
| Save / Save As | CtrlSorF12 | CmdSorCmdShiftS |
| CtrlP | CmdP | |
| Close workbook | CtrlW | CmdW |
| Insert new worksheet | ShiftF11 | ShiftF11 |