File
File |
Windows |
Mac |
|---|---|---|
| Create new workbook | Ctrl+N | Cmd+N |
| Open workbook | Ctrl+O | Cmd+O |
| Save workbook | Ctrl+S | Cmd+S |
| Save as | F12 | Cmd+Top Arrow+S |
| Print file | Ctrl+P | Cmd+P |
| An open print preview window | Ctrl+F2 | – |
| Close current workbook | Ctrl+F4 | Cmd+W |
| Close Excel | Alt+F4 | Cmd+Q |
Ribbon
File |
Windows |
Mac |
|---|---|---|
| Expand or collapse ribbon | Ctrl+F1 | Cmd+Alt+R |
| Activate access keys | Alt | – |
| Move to next ribbon control | Tab | Tab |
| Activate or open selected control | Space | Space |
| Confirm control change | Enter | Return |
| Get help on the selected control | F1 | – |
General
File |
Windows |
Mac |
|---|---|---|
| Open options | Alt+F+T | Cmd+, |
| Open help | F1 | Cmd+/ |
| Undo the last action | Ctrl+Z | Cmd+Z |
| Redo the last action | Ctrl+Y | Cmd+Y |
| Repeat the last action | F4 | Cmd+Y |
| Copy selected cells | Ctrl+C | Cmd+C |
| Cut selected cells | Ctrl+X | Cmd+X |
| Paste content from the clipboard | Ctrl+V | Cmd+V |
|
Display the Paste Special dialog box
|
Ctrl+Alt+V | ^+Cmd+V |
| Display find and replace | Ctrl+F | Cmd+F |
| Display find and replace, replace selected | Ctrl+H | Cmd+Q |
| Find next match | Shift+F4 | Cmd+G |
| Find the previous match | Cntrl+Shift+F4 | Cmd+UP Arrow+G |
| Create embedded chart | Alt+F1 | Fn+Alt+F1 |
| Create chart in new worksheet | F11 | Fn+F11 |
Tables and Filters
File |
Windows |
Mac |
|---|---|---|
| Insert table | Ctrl+T | ^+T |
| Toggle Autofilter | Ctrl+Shift+L | Cmd+Up Arrow+F |
| Activate filter | Alt+Down Arrow | Alt+Down Arrow |
| Select table row | Shift+Space | Up Arrow+Space |
| Select table column | Ctrl+Space | ^+Space |
| Select table | Ctrl+A | Cmd+A |
| Clear slicer filter | Alt+C | Alt+C |
| Toggle table total row | Ctrl+Shift+T | Cmd+Up Arrow + T |
Drag and Drop
File |
Windows |
Mac |
|---|---|---|
| Drag and cut | drag | drag |
| Drag and copy | Ctrl+drag | Cmd+drag |
| Drag and insert | Shift+drag | Up Arrow+ drag |
| Drag and insert copy | Ctrl+Shift+drag | Cmd+Top Arrow+drag |
| Drag to worksheet | Alt+drag | Cmd+drag |
| Drag to duplicate worksheet | Ctrl+drag | Alt+ drag |
Navigation
File |
Windows |
Mac |
|---|---|---|
| Move one cell right | → | → |
| Move one cell left | ← | ← |
| Move one cell up | ↑ | ↑ |
| Move one cell down | ↓ | ↓ |
| Move one screen right | Alt+PgDn | Fn+⌥+↓ |
| Move one screen left | Alt+PgUp | Fn+⌥+↑ |
| Move one screen up | PgUp | Fn+↑ |
| Move one screen down | PgDn | Fn+↓ |
| Move to right edge of data region | Ctrl +→ | ⌃+→ |
| Move to left edge of data region | Ctrl+← | ⌃+← |
| Move to top edge of data region | Ctrl+↑ | ⌃+↑ |
| Move to bottom edge of data region | Ctrl+↓ | ⌃+↓ |
| Move to beginning of row | Home | Fn+← |
| Move to last cell in worksheet | Ctrl+End | Fn+⌃+→ |
| Move to first cell in worksheet | Ctrl+Home | Fn+⌃+← |
| Turn End mode on | End | Fn+→ |
| Go back to hyperlink | Ctrl+G+Enter | ⌃+G+Return |
Selection
File |
Windows |
Mac |
|---|---|---|
| Select entire row | Shift+Space | ⇧+Space |
| Select entire column | Ctrl+Space | ⌃+Space |
| Select entire worksheet | Ctrl+A | ⌘+A |
| Add adjacent cells to selection | Shift+Click | ⇧+Click |
| Add non-adjacent cells to selection | Ctrl+Click | ⌘+Click |
| Same selection in next column | ⌥+Tab | – |
| Same selection in previous column | ⌥+⇧+Tab | – |
| Move right between non-adjacent selections | Ctrl+Alt+→ | ⌃+⌥+→ |
| Move left between non-adjacent selections | Ctrl+Alt+← | ⌃+⌥+← |
| Toggle add to selection mode | Shift+F8 | Fn+⇧+F8 |
| Cancel selection | Esc | Esc |
File
File |
Windows |
Mac |
|---|---|---|
| Create new workbook | Ctrl+N | Cmd+N |
| Open workbook | Ctrl+O | Cmd+O |
| Save workbook | Ctrl+S | Cmd+S |
| Save as | F12 | Cmd+Top Arrow+S |
| Print file | Ctrl+P | Cmd+P |
| An open print preview window | Ctrl+F2 | – |
| Close current workbook | Ctrl+F4 | Cmd+W |
| Close Excel | Alt+F4 | Cmd+Q |
Active Cell
File |
Windows |
Mac |
|---|---|---|
| Select active cell only | Shift+Backspace | ⇧+Delete |
| Show the active cell on worksheet | Ctrl+Backspace | ⌘+Delete |
| Move active cell clockwise in selection | Ctrl+. | ⌃+. |
| Move active cell down in selection | Enter | Return |
| Move active cell up in selection | Shift+Enter | ⇧+Return |
| Move active cell right in a selection | Tab | Tab |
| Move active cell left in a selection | Shift+Tab | ⇧+Tab |