| Workbook & Files |
|---|
| Create new workbook | ⌘N |
| Open workbook | ⌘O |
| Save workbook | ⌘S |
| Print workbook | ⌘P |
| Close workbook | ⌘W |
| Open the macro manager | ⌥F8 |
| Open the VBA editor | ⌥F11 |
| Create a workbook from a template | ⌘⇧P |
| Save the workbook under a new name | ⌘⇧S |
| Insert another worksheet | ⇧F11 |
| Toggle full-screen view | ⌘⌃F |
| Hide the Excel application | ⌘H |
| Navigation |
|---|
| Move one cell up | ↑ |
| Move one cell down | ↓ |
| Move to edge of data region | ⌘Arrow |
| Go to cell A1 | Fn+Ctrl+← |
| Go to last used cell | Fn+Ctrl+→ |
| Next worksheet | Fn+Ctrl+↓ |
| Previous worksheet | Fn+Ctrl+↑ |
| Move to the previous cell or control | ⇧Tab |
| Select through the last used cell | ⌃⇧End |
| Scroll down one screen | PageDown |
| Scroll right one screen | ⌥PageDown |
| Scroll up one screen | PageUp |
| Scroll left one screen | ⌥PageUp |
| Move to the next cell or control | Tab |
| Cycle object display modes | ⌃6 |
| Show or hide outline symbols | ⌃8 |
| Toggle extend-selection mode | F8 |
| Add a separate range to the selection | ⇧F8 |
| Select the entire column | ⌃Space |
| Select the entire row | ⇧Space |
| Select through the start of the worksheet | ⌃⇧Home |
| Move to the next corner of the selection | ⌃. |
| Editing |
|---|
| Edit active cell | Ctrl+U |
| Fill down | ⌘D |
| Fill right | ⌘R |
| Insert current date | Ctrl+; |
| Insert current time | ⌘; |
| Undo | ⌘Z |
| Redo | ⌘Y |
| Cut selected cells | ⌘X |
| Copy selected cells | ⌘C |
| Paste into selected cells | ⌘V |
| Add or edit a cell note | ⇧F2 |
| Add or reply to a threaded comment | ⌘⇧F2 |
| Insert blank cells | ⌃⇧= |
| Delete selected cells | ⌘- |
| Open Paste Special | ⌘⌃V |
| Insert a hyperlink | ⌘K |
| Check worksheet spelling | F7 |
| Create a table from cells | ⌘T |
| Insert a line break inside a cell | ⌘⌥Return |
| Fill the selection with the current entry | ⌘Return |
| Finish entry and move to the cell above | ⇧Return |
| Cancel the current cell entry | Esc |
| Finish entry and move to the cell below | Return |
| Copy the value from the cell above | ⌃⇧' |
| Create a separate chart sheet | F11 |
| Open the Power Query editor | ⌥F12 |
| Group selected cells | ⌘⇧K |
| Ungroup selected cells | ⌘⇧J |
| Open the Sort dialog | ⌘⇧R |
| Formulas |
|---|
| Start formula | = |
| AutoSum | ⌘⇧T |
| Show formulas | Ctrl+` |
| Calculate worksheets | F9 |
| Insert function | Shift+F3 |
| Copy the formula from the cell above | ⌃' |
| Toggle formula-checking tips | ⌃⌥P |
| Expand or collapse the formula bar | ⌃⇧U |
| Calculate only the active worksheet | ⇧F9 |
| Recheck dependencies and recalculate all cells | ⌃⌥⇧F9 |
| Cycle absolute and relative formula references | ⌘T |
| Open the Define Name dialog | ⌘F3 |
| Create names from the selection | ⌘⇧F3 |
| Formatting |
|---|
| Bold | ⌘B |
| Italic | ⌘I |
| Underline | ⌘U |
| Format cells dialog | ⌘1 |
| Apply percent format | ⌃⇧% |
| Toggle strikethrough in cells | ⇧⌘X |
| Add an outside cell border | ⌘⌥0 |
| Remove outside cell borders | ⌘⌥- |
| Apply General number formatting | ⌃⇧` |
| Apply currency formatting | ⌃⇧4 |
| Apply scientific number formatting | ⌃⇧6 |
| Apply date formatting | ⌃⇧3 |
| Apply time formatting | ⌃⇧2 |
| Apply a two-decimal number format | ⌃⇧1 |
| Center cell contents | ⌘E |
| Align cell contents to the left | ⌘L |
| Open the cell-style editor | ⇧⌘L |
