File Operations
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Create new workbook | CtrlN | ⌘N | CtrlN |
| Open workbook | CtrlO | ⌘O | CtrlO |
| Save workbook | CtrlS | ⌘S | CtrlS |
| Save as | F12 | ⌘ShiftS | F12 |
| Print file | CtrlP | ⌘P | CtrlP |
| Print preview | CtrlF2 | ⌘P | |
| Close current workbook | CtrlW | ⌘W | CtrlW |
| Close Excel | AltF4 | ⌘Q |
Basic Editing
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Undo last action | CtrlZ | ⌘Z | CtrlZ |
| Redo last action | CtrlY | ⌘Y | CtrlY |
| Copy selected cells | CtrlC | ⌘C | CtrlC |
| Cut selected cells | CtrlX | ⌘X | CtrlX |
| Paste content | CtrlV | ⌘V | CtrlV |
| Paste special dialog box | CtrlAltV | ⌘CtrlV | |
| Find | CtrlF | ⌘F | CtrlF |
| Find and replace | CtrlH | ⌘H | CtrlH |
| Find next match | ShiftF4 | ||
| Find previous match | CtrlShiftF4 | ||
| Repeat last action | F4 | ⌘Y |
Navigation
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Move to next cell | Tab | Tab | Tab |
| Move to previous cell | ShiftTab | ShiftTab | ShiftTab |
| Move to edge of data upward | Ctrl↑ | ⌘↑ | Ctrl↑ |
| Move to edge of data downward | Ctrl↓ | ⌘↓ | Ctrl↓ |
| Move to edge of data left | Ctrl← | ⌘← | Ctrl← |
| Move to edge of data right | Ctrl→ | ⌘→ | Ctrl→ |
| Go to cell A1 | CtrlHome | ⌘Home | CtrlHome |
| Go to last cell | CtrlEnd | ⌘End | CtrlEnd |
| Move one screen up | PgUp | PgUp | PgUp |
| Move one screen down | PgDn | PgDn | PgDn |
| Move one screen right | AltPgDn | OptionPgDn | |
| Move one screen left | AltPgUp | OptionPgUp | |
| Go back to hyperlink | CtrlGEnter | ⌘GEnter |
Selection
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Select entire column | CtrlSpace | ⌘Space | CtrlSpace |
| Select entire row | ShiftSpace | ShiftSpace | ShiftSpace |
| Select all cells | CtrlA | ⌘A | CtrlA |
| Extend selection up one cell | Shift↑ | Shift↑ | Shift↑ |
| Extend selection down one cell | Shift↓ | Shift↓ | Shift↓ |
| Extend selection left one cell | Shift← | Shift← | Shift← |
| Extend selection right one cell | Shift→ | Shift→ | Shift→ |
| Add adjacent cells to selection | ShiftClick | ShiftClick | ShiftClick |
| Add non-adjacent cells to selection | CtrlClick | ⌘Click | CtrlClick |
| Cancel selection | Esc | Esc | Esc |
| Select array | F5AltSA | ||
| Select dependents | F5AltSDL | ||
| Select blank cells | F5AltSK | ||
| Select column differences | F5AltSM | ||
| Select precedents | F5AltSPL | ||
| Select similar formatting | F5AltSTE | ||
| Select similar validation | F5AltSVE | ||
| Select row differences | F5AltSW |
Formatting
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Format cells dialog | Ctrl1 | ⌘1 | |
| Toggle bold | CtrlB | ⌘B | CtrlB |
| Toggle italic | CtrlI | ⌘I | CtrlI |
| Toggle underline | CtrlU | ⌘U | CtrlU |
| Toggle strikethrough | Ctrl5 | ⌘5 | |
| Align center | AltHAC | ||
| Align left | AltHAL | ||
| Align right | AltHAR | ||
| Increase font size | AltHFG | ||
| Decrease font size | AltHFK | ||
| Add border outline | CtrlShift7 | ⌘Option0 | |
| Remove borders | CtrlShift_ |
Number Formatting
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Apply general format | CtrlShift~ | ⌘Shift~ | |
| Apply number format | CtrlShift1 | ⌘Shift1 | |
| Apply currency format | CtrlShift4 | ⌘Shift$ | |
| Apply percentage format | CtrlShift5 | ⌘Shift5 | |
| Apply date format | CtrlShift# | ⌘Shift# | |
| Apply time format | CtrlShift@ | ⌘Shift@ | |
| Apply scientific format | CtrlShift^ | ⌘Shift^ |
Data Entry
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Edit active cell | F2 | F2 | F2 |
| Insert current date | Ctrl; | ⌘; | |
| Insert current time | CtrlShift; | ⌘Shift; | |
| Fill down from cell above | CtrlD | ⌘D | |
| Fill right from cell left | CtrlR | ⌘R | |
| Copy formula from cell above | Ctrl' | ⌘' | |
| Copy value from cell above | CtrlShift" | ⌘Shift" | |
| Add hyperlink | CtrlK | ⌘K | |
| Flash fill | CtrlE | ⌘E | |
| Complete entry in cell | CtrlEnter | ⌘Enter | CtrlEnter |
| Insert line break in cell | AltEnter | OptionEnter |
Grid Operations
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Insert rows/columns | CtrlShift+ | ⌘Shift+ | |
| Delete rows/columns | Ctrl- | ⌘- | |
| Hide columns | Ctrl0 | ⌘0 | |
| Hide rows | Ctrl9 | ⌘9 | |
| Unhide columns | CtrlShift0 | ⌘Shift0 | |
| Unhide rows | CtrlShift9 | ⌘Shift9 | |
| Group rows or columns | AltShift→ | OptionShift→ | |
| Ungroup rows or columns | AltShift← | OptionShift← | |
| Zoom in | CtrlAlt+ | ⌘Option+ | |
| Zoom out | CtrlAlt- | ⌘Option- |
Workbook Management
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Insert new worksheet | ShiftF11 | ShiftF11 | |
| Go to next worksheet | CtrlPgDn | Fn⌘PgDn | |
| Go to previous worksheet | CtrlPgUp | Fn⌘PgUp | |
| Move to next workbook | CtrlTab | ⌘` | |
| Move to previous workbook | CtrlShiftTab | ⌘Shift` | |
| Toggle full screen | CtrlShiftF1 | ⌘ShiftF1 | |
| Toggle scroll lock | ScrLk |
Advanced Features
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Insert pivot table | AltNV | ||
| Create embedded chart | AltF1 | ||
| Create chart in sheet | F11 | F11 | |
| Text to columns | AltAE | ||
| Insert table | CtrlT | ⌘T | |
| Toggle filter | CtrlShiftL | ⌘ShiftF | |
| Insert or edit comment | ShiftF2 | ShiftF2 | |
| Open Visual Basic Editor | AltF11 | OptionF11 | |
| Show formulas | Ctrl` | ⌘` | |
| Calculate all worksheets | F9 | F9 | |
| Calculate active worksheet | ShiftF9 | ShiftF9 |
Ribbon Navigation
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Expand or collapse ribbon | CtrlF1 | ⌘F1 | |
| Access Home tab | AltH | ||
| Access Insert tab | AltN | ||
| Access Page Layout tab | AltP | ||
| Access Formulas tab | AltM | ||
| Access Data tab | AltA | ||
| Access Review tab | AltR | ||
| Access View tab | AltW |
Charts and Graphs
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Insert bar chart | AltNB | ||
| Insert column chart | AltNC | ||
| Insert line chart | AltNN | ||
| Insert pie/doughnut chart | AltNQ | ||
| Open recommended charts | AltNR | ||
| Insert combo chart | AltNSD | ||
| Insert text box | AltNX |
Conditional Formatting
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Clear worksheet rules | AltHLCE | ||
| Clear PivotTable rules | AltHLCP | ||
| Clear selected cell rules | AltHLCS | ||
| Clear table rules | AltHLCT | ||
| Set data bar formatting | AltHLD | ||
| Format date occurring cells | AltHLHA | ||
| Format cells between values | AltHLHB | ||
| Format duplicate values | AltHLHD | ||
| Format equal to value | AltHLHE | ||
| Format greater than value | AltHLHG | ||
| Format less than value | AltHLHL | ||
| Open rules manager | AltHLR | ||
| Set color scale rule | AltHLS |
Paste Special
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Skip blanks | CtrlAltVB | ||
| Paste comments | CtrlAltVC | ||
| Paste with addition | CtrlAltVD | ||
| Paste with division | CtrlAltVI | ||
| Paste with multiplication | CtrlAltVM | ||
| Paste data validation | CtrlAltVN | ||
| Paste with subtraction | CtrlAltVS |
Data Analysis
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Remove duplicates | AltAM | ||
| Open goal seek | AltAWG | ||
| Open scenario manager | AltAWS | ||
| Create data table | AltAWT | ||
| Clear hyperlinks | AltHEL | ||
| Fill across worksheets | AltHFIA | ||
| Fill justify | AltHFIJ | ||
| Copy right cell to left | AltHFIL | ||
| Open series dialog | AltHFIS | ||
| Copy bottom cell up | AltHFIU |
Formula Functions
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Calculate average | AltHUA | ||
| Count numbers | AltHUC | ||
| Find minimum value | AltHUI | ||
| Find maximum value | AltHUM | ||
| Remove formula arrows | AltMAA | ||
| Trace dependents | AltMD | ||
| Trace precedents | AltMP | ||
| Calculate all workbooks | CtrlAltF9 | ⌘OptionF9 |
Display Options
| Shortcut | Windows | Mac | Web |
|---|---|---|---|
| Freeze panes | AltWFF | ||
| Page break preview | AltWI | ||
| Normal view | AltWL | ||
| Open zoom dialog | AltWQ | ||
| Toggle gridlines | AltWVG | ||
| Show/hide formulas | Ctrl` | ⌘` | |
| Show/hide objects | Ctrl6 | ⌘6 | |
| Expand/collapse ribbon | CtrlF1 | ⌘F1 |