|
Description |
PC |
MAC |
|
|
| Workbook |
| Insert new worksheet | Shift + F11 | Shift + F11 | | |
| Go to next worksheet | Ctrl + PgDn | Fn + ⌃ + ↓ | | |
| Go to previous worksheet | Ctrl + PgUp | Fn + ⌃ + ↑ | | |
| Move to next pane | F6 | F6 | | |
| Move to previous pane | Shift + F6 | Shift + F6 | | |
| Go to next workbook | Ctrl + Tab | ⌃ + Tab | | |
| Go to previous workbook | Ctrl + Shift + Tab | ⌃ + Shift + Tab | | |
| Minimize current workbook window | Ctrl + F9 | ⌘ + M | | |
| Maximize current workbook window | Ctrl + F10 | | | |
| File |
| Create new workbook | Ctrl + N | ⌘ + N | | |
| Open workbook | Ctrl + O | ⌘ + o | | |
| Save workbook | Ctrl + S | ⌘ + s | | |
| Save as | F12 | ⌘ + Shift + S | | |
| Print file | Ctrl + P | ⌘ + P | | |
| Open print preview window | Ctrl + F2 | | | |
| Close current workbook | Ctrl + F4 | ⌘ + W | | |
| Close Excel | Ctrl + F4 | ⌘ + Q | | |
| Ribbon |
| Expand or collapse ribbon | Ctrl + F1 | ⌘ + ⌥ + 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 selected control | F1 | | | |
| General |
| Open help | F1 | ⌘ + / | | |
| Undo last action | Ctrl + Z | ⌘ + Z | | |
| Redo last action | Ctrl + Y | ⌘ + Y | | |
| Copy selected cells | Ctrl + C | ⌘ + C | | |
| Cut selected cells | Ctrl + X | ⌘ + X | | |
| Paste content from clipboard | Ctrl + V | ⌘ + V | | |
| Display the Paste Special dialog box | Ctrl + Alt + V | ⌃ + ⌘ + V | | |
| Display find and replace | Ctrl + F | ⌘ + F | | |
| Display find and replace, replace selected | Ctrl + H | ⌃ + H | | |
| Find next match | Shift + F4 | ⌘ + G | | |
| Find previous match | Ctrl + Shift + F4 | ⌘ + Shift + G | | |
| Create embedded chart | Alt + F1 | Fn + ⌥ + F1 | | |
| Create chart in new worksheet | F11 | Fn + F11 | | |
| Toggle Autofilter | Ctrl + Shift + L | ⌘ + Shift + F | | |
| Activate filter | Alt + ↓ | ⌥ + ↓ | | |
| Insert table | Ctrl + T | ⌃ + T | | |
| Select table | Ctrl + A | ⌘ + A | | |
| Drag and Drop |
| Drag and cut | drag | drag | | |
| Drag and copy | Ctrl + drag | ⌥ + drag | | |
| Drag and insert | Shift + drag | Shift + drag | | |
| Drag and insert copy | Ctrl + Shift + drag | ⌥ + Shift + drag | | |
| Drag to worksheet | Alt + drag | ⌘ + drag | | |
| Drag to duplicate worksheet | Ctrl + drag | ⌥ + drag | | |
| Navigation |
| Move one screen right | Alt + PgDn | Fn + ⌥ + ↑ | | |
| Move one screen left | Alt + PgUp | 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 + → | | |
| Selection |
| Select entire row | Shift + Space | Shift + Space | | |
| Select entire column | Ctrl + Space | ⌃ + Space | | |
| Select entire worksheet | Ctrl + A | ⌘ + A | | |
| Add adjacent cells to selection | Shift + Click | Shift + Click | | |
| Add non-adjacent cells to selection | Ctrl + Click | ⌘ + Click | | |
| Move right between non-adjacent selections | Ctrl + Alt + → | ⌃ + ⌥ + → | | |
| Move left between non-adjacent selections | Ctrl + Alt + ← | ⌃ + ⌥ + ← | | |
| Toggle add to selection mode | Shift + F8 | Fn + Shift + F8 | | |
| Cancel selection | Esc | Esc | | |
| Active Cell |
| Select active cell only | Shift + Backspace | Shift + 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 | Shift + Return | | |
| Move active cell right in a selection | Tab | Tab | | |
| Move active cell left in a selection | Shift + Tab | Shift + Tab | | |
| Extend Selection |
| Extend selection by one cell right | Shift + → | Shift + → | | |
| Extend selection by one cell left | Shift + ← | Shift + ← | | |
| Extend selection by one cell up | Shift + ↑ | Shift + ↑ | | |
| Extend selection by one cell down | Shift + ↓ | Shift + ↓ | | |
| Extend the selection to the last cell right | Ctrl + Shift + → | ⌃ + Shift + → | | |
| Extend the selection to the last cell left | Ctrl + Shift + ← | ⌃ + Shift + ← | | |
| Extend the selection to the last cell up | Ctrl + Shift + ↑ | ⌃ + Shift + ↑ | | |
| Extend the selection to the last cell down | Ctrl + Shift + ↓ | ⌃ + Shift + ↓ | | |
| Extend selection up one screen | Shift + PgUp | Fn + Shift + ↑ | | |
| Extend selection down one screen | Shift + PgDn | Fn + Shift + ↓ | | |
| Extend selection to start of row | Shift + Home | Fn + Shift + ← | | |
| Extend selection to first cell in worksheet | Ctrl + Shift + Home | Fn + ⌃ + Shift + ← | | |
| Extend selection to last cell in worksheet | Ctrl + Shift + End | Fn + ⌃ + Shift + → | | |
| Toggle extend selection mode | F8 | Fn + F8 | | |
| Select Special |
| Display 'Go To' dialog box | Ctrl + G | ⌃ + G | | |
| Select cells with comments | Ctrl + Shift + O | Fn + ⌃ + Shift + O | | |
| Select current region around active cell | Ctrl + Shift + * | Shift + ⌃ + Space | | |
| Select current region | Ctrl + A | ⌘ + A | | |
| Select current array | Ctrl + / | ⌃ + / | | |
| Select row differences | Ctrl + \ | ⌃ + \ | | |
| Select column differences | Ctrl + Shift + | | ⌃ + Shift + | | | |
| Select direct precedents | Ctrl + [ | ⌃ + [ | | |
| Select all precedents | Ctrl + Shift + { | ⌃ + Shift + { | | |
| Select direct dependents | Ctrl + ] | ⌃ + ] | | |
| Select all dependents | Ctrl + Shift + } | ⌃ + Shift + } | | |
| Select visible cells only | Alt + ; | ⌘ + Shift + Z | | |
| Cell Edit Mode |
| Edit the active cell | F2 | ⌃ + U | | |
| Insert or edit comment | Shift + F2 | Fn + Shift + F2 | | |
| Cancel entry | Esc | Esc | | |
| Select one character right | Shift + → | Shift + → | | |
| Select one character left | Shift + ← | Shift + ← | | |
| Move one word right | Ctrl + → | ⌃ + → | | |
| Move one word left | Ctrl + ← | ⌃ + ← | | |
| Select one word right | Ctrl + Shift + → | ⌃ + Shift + → | | |
| Select one word left | Ctrl + Shift + ← | ⌃ + Shift + ← | | |
| Select to beginning of cell | Shift + Home | Fn + Shift + ← | | |
| Select to end of cell | Shift + End | Fn + Shift + → | | |
| Delete to end of line | Ctrl + Delete | ⌃ + Delete | | |
| Delete character to the left of cursor | Backspace | Delete | | |
| Delete character to the right of cursor | Delete | Fn + Delete | | |
| Start a new line in the same cell | Alt + Enter | ⌃ + ⌥ + Return | | |
| Entering Data |
| Enter and move down | Enter | Return | | |
| Enter and move up | Shift + Enter | Shift + Return | | |
| Enter and move right | Tab | Tab | | |
| Enter and move left | Shift + Tab | Shift + Tab | | |
| Complete entry and stay in same cell | Ctrl + Enter | ⌃ + Return | | |
| Enter same data in multiple cells | Ctrl + Enter | ⌃ + Return | | |
| Insert current date | Ctrl + ; | ⌃ + ; | | |
| Insert current time | Ctrl + Shift + : | ⌃ + Shift + : | | |
| Fill down from cell above | Ctrl + D | ⌃ + D | | |
| Fill right from cell left | Ctrl + R | ⌃ + R | | |
| Copy formula from cell above | Ctrl + ' | ⌃ + ' | | |
| Copy value from cell above | Ctrl + Shift + " | ⌃ + Shift + " | | |
| Add hyperlink | Ctrl + K | ⌘ + K | | |
| Display AutoComplete list | Alt + ↓ | ⌥ + ↓ | | |
| Formatting |
| Format (almost) anything | Ctrl + 1 | ⌘ + 1 | | |
| Display Format Cells with Font tab selected | Ctrl + Shift + F | | | |
| Apply format again | F4 | ⌃ + Y | | |
| Apply or remove bold formatting | Ctrl + B | ⌘ + B | | |
| Apply or remove italic formatting | Ctrl + I | ⌘ + I | | |
| Apply or remove underscoring | Ctrl + U | ⌘ + U | | |
| Apply or remove strikethrough formatting | Ctrl + 5 | ⌘ + Shift + X | | |
| Align center | Alt + HAC | ⌘ + E | | |
| Align left | Alt + HAL | ⌘ + L | | |
| Align right | Alt + HAR | ⌘ + R | | |
| Number Formatting |
| Apply general format | Ctrl + Shift + ~ | ⌃ + Shift + ~ | | |
| Apply currency format | Ctrl + Shift + $ | ⌃ + Shift + $ | | |
| Apply percentage format | Ctrl + Shift + % | ⌃ + Shift + % | | |
| Apply scientific format | Ctrl + Shift + ^ | ⌃ + Shift + ^ | | |
| Apply date format | Ctrl + Shift + # | ⌃ + Shift + # | | |
| Apply time format | Ctrl + Shift + @ | ⌃ + Shift + @ | | |
| Apply number format | Ctrl + Shift + ! | ⌃ + Shift + ! | | |
| Borders |
| Add border outline | Ctrl + Shift + & | ⌘ + ⌥ + 0 | | |
| Add or remove border right | Alt + R | ⌘ + ⌥ + → | | |
| Add or remove border left | Alt + L | ⌘ + ⌥ + ← | | |
| Add or remove border top | Alt + T | ⌘ + ⌥ + ↑ | | |
| Add or remove border bottom | Alt + B | ⌘ + ⌥ + ↓ | | |
| Add or remove border upward diagonal | Alt + D | | | |
| Add or remove border horizontal interior | Alt + H | | | |
| Add or remove border vertical interior | Alt + V | | | |
| Remove borders | Ctrl + Shift + _ | ⌘ + ⌥ + _ | | |
| Formulas |
| Toggle absolute and relative references | F4 | ⌘ + T | | |
| Open the Insert Function Dialog Box | Shift + F3 | Fn + Shift + F3 | | |
| Autosum selected cells | Alt + = | ⌘ + Shift + T | | |
| Toggle formulas on and off | Ctrl + ` | ⌃ + ` | | |
| Insert function arguments | Ctrl + Shift + A | ⌃ + Shift + A | | |
| Enter array formula | Ctrl + Shift + Enter | ⌃ + Shift + Return | | |
| Calculate worksheets | F9 | Fn + F9 | | |
| Calculate active worksheet | Shift + F9 | Fn + Shift + F9 | | |
| Force calculate all worksheets | Ctrl + Alt + F9 | | | |
| Evaluate part of a formula | F9 | Fn + F9 | | |
| Expand or collapse the formula bar | Ctrl + Shift + U | ⌃ + Shift + U | | |
| Display function arguments dialog box | Ctrl + A | ⌃ + A | | |
| Define name | Ctrl + F3 | ⌃ + L | | |
| Define name using row and column labels | Ctrl + Shift + F3 | ⌃ + Shift + F3 | | |
| Paste name into formula | F3 | | | |
| Accept function with auto complete | Tab | ↓ + Tab | | |
| Grid Operations |
| Insert row / column / cell | Ctrl + Shift + | ⌃ + I | | |
| Delete row / column / cell | Ctrl + - | ⌃ + - | | |
| Hide columns | Ctrl + 0 | ⌃ + 0 | | |
| Hide rows | Ctrl + 9 | ⌃ + 9 | | |
| Unhide rows | Ctrl + Shift + 9 | ⌃ + Shift + 9 | | |
| Open Group Dialog Box | Alt + Shift + → | ⌘ + Shift + K | | |
| Open Ungroup Dialog Box | Alt + Shift + ← | ⌘ + Shift + J | | |
| Hide or show outline symbols | Ctrl + 8 | ⌃ + 8 | | |
| Pivot Tables |
| Select entire pivot table | Ctrl + A | ⌘ + A | | |
| Toggle pivot table field checkbox | Space | Space | | |
| Group pivot table items | Alt + Shift + → | ⌘ + Shift + K | | |
| Ungroup pivot table items | Alt + Shift + ← | ⌘ + Shift + J | | |
| Hide pivot table item | Ctrl + - | Ctrl + - | | |
| Create pivot chart on same worksheet | Alt + F1 | | | |
| Create pivot chart on new worksheet | F11 | Fn + F11 | | |
| Open pivot table wizard | Alt + DP | ⌘ + ⌥ + P | | |
| Dialog boxes |
| Move to next control | Tab | Tab | | |
| Move to previous control | Shift + Tab | Shift + Tab | | |
| Move to next tab | Ctrl + Tab | ⌃ + Tab | | |
| Move to previous tab | Ctrl + Shift + Tab | ⌃ + Shift + Tab | | |
| Check and uncheck box | Space | Space | | |
| Cancel and close the dialog box | Esc | Esc | | |
| Other |
| Open Spelling dialog box | F7 | F7 | | |
| Open Thesaurus dialog box | Shift + F7 | Shift + F7 | | |
| Open Macro dialog box | Alt + F8 | Fn + ⌥ + F9 | | |
| Open VBA Editor | Alt + F11 | Fn + ⌥ + F11 | | |
| Duplicate object | Ctrl + D | ⌘ | | |
| Snap to grid | Alt | ⌘ | | |
| Hide or show objects | Ctrl + 6 | ⌃ + 6 | | |
| Display Modify Cell Style dialog box | Alt + ' | ⌘ + Shift + L | | |
| Display shortcut menu | Shift + F10 | Fn + Shift + F10 | | |