test
Microsoft Excel comes with varieties of keyboard shortcuts which are stated below with excel shortcut name and its keys for Windows and Mac.
Excel Formulas | Power Query | Macros | Excel Errors | Excel Videos
Before jumping onto each excel shortcuts, let us clarify what does keys for mac represent in case if you have moved to mac in recent times otherwise please ignore the following and go straight to the excel shortcuts mentioned below.
Mac Keys Used in Excel Shortcuts;
⌘ is the Command () key
⌃ is the Control key
⌥ is the Option (alt) key
⇧ is the Shift key
⇪ is the Caps Lock key
fn is the Function key
EXCEL SHORTCUTS LIST
| Shortcut | Windows | Mac |
|---|---|---|
| Repeat last action | Shift + F4 or Ctrl + Y | Looped square + Y |
| Define name using row and column labels | Ctrl + Shift + F3 | No alternative/ shortcut for mac. |
| Open Spelling dialog box | Shift + F7 | Fn (Function key) + F7 |
| Hide or show outline symbols | Ctrl + 8 | ˄ + 8 |
| Add or remove border left | Alt + L | Looped square + Option key + ← (left arrow) |
| Expand or collapse the formula bar | Ctrl + Shift + U | ˄ +⇧ + U |
| Add or remove border vertical interior | Alt + V | No alternative/ shortcut for mac. |
| Fill right from cell left | Ctrl + R | ˄ + R |
| Extend selection by one cell down | Shift + ↓ | ⇧+ ↓ |
| Display Format Cells with Font tab selected | Ctrl + Shift + F | ˄ + ⇧+ F |
| Extend selection right one screen | Alt + Shift + PgDn | Fn + ⇧+ Looped sqauare + ↓ |
| Add or remove border right | Alt + R | ⌘ Looped square + ⌥ (option key) + → |
| Extend selection to first cell in worksheet | Ctrl + Shift + Home | Fn + ˄ + ⇧+ ← |
| Move one word right | Ctrl + → | ⌃ + → |
| Apply or remove italic formatting | Ctrl + I | ⌘ + I |
| Toggle scroll lock | ScrLk | Fn +⇧ + F14 |
| Extend selection left one screen | Alt + Shift + PgUp | Fn +⇧ + ⌘ + |
| Hide columns | Ctrl + 0 | ⌃ + 0 |
| Add or remove border upward diagonal | Alt + D | No alternative/ shortcut for mac. |
| Extend the selection to the last cell up | Ctrl + Shift + ↑ | ⌃ +⇧ + ↑ |
| Add or remove border horizontal interior | Alt + H | No alternative/ shortcut for mac. |
| Remove borders | Ctrl + Shift + _ | ⌘ + ⌥ + _ |
| Maximize current workbook window | Ctrl + F10 | Fn + ⌃ + F10 |
| Select all precedents | Ctrl + Shift + | ⌃ +⇧ + { |
| Move to next pane | Shift + F6 | Fn + F6 |
| Select entire pivot table | Ctrl + A | ⌘ + A |
| Check and uncheck box | First select the checkbox, Tab or Shift + Space | First select the checkbox, Tab or Shift + Space |
| Accept function with autocomplete | Tab or shift + tab | ↓ + Tab |
| Extend the selection to the last cell right | Ctrl + Shift + → | ⌃ +⇧ + → |
| Unhide rows | Ctrl + Shift + 9 | ⌃ + ⇧+ 9 |
| Apply number format | Ctrl + Shift + ! | ⌃ +⇧ + ! |
| Move one cell down | ↓ | ↓ |
| Move one screen up | PgUp | Fn + ↑ |
| Move to previous tab | Ctrl + Shift + Tab | ⌃ +⇧ + Tab |
| Cut selected cells | Ctrl + X | ⌘ + X |
| Duplicate object | Ctrl + D | ⌘ + D |
| Open pivot table wizard | Alt + D + P | ⌘ + ⌥ + P |
| Toggle full screen | Ctrl + Shift + F1 | ⌃ + ⌘ + F |
| Extend the selection to the last cell left | Ctrl + Shift +← | ⌃ +⇧ + ← |
| Select column differences | Ctrl + Shift + | | ⌃ +⇧ +| |
| Move to bottom edge of data region | Ctrl + ↓ | ⌃ + ↓ |
| Insert current date | Ctrl + ; | ⌃ + ; |
| Move active cell up in selection | Shift + Enter | ⇧+ Return |
| Add border outline | Ctrl + Shift + & | ⌘ + ⌥ + 0 |
| Extend selection down one screen | Shift + PgDn | Fn + ⇧+ ↓ |
| Print file | Ctrl + P | ⌘ + P |
| Move to previous pane | Shift + F6 | Fn +⇧ + F6 |
| Save workbook | Ctrl + S | ⌘ + S |
| Open options | Alt + F + T | ⌘ + , |
| Move to next tab | Ctrl + Tab | ⌃ + Tab |
| Display the Paste Special dialog box | Ctrl + Alt + V | ⌃ +⌘ + V |
| Get help on selected control | Shift + F1 | No alternative/ shortcut for mac. |
| Copy selected cells | Ctrl + C | ⌘ + C |
| Evaluate part of a formula | Shift + F9 | Fn + F9 |
| Add adjacent cells to selection | Shift + Click | ⇧ + Click |
| Remove indent | Alt + H + 5 | ⌃ + ⌥ + ⇧ + Tab |
| Apply currency format | Ctrl + Shift + $ | ⌃ +⇧ + $ |
| Move one word left | Ctrl + ← | ⌃ + ← |
| Move one screen down | PgDn | Fn + ↓ |
| Add or remove the shadow font style | No alternative/ shortcut for windows. | ⌘ +⇧ + W |
| Extend the selection to the last cell down | Ctrl + Shift + ↓ | ⌃ +⇧ + ↓ |
| Force calculate all worksheets | Ctrl + Alt + F9 | N/A |
| Align left | Alt + H + A + L | ⌘ + L |
| Unhide columns | Ctrl + Shift + 0 | ⌃ + ⇧+ 0 |
| Create chart in new worksheet | Shift + F11 | Fn + F11 |
| Create new workbook | Ctrl + N | ⌘ + N |
| Create pivot chart on same worksheet | Alt + F1 | No alternative/ shortcut for mac. |
| Move one cell up | ↑ | ↑ |
| Extend selection to start of row | Shift + Home | Fn + ⇧ + ← |
| Go to next worksheet | Ctrl + PgDn | Fn + ⌃ + ↓ |
| Select all dependents | Ctrl + Shift + } | ⌃ +⇧ + } |
| Flash fill | Ctrl + E | N/A |
| Extend selection to last cell in worksheet | Ctrl + Shift + End | Fn + ⌃ + ⇧+ → |
| Display right-click menu | Shift + F10 | Fn +⇧ + F10 |
| Turn End mode on | End (or Shift + End) | Fn + → |
| Enter and move down | Enter | Return |
| Select direct dependents | Ctrl + ] | ⌃ + ] |
| Apply or remove underscoring | Ctrl + U | ⌘ + U |
| Increase font size one step | Alt + H + FG | ⌘ +⇧ + > |
| Select current region around active cell | Ctrl + Shift + * | ⇧ + ⌃ + Space |
| Display find and replace | Ctrl + F | ⌘ + F |
| Define name | Ctrl + F3 | Fn + ⌃ + F3 |
| Move left between non-adjacent selections | Ctrl + Alt + ← | ⌃ + ⌥ + ← |
| Show the active cell on worksheet | Ctrl + Backspace | ⌘ + Delete |
| Apply or remove strikethrough formatting | Ctrl + 5 | ⌘ + ⇧+ X |
| Toggle Autofilter | Ctrl + Shift + L | ⌘ + ⇧ + F |
| Activate access keys | Alt or Shift + F10 | No shortcut/ alternative for mac. |
| Toggle add to selection mode | Shift + F8 | Fn + ⇧ + F8 |
| Expand or collapse ribbon | Ctrl + F1 | ⌘ + ⌥ + R |
| Enter array formula | Ctrl + Shift + Enter | ⌃ + ⇧ + Return |
| Insert columns | Ctrl + Shift + + | ⌘ + ⇧ + + |
| Close Excel | Alt + F4 | ⌘ + Q |
| Clear slicer filter | Alt + C | ⌥ + C |
| Cancel entry | Esc | Esc |
| Find next match | Shift + F4 | ⌘ + G |
| Group rows or columns | Alt + Shift + → | ⌘ + ⇧ + K |
| Drag and insert | Shift + drag | ⇧ + drag |
| Extend selection up one screen | Shift + PgUp | Fn + ⇧ + ↑ |
| Insert rows | Ctrl + Shift + + | ⌘ + ⇧ + + |
| Delete comment | Shift + F10 + D | Fn + Shift + F10 |
| Select table column | Ctrl + Space | ⌃ + Space |
| Calculate worksheets | Shift + F9 | Fn + F9 |
| Go back to hyperlink | Ctrl + G Enter | ⌃ + G + Return |
| Copy formula from cell above | Ctrl + ‘ | ⌃ + ‘ |
| Move to previous control | Shift + Tab | ⇧+ Tab |
| Move to first cell in worksheet | Ctrl + Home | Fn + ⌃ + ← |
| Find previous match | Ctrl + Shift + F4 | ⌘ + ⇧ + G |
| Select visible cells only | Alt + ; | ⌘ + ⇧ + Z |
| Select table row | Shift + Space | ⇧+ Space |
| Move to top edge of data region | Ctrl + ↑ | ⌃ +↑ |
| Display Insert Dialog box | Ctrl + Shift + + | ⌘ + ⇧ + + |
| Activate or open selected control | Space | Space |
| Display Modify Cell Style dialog box | Alt + ‘ | ⌘ +⇧ + L |
| Add or remove border bottom | Alt + B | ⌘ + ⌥ + ↓ |
| Paste content from clipboard | Ctrl + V | ⌘ + V |
| Complete entry and stay in same cell | Ctrl + Enter | ⌃ + Return |
| Move to next control | Tab | Tab |
| Display function arguments dialog box | Ctrl + A | ⌃ + A |
| Drag to worksheet | Alt + drag | ⌘ + drag |
| Extend selection by one cell right | Shift + → | ⇧+ → |
| Select entire row | Shift + Space | ⇧+ Space |
| Insert table | Ctrl + T | ⌃ + T |
| Select one word left | Ctrl + Shift + ← | ⌃ + ⇧ + ← |
| Toggle formulas on and off | Ctrl + ` | ⌃ + ` |
| Open workbook | Ctrl + O | ⌘ + O |
| Display Delete dialog box | Ctrl + – | ⌘ + – |
| Ungroup pivot table items | Alt + Shift + ← | ⌘ +⇧ + J |
| Select one word left | Ctrl + Shift + ← | ⌃ + + ← |
| Edit the active cell | Shift + F2 | ⌃ + U |
| Delete contents of selected cells | Delete | Fn + Delete |
| Insert or edit comment | Shift +F2 | Fn +⇧ + F2 |
| Move one cell left | ← | ← |
| Enter and move up | Shift + Enter | ⇧+ Return |
| Select cells with comments | Ctrl + Shift + O | Fn + ^ +⇧ + O |
| Display ‘Go To’ dialog box | Ctrl + G | ^ + G |
| Apply or remove bold formatting | Ctrl + B | ⌘ + B |
| Move active cell down in selection | Enter | Return |
| Move active cell down in selection | Alt + Shift + → | ⌘ + ⇧ + K |
| Align right | Alt + H + A + R | ⌘ + R |
| Decrease font size one step | Alt + H + FK | ⌘ + ⇧ + < |
| Toggle extend selection mode | Shift + F8 | Fn + F8 |
| Move active cell left in a selection | Shift + Tab | ⇧+ Tab |
| Zoom in | Ctrl + Alt + + | ⌥ + ⌘ + + |
| Delete to end of line | Ctrl + Delete | ^ + Delete |
| Display AutoComplete list | Alt + ↓ | ⌥ + ↓ |
| Open Ungroup Dialog Box | Alt + Shift + ← | ⌘ + ⇧ + J |
| Select current array | Ctrl + / | ^ + / |
| Add or remove the outline font style | No shortcut/alternative for windows. | ⌘ +⇧ + D |
| Extend selection by one cell up | Shift + ↑ | ⇧ + ↑ |
| Open help | Shift + F1 | ⌘ + / |
| Select adjacent worksheets | Shift + Click | ⇧+ Click |
| Ungroup rows or columns | Alt + Shift + ← | ⌘ + ⇧ + J |
| Hide pivot table item | Ctrl + – | Ctrl + – |
| Drag and cut | drag | drag |
| Create embedded chart | Alt + F1 | Fn + ⌥ + F1 |
| Select one word right | Ctrl + Shift + → | ⌃ + ⇧ + → |
| Open print preview window | Ctrl + F2 | N/A |
| Apply general format | Ctrl + Shift + ~ | ^ + ⇧ + ~ |
| Delete character to the left of cursor | Backspace | Delete |
| Redo last action | Ctrl + Y | ⌘ + Y |
| Toggle absolute and relative references | Shift + F4 | ⌘ + T |
| Move active cell right in a selection | Tab | Tab |
| Same selection in previous column | N/A | ⌥ +⇧ + Tab |
| Calculate active worksheet | Shift + F9 | Fn + ⇧ + F9 |
| Drag and insert copy | Ctrl + Shift + drag | ⌥ + ⇧ + drag |
| Add non-adjacent cells to selection | Ctrl + Click | ⌘ + Click |
| Delete columns | Ctrl + – | ⌘ + – |
| Apply date format | Ctrl + Shift + # | ^ + ⇧ + # |
| Select one character right | Shift + → | ⇧ + → |
| Move to last cell in worksheet | Ctrl + End | Fn + ^ + → |
| Display find and replace, replace selected | Ctrl + H | ^ + H |
| Move to right edge of data region | Ctrl + → | ^ + → |
| Apply scientific format | Ctrl + Shift + ^ | ^ + ⇧ + ^ |
| Select non-adjacent worksheets | Ctrl + Click | ⌘ + Click |
| Apply time format | Ctrl + Shift + @ | ⌃ + ⇧ + @ |
| Save as | Shift + F12 | ⌘ + ⇧ + S |
| Close current workbook | Ctrl + F4 | ⌘ + W |
| Select row differences | Ctrl + / | ^ + / |
| Autosum selected cells | Alt + = | ⌘ + ⇧ + T |
| Snap to grid | Alt | ⌘ |
| Toggle table total row | Ctrl + Shift + T | ⌘ + ⇧ + T |
| Select to end of cell | Shift + End | Fn + ⇧ + → |
| Format (almost) anything | Ctrl + 1 | ⌘ + 1 |
| Extend selection by one cell left | Shift + ← | ⇧+ ← |
| Select entire worksheet | Ctrl + A | ⌘ + A |
| Toggle pivot table field checkbox | Space | Space |
| Go to next workbook | Ctrl + Tab | ^ + Tab |
| Go to next workbook | Tab | Tab |
| Move one cell right | → | → |
| Indent | Alt + PgDn | Fn + ⌥ + ↓ |
| Hide or show objects | Ctrl + 6 | ^ + 6 |
| Enter same data in multiple cells | Ctrl + Enter | ^ + Return |
| Hide rows | Ctrl + 9 | ^ + 9 |
| Open VBA Editor | Alt + F11 | Fn + ⌥ + F11 |
| Zoom out | Ctrl + Alt + – | ⌥ + ⌘ + – |
| Select active cell only | Shift + Backspace | ⇧ + Delete |
| Copy value from cell above | Ctrl + Shift + “ | ^ + ⇧ + “ |
| Move active cell clockwise in selection | Ctrl + . | ^ + . |
| Cancel and close the dialog box | Esc | Esc |
| Select entire column | Ctrl + Space | ^ + Space |
| Activate filter | Alt + ↓ | ⌥ + ↓ |
| Create pivot chart on new worksheet | Shift + F11 | Fn + F11 |
| Add hyperlink | Ctrl + K | ⌘ + K |
| Select current region | Ctrl + A | ⌘ + A |
| Insert function arguments | Ctrl + Shift + A | ^ + ⇧ + A |
| Open Macro dialog box | Alt + F8 | Fn + ⌥ + F8 |
| Open Group Dialog Box | Alt + Shift + → | ⌘ + ⇧ + K |
| Accept and apply | Enter | Return |
| Drag to duplicate worksheet | Ctrl + drag | ⌥ + drag |
| Select one character left | Shift + ← | ⇧ + ← |
| Confirm control change | Enter | Return |
| Same selection in next column | N/A | ⌥ + Tab |
| Move to left edge of data region | Ctrl + ← | ⌃ + ← |
| Undo last action | Ctrl + Z | ⌘ + Z |
| Fill down from cell above | Ctrl + D | ^ + D |
| Select one character left | Shift + ← | ⇧+ ← |
| Align center | Alt + H + A + C | ⌘ + E |
| Select direct precedents | Ctrl + [ | ^ + [ |
| Paste name into formula | F3 | N/A |
| Apply percentage format | Ctrl + Shift + % | ^ + ⇧ + % |
| Insert current time | Ctrl + Shift + : | ⌘ + ; |
| Start a new line in the same cell | Alt + Enter | ⌃ + ⌥ + Return |
| Move to beginning of row | Home | Fn + ← |
| Display control menu | Alt + Space | ? |
| Drag and copy | Ctrl + drag | ⌥ + drag |
| Move one screen left | Alt + PgUp | Fn + ⌥ + ↑ |
| Open Thesaurus dialog box | Shift + F7 | Fn + ⇧ + F7 |
| Minimize current workbook window | Ctrl + F9 | ⌘ + M |
| Add or remove border top | Alt + T | ⌘ + ⌥ + ↑ |
| Select table | Ctrl + A | ⌘ + A |
| Go to previous worksheet | Ctrl + PgUp | Fn + ^ + ↑ |
| Insert new worksheet | Shift + F11 | Fn + ⇧ + F11 |
| Enter and move left | Shift + Tab | ⇧ + Tab |
| Delete character to the right of cursor | Delete | Fn + Delete |
| Delete cells | Ctrl + – | ⌘ + – |
| Move to next ribbon control | Tab | Tab |
| Cancel selection | Esc | Esc |
| Move right between non-adjacent selections | Ctrl + Alt + → | ^ + ⌥ + → |
| Go to previous workbook | Ctrl + Shift + Tab | ^ + ⇧ + Tab |
| Delete rows | Ctrl + – | ⌘ + – |
Print Excel shortcuts by entering CTRL + P on your keyboard and select ‘save as’ PDF which let you save it on your drive.
If you still