Excel Keyboard Shortcuts for Windows and Mac
Using Excel Keyboard shortcut keys is the best best way to increase your productivity. You can save valuable time while performing tasks on MS Excel. Using the mouse to do all the tasks reduces your productivity. Hence, we will recommend you use Excel Shortcuts rather than a mouse.
On this page, we are providing the list of Excel Keyboard Shortcuts so that you can refer to them and start using them in your day-to-day activities while working on Microsoft Excel.
We have segregated the list of shortcuts basis their functionalities. Please refer to the below tables and start using them.
Working With Excel Files
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| New file | Ctrl + N | ⌘ + N |
| Open | Ctrl + O | ⌘ + O |
| Save | Ctrl + S | ⌘ + S |
| Save as | F12 | ⌘ + Shift + S |
| Ctrl + P | ⌘ + P | |
| Print preview | Ctrl + F2 | |
| Close workbook | Ctrl + W | ⌘ + W |
| Close Excel | Alt + F4 | ⌘ + Q |
Working With Data
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| Copy | Ctrl + C | ⌘ + C |
| Cut | Ctrl + X | ⌘ + X |
| Find | Ctrl + F | ⌘ + F |
| Find and replace | Ctrl + H | Control + H |
| Find next | Shift + F4 | ⌘ + G |
| Find previous | Ctrl + Shift + F4 | ⌘ + Shift + G |
| Paste | Ctrl + V | ⌘ + V |
| Paste special | Ctrl + Alt + V | Control + ⌘ + V |
| Redo | Ctrl + Y | ⌘ + Y |
| Undo | Ctrl + Z | ⌘ + Z |
Moving Within a Workbook
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| Move right | [icon name="arrow-right" class="" unprefixed_class=""] | [icon name="arrow-right" class="" unprefixed_class=""] |
| Move left | [icon name="arrow-left" class="" unprefixed_class=""] | [icon name="arrow-left" class="" unprefixed_class=""] |
| Move up | [icon name="arrow-up" class="" unprefixed_class=""] | [icon name="arrow-up" class="" unprefixed_class=""] |
| Move down | [icon name="arrow-down" class="" unprefixed_class=""] | [icon name="arrow-down" class="" unprefixed_class=""] |
| Move right to next full cell | Ctrl + [icon name="arrow-right" class="" unprefixed_class=""] | Ctrl + [icon name="arrow-right" class="" unprefixed_class=""] |
| Move left to next full cell | Ctrl + [icon name="arrow-left" class="" unprefixed_class=""] | Ctrl + [icon name="arrow-left" class="" unprefixed_class=""] |
| Move up to next full cell | Ctrl + [icon name="arrow-up" class="" unprefixed_class=""] | Ctrl + [icon name="arrow-up" class="" unprefixed_class=""] |
| Move down to next full cell | Ctrl + [icon name="arrow-down" class="" unprefixed_class=""] | Ctrl + [icon name="arrow-down" class="" unprefixed_class=""] |
| Move to beginning of row Home | Home | Fn + [icon name="arrow-left" class="" unprefixed_class=""] |
| Move to last cell | Ctrl + End | Fn + Crtl + [icon name="arrow-right" class="" unprefixed_class=""] |
| Move to first cell | Ctrl + Home | Fn + Option + [icon name="arrow-left" class="" unprefixed_class=""] |
| Scroll right one screen | Alt + PgDn | Fn + Option + [icon name="arrow-up" class="" unprefixed_class=""] |
| Scroll left one screen | Alt + PgUp | Fn + Option + [icon name="arrow-down" class="" unprefixed_class=""] |
| Scroll up one screen | PgUp | Fn + [icon name="arrow-up" class="" unprefixed_class=""] |
| Scroll down one screen | PgDn | Fn + [icon name="arrow-down" class="" unprefixed_class=""] |
| End mode | End | Fn + [icon name="arrow-right" class="" unprefixed_class=""] |
Selecting Cells
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| Go to cell | Ctrl + G | Control + G |
| Select all | Ctrl + A | ⌘ + A |
| Select row | Shift + Space | Shift + Space |
| Select column | Ctrl + Space | Control + Space |
| Select current region | Ctrl + Shift + * | Shift + Control + Space |
| Select current array | Ctrl + / | Control + / |
| Select all precedents | Ctrl + Shift + { | Control + Shift + { |
| Select direct dependents | Ctrl + ] | Control + ] |
| Select all dependents | Ctrl + Shift + } | Control + Shift + } |
| Select only visible cells | Alt + ; | ⌘ + Shift + Z |
| Add cell range to selection | Shift + Click | Shift + Click |
| Add one-off cells to selection | Ctrl + Click | ⌘ + Click |
| Move active cell right to non-adjacent selection | Ctrl + Alt + [icon name="arrow-right" class="" unprefixed_class=""] | Ctrl + Option + [icon name="arrow-right" class="" unprefixed_class=""] |
| Move active cell left to non-adjacent selection | Ctrl + Alt + [icon name="arrow-left" class="" unprefixed_class=""] | Ctrl + Option + [icon name="arrow-left" class="" unprefixed_class=""] |
| Move selection one column left | Option + Tab | |
| Move selection one column right | Option + Shift + Tab | |
| Toggle selection add mode | Shift + F8 | Fn + Shift + F8 |
| Clear selection | Esc | Esc |
| Expand selection to the right | Shift + [icon name="arrow-right" class="" unprefixed_class=""] | Shift + [icon name="arrow-right" class="" unprefixed_class=""] |
| Expand selection to the left | Shift + [icon name="arrow-left" class="" unprefixed_class=""] | Shift + [icon name="arrow-left" class="" unprefixed_class=""] |
| Expand selection up | Shift + [icon name="arrow-up" class="" unprefixed_class=""] | Shift + [icon name="arrow-up" class="" unprefixed_class=""] |
| Expand selection down | Shift + [icon name="arrow-down" class="" unprefixed_class=""] | Shift + [icon name="arrow-down" class="" unprefixed_class=""] |
| Expand selection to last full cell to the right | Ctrl + Shift + [icon name="arrow-down" class="" unprefixed_class=""] | ⌘ + Shift + [icon name="arrow-right" class="" unprefixed_class=""] |
| Expand selection to last full cell to the left | Ctrl + Shift + [icon name="arrow-left" class="" unprefixed_class=""] | ⌘ + Shift + [icon name="arrow-left" class="" unprefixed_class=""] |
| Expand selection to last full cell up | Ctrl + Shift + [icon name="arrow-up" class="" unprefixed_class=""] | ⌘ + Shift + [icon name="arrow-up" class="" unprefixed_class=""] |
| Expand selection to last full cell down | Ctrl + Shift + [icon name="arrow-down" class="" unprefixed_class=""] | ⌘ + Shift + [icon name="arrow-down" class="" unprefixed_class=""] |
| Expand selection up full screen | Shift + PgUp | Fn + Shift + [icon name="arrow-up" class="" unprefixed_class=""] |
| Expand selection down full screen | Shift + PgDn | Fn + Shift + [icon name="arrow-down" class="" unprefixed_class=""] |
| Expand selection to beginning of row | Shift + Home | Fn + Shift + [icon name="arrow-left" class="" unprefixed_class=""] |
| Expand selection to first worksheet cell | Ctrl + Shift + Home | Fn + Control + Shift + [icon name="arrow-left" class="" unprefixed_class=""] |
| Expand selection to last worksheet cell | Ctrl + Shift + End | Fn + Control + Shift + [icon name="arrow-right" class="" unprefixed_class=""] |
| Toggle extend selection mode | F8 | Fn + F8 |
| Select only cells with comments | Ctrl + Shift + O | Fn + Control + Shift + O |
| Select row differences | Ctrl + \ | Control + Shift + | |
| Select direct precedents | Ctrl + [ | Control + [ |
Working With Active Cells
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| Only select active cell | Shift + Backspace | Shift + Delete |
| Show active cell | Ctrl + Backspace | ⌘ + Delete |
| Move active cell clockwise | Ctrl + . | Control + . |
| Move active cell down | Enter | Shift + Return |
| Move active cell right | Tab | Tab |
| Move active cell left | Shift + Tab | Shift + Tab |
Editing Formulas
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| Edit active cell | F2 | Control + U |
| Cancel entry | Esc | Esc |
| Delete to end of line | Ctrl + Delete | Control + Delete |
| Delete character in back of cursor | Backspace | Backspace |
| Delete character in front of cursor | Delete | Fn + Delete |
| New line within cell | Alt + Enter | Control + Option + Return |
| Add character to the right to selection | Shift + [icon name="arrow-right" class="" unprefixed_class=""] | Shift + [icon name="arrow-right" class="" unprefixed_class=""] |
| Add character to the left to selection | Shift + [icon name="arrow-left" class="" unprefixed_class=""] | Shift + [icon name="arrow-left" class="" unprefixed_class=""] |
| Move one word right | Shift + [icon name="arrow-right" class="" unprefixed_class=""] | Shift + [icon name="arrow-right" class="" unprefixed_class=""] |
| Move one word left | Ctrl+ [icon name="arrow-left" class="" unprefixed_class=""] | Control + [icon name="arrow-left" class="" unprefixed_class=""] |
| Add word to right to selection | Ctrl+ Shift + [icon name="arrow-right" class="" unprefixed_class=""] | Control + Shift + [icon name="arrow-right" class="" unprefixed_class=""] |
| Add word to left to selection | Ctrl+ Shift + [icon name="arrow-left" class="" unprefixed_class=""] | Control + Shift + [icon name="arrow-left" class="" unprefixed_class=""] |
| Select from beginning of cell to current position | Shift + Home | Fn + Shift + [icon name="arrow-left" class="" unprefixed_class=""] |
| Select from current position to end of cell | Shift + End | Fn + Shift + [icon name="arrow-right" class="" unprefixed_class=""] |
| Insert comment | Shift + F2 | Fn + Shift + F2 |
Entering Data
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| Commit and move down | Enter | Return |
| Commit and move up | Shift + Enter | Shift + Return |
| Commit and move right | Tab | Tab |
| Commit and move left | Shift + Tab | Shift + Tab |
| Commit and stay in same cell | Ctrl + Enter | Control + Return |
| Enter data in multiple cells | Ctrl + Enter | Control + Return |
| Insert current date | Ctrl + ; | Control + Return |
| Insert current date | Ctrl + ; | Control + ; |
| Insert current time | Ctrl + Shift + : | Control + Shift + : |
| Fill from cell above | Ctrl + D | Control + Shift + : |
| Fill from cell above | Ctrl + D | Control + D |
| Fill from cell to left | Ctrl + R | Control + R |
| Fill formula from cell above | Ctrl + ' | Control + ' |
| Hyperlink | Ctrl + K | ⌘ + K |
| Display Autocomplete | Alt + [icon name="arrow-down" class="" unprefixed_class=""] | Option + [icon name="arrow-down" class="" unprefixed_class=""] |
Using the Ribbon
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| Show / hide Ribbon | Ctrl + F1 | ⌘ + Option + R |
| Enter Windows hotkey combination | Alt | |
| Help | F1 |
Formatting Cells
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| Open format dialogue | Ctrl + 1 | ⌘ + 1 |
| Re-apply format | F4 | Control + Y |
| Align center | Alt + H + A + C | ⌘ + E |
| Align left | Alt + H + A + L | ⌘ + L |
| Align right | Alt + H + A + R | ⌘ + R |
| Indent | Alt + H + 6 | Control + Option + Tab |
| Un-indent | Alt + H + 5 | Control + Option + Shift + Tab |
| Increase font size | Alt + H + FG | ⌘ + Shift + > |
| Decrease font size | Alt + H + FK | ⌘ + Shift + < |
| Format as general | Ctrl + Shift + ~ | Control + Shift + ~ |
| Format as currency | Ctrl + Shift + $ | Control + Shift + $ |
| Format as percentage | Ctrl + Shift + % | Control + Shift + % |
| Format as scientific | Ctrl + Shift + ^ | Control + Shift + ^ |
| Format as date | Ctrl + Shift + # | Control + Shift + # |
| Format as time | Ctrl + Shift + @ | Control + Shift + @ |
| Format as number | Ctrl + Shift + ! | Control + Shift + ! |
| Bold | Ctrl + B | ⌘ + B |
| Italic | Ctrl + I | ⌘ + I |
| Underline | Ctrl + U | ⌘ + U |
| Strikethrough | Ctrl + 5 | ⌘ + Shift + X |
| Add shadow | ⌘ + Shift + W | |
| Add outline | ⌘ + Shift + D | |
| Border all | Ctrl + Shift + & | ⌘ + Option +& |
| Border right | Alt + R | ⌘ + Option + [icon name="arrow-right" class="" unprefixed_class=""] |
| Border left | Alt + L | ⌘ + Option + [icon name="arrow-left" class="" unprefixed_class=""] |
| Border top | Alt + T | ⌘ + Option + [icon name="arrow-up" class="" unprefixed_class=""] |
| Border bottom | Alt + B | ⌘ + Option + [icon name="arrow-down" class="" unprefixed_class=""] |
| Border interior horizontal | Alt + H | |
| Border interior vertical | Alt + V | |
| Remove borders | Ctrl + Shift + _ | ⌘ + Option + _ |
Calculations
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| Toggle reference (relative, mixed and absolute) | F4 | ⌘ + T |
| Calculate all sheets | F9 | Fn + F9 |
| Calculate only active sheet | Shift + F9 | Fn + Shift + F9 |
| Autosum | Alt + = | ⌘ + Shift + T |
| Insert function | Shift + F3 | Fn + Shift + F3 |
| Show function arguments | Ctrl + Shift + A | Control + Shift + A |
| Commit array formula | Ctrl + Shift + Enter | Control + Shift + Return |
| Evaluate part of formula | F9 | Fn + F9 |
| Toggle formula bar | Ctrl + Shift + U | Control + Shift + U |
| Show formula builder | Ctrl + A | Control + A |
| Define name | Ctrl + F3 | Control + L |
| Create name | Ctrl + Shift + F3 | Control + Shift + F3 |
| Paste name into formula | F3 |
Worksheets and Workbooks
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| New worksheet | Shift + F11 | Shift + F11 |
| Next worksheet | Ctrl + PgDn | Fn + Control + [icon name="arrow-down" class="" unprefixed_class=""] |
| Previous worksheet | Ctrl + PgUp | Fn + Control + [icon name="arrow-up" class="" unprefixed_class=""] |
| Next workbook | Ctrl + Tab | Control + Tab |
| Previous workbook | Ctrl + Shift + Tab | Control + Shift + Tab |
| Next pane | F6 | F6 |
| Previous pane | Shift + F6 | Shift + F6 |
| Minimize window | Ctrl + F9 | ⌘ + M |
| Maximize window | Ctrl + F1 | |
| Select multiple worksheets | Shift + Click | Shift + Click |
| Select one-off single worksheets | Ctrl + Click | ⌘ + Click |
Rows and Columns
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| Insert rows / columns dialogue | Ctrl + Shift + + | Control + I |
| Insert rows | Ctrl + Shift + + | Control + I |
| Insert columns | Ctrl + Shift + + | Control + I |
| Delete dialog | Ctrl + - | Control + - |
| Delete rows | Ctrl + - | Control + - |
| Delete columns | Ctrl + - | Control + - |
| Delete cells | Ctrl + - | Control + - |
| Clear cells | Delete | Fn + Delete |
| Group | Alt + Shift + [icon name="arrow-right" class="" unprefixed_class=""] | ⌘ + Shift + K |
| Ungroup | Alt + Shift + [icon name="arrow-left" class="" unprefixed_class=""] | ⌘ + Shift + J |
| Group dialog | Alt + Shift + [icon name="arrow-right" class="" unprefixed_class=""] | ⌘ + Shift + K |
| Ungroup dialog | Alt + Shift + [icon name="arrow-left" class="" unprefixed_class=""] | ⌘ + Shift + J |
| Hide columns | Ctrl + | Control + |
| Hide rows | Ctrl + 9 | Control + 9 |
| Unhide rows | Ctrl + Shift + 9 | Control + Shift + 9 |
| Unhide columns | Ctrl + Shift + | Control + Shift + |
| Toggle outline symbols | Ctrl + 8 | Control + 8 |
Charts, Filters, and Pivots
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| Create chart | Alt + F1 | Fn + Option + F1 |
| Create chart (new sheet) | F11 | Fn + F11 |
| Autofilter | Ctrl + Shift + L | ⌘ + Shift + F |
| Open filters | Alt + [icon name="arrow-down" class="" unprefixed_class=""] | Option + [icon name="arrow-down" class="" unprefixed_class=""] |
| Insert table | Ctrl + T | Control + T |
| Group pivot table items | Alt + Shift +[icon name="arrow-right" class="" unprefixed_class=""] | ⌘ + Shift + K |
| Ungroup pivot table items | Alt + Shift +[icon name="arrow-left" class="" unprefixed_class=""] | ⌘ + Shift + J |
| Hide pivot table item | Ctrl + - | Ctrl + - |
| Create pivot chart | Alt + F1 | |
| Create pivot chart on new sheet | F11 | Fn + F11 |
| Pivot table wizard | Alt + D + P | ⌘ + Option + P |
Helper Modules
| FUNCTION | WINDOWS | MAC |
|---|---|---|
| Spell check | F7 | F7 |
| Thesaurus | Shift + F7 | Shift + F7 |
| VBA editor | Alt + F11 | Fn + Option + F11 |
| Macros | Alt + F8 | Fn + Option + F8 |
| Hide or show | Ctrl + 6 | Control + 6 |
| Duplicate | Ctrl + D | ⌘ + D |
| Modify cell style | Alt + ' | ⌘ + Shift + L |
| Control menu | Alt + Space | ? |
| Shortcut menu | Shift + F1 | Fn + Shift + F1 |
