This page contains a list of over 300+ Excel shortcuts for the Windows and Mac versions of Excel to speed up your work and productivity. Also, download a printable cheat sheet in PDF about keyboard shortcuts.
How to use Excel Shortcuts (Press, Hold and Release Keys)
Before we take a deep dive into the topic, keep in mind the following rules. Excel shortcuts use two types of dividers: the comma sign (,) and the plus (+) sign. Just a few words about the differences:
A comma sign (,) means that you need to press and release keys in order. For example, if you want to use the ‘Increase font size‘ shortcut in Excel, use the Alt, H, F, G combination. Press Alt, then release Alt, then press H, release H, and so on.
A plus sign (+) means that you need to press and hold each key in order. To increase the font size in Mac Excel, use the Command + Shift + > shortcut. In this case, press the keys at the same time.
Let’s get started! Also, discover our latest post on what if your shortcuts are not working.
Types of Excel Shortcuts
Formula Shortcuts
Working with Excel Formulas is easy; use shortcuts to manage formulas on the fly! Learn about the most important shortcuts and make your rows and columns-related tasks easy!
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Begin entering a formula | = OR + | = OR + |
Toggle Enter and Edit modes while editing formula | F2 | Ctrl + U |
Exit cell edit mode | Esc | Esc |
Toggle absolute and relative references | F4 | Cmd + T |
Open the Insert Function Dialog Box | Shift + F3 | Fn + Shift + F3 |
Autosum selected cells | Alt + = | Cmd + Shift + T |
Toggle formulas on and off | Ctrl + ` | Ctrl + ` |
Insert function arguments | Ctrl + Shift + A | Ctrl + Shift + A |
Enter array formula | Ctrl + Shift + Enter | Ctrl + Shift + Return |
Calculate worksheets | F9 | Fn + F9 |
Calculate active worksheet | Shift + F9 | Fn + Shift + F9 |
Force calculates all worksheets | Ctrl + Alt + F9 | |
Evaluate part of a formula | F9 | Fn + F9 |
Expand or collapse the formula bar | Ctrl + Shift + U | Ctrl + Shift + U |
Display function arguments dialog box | Ctrl + A | Ctrl + A |
Open the Name Manager | Ctrl + F3 | Fn + Ctrl + F3 |
Define name using row and column labels | Ctrl + Shift + F3 | Fn + Ctrl + Shift + F3 |
Paste name into formula | F3 | |
Accept function with autocomplete | Tab | ↓ + Tab |
Grid Operation Shortcuts
If you are working with Excel, using the grid is essential. The following list contains the most useful Excel shortcuts regarding grid navigation. Select cells and ranges as soon as possible. Excel basic shortcuts like hiding and unhiding rows & columns boost your productivity.
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Display Insert Dialog box | Ctrl + Shift + + | Ctrl + Shift + + |
Insert rows | Ctrl + Shift + + | Ctrl + Shift + + |
Insert columns | Ctrl + Shift + + | Ctrl + Shift + + |
Display Delete dialog box | Ctrl + – | Cmd + – |
Delete rows | Ctrl + – | Cmd + – |
Delete columns | Ctrl + – | Cmd + – |
Delete cells | Ctrl + – | Cmd + – |
Delete contents of selected cells | Delete | Fn + Delete |
Merge cells | Alt, H, M, C | Ctrl + M |
Hide columns | Ctrl + 0 | Ctrl + 0 |
Hide rows | Ctrl + 9 | Ctrl + 9 |
Unhide rows | Ctrl + Shift + 9 | Ctrl + Shift + 9 |
Unhide columns | Ctrl + Shift + 0 | Ctrl + Shift + 0 |
Group rows or columns | Alt + Shift + → | Cmd + Shift + K |
Ungroup rows or columns | Alt + Shift + ← | Cmd + Shift + J |
Open Group Dialog Box (with cell or range selected) | Alt + Shift + → | Cmd + Shift + K |
Open Ungroup Dialog Box (with cell or range selected) | Alt + Shift + ← | Cmd + Shift + J |
Hide or show outline symbols | Ctrl + 8 | Ctrl + 8 |
Data Entry Shortcuts
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
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 the same cell | Ctrl + Enter | Ctrl + Return |
Enter same data in multiple cells | Ctrl + Enter | Ctrl + Return |
Insert current date | Ctrl + ; | Ctrl + ; |
Insert current time | Ctrl + Shift + : | Cmd + : |
Fill down from cell above | Ctrl + D | Ctrl + D |
Fill right from cell left | Ctrl + R | Ctrl + R |
Copy value from the cell above | Ctrl + ‘ | Ctrl+’ |
Copy value (the result of formula) from the cell above | Ctrl + Shift + “ | Ctrl + Shift + “ |
Display AutoComplete list | Alt + ↓ | Alt + ↓ |
Flash fill | Ctrl + E | |
Quick Analysis Tool (select cells first) | Ctrl + Q |
Editing Text (Cell edit mode)
If you edit a text, write a code, or create a custom formula, you can use these Excel shortcuts in all areas.
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Edit the active cell | F2 | Ctrl + U |
Insert or edit cell note | Shift + F2 | Fn+Shift+F2 |
Insert or reply to Cell Comment | Ctrl + Shift + F2 | Fn + Ctrl + Shift + F2 |
Delete comment | Shift + F10, M | |
Cancel entry | Esc | Esc |
Select one character right | Shift + → | Shift + → |
Select one character left | Shift + ← | Shift + ← |
Move one word right | Ctrl + → | Ctrl + → |
Move one word left | Ctrl + ← | Ctrl + ← |
Select one word right | Ctrl + Shift + → | Ctrl+Shift+→ |
Select one word left | Ctrl + Shift + ← | Ctrl + Shift + ← |
Select to the beginning of the cell | Shift + Home | Fn + Shift + ← |
Select to end of the cell | Shift + End | Fn + Shift + → |
Delete to end of line | Ctrl + Delete | Ctrl + Delete |
Delete a character to the left of the cursor | Backspace | Delete |
Delete characters to the right of the cursor | Delete | Fn + Delete |
Start a new line in the same cell (line break command) | Alt + Enter | Ctrl + Alt + Return |
Formatting Shortcuts
Number Formatting
Use these shortcuts in Excel to apply number formats to a cell or cells in a range.
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Format Painter | Alt, H, F, P | |
Transpose data | Alt, H, V, S then Alt + E | |
Apply general format | Ctrl + Shift + ~ | Ctrl + Shift + ~ |
Apply currency format | Ctrl + Shift + $ | Ctrl + Shift + $ |
Apply percentage format | Ctrl + Shift + % | Ctrl + Shift + % |
Apply scientific format | Ctrl + Shift + ^ | Ctrl + Shift + ^ |
Apply date format | Ctrl + Shift + # | Ctrl + Shift + # |
Apply time format | Ctrl + Shift + @ | Ctrl + Shift + @ |
Apply number format | Ctrl + Shift + ! | Ctrl + Shift + ! |
Cell and Font Formatting
Here is the list of useful shortcuts regarding cell and font formatting. Locate the ribbon and choose the Home Tab, and take a closer look at the functions.
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Format Window for cells and objects | Ctrl + 1 | Cmd + 1 |
Display Format Cells with Font tab selected | Ctrl + Shift + F | Ctrl + Shift + F |
Apply or remove bold formatting | Ctrl + B | Cmd + B |
Apply or remove italic formatting | Ctrl + I | Cmd + I |
Apply or remove underscoring | Ctrl + U | Cmd + U |
Apply or remove strikethrough formatting | Ctrl + 5 | Cmd + Shift + X |
Superscript format on a selected character | Ctrl + Shift + F then Alt + F | Ctrl + Cmd + + |
Subscript format on a selected character | Ctrl +1 then Alt + B | Cmd +1 then select the Subscript checkbox |
Apply fill color | Alt, H, V, R | |
Add or remove the shadow font style | Cmd + Shift + W | |
Add or remove the outline font style | Cmd + Shift + D | |
Align center | Alt, H, A, C | Cmd + E |
Align left | Alt, H, A, L | Cmd + L |
Align right | Alt, H, A, R | Cmd + R |
Align top | Alt, H, A, T | |
Align middle | Alt, H, A, M | |
Indent | Alt, H, 6 | Ctrl+Alt+Tab |
Remove indent | Alt, H, 5 | Ctrl + Alt + Shift + Tab |
Increase font size one step | Alt, H, F, G | Cmd + Shift + > |
Decrease font size one step | Alt, H, F, K | Cmd + Shift + < |
Wrap Text | Alt, H, W |
Formatting Charts and Shapes
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Create a chart or PivotChart on the same worksheet | Alt + F1 | Fn + Alt + F1 |
Create a chart in the new ChartSheet | F11 | Fn + F11 |
Open Format Chart Area Task Pane | Ctrl +1 | Cmd+1 |
Show or Hide All Field Buttons on PivotChart | Alt, J, T, D, A | |
Snap to Grid | Alt | Cmd + |
Hide or show objects (shapes, charts, slicers) | Ctrl + 6 | Ctrl + 6 |
Rows and Columns Shortcuts (Selection)
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Select entire row | Shift + Space | Shift+Space |
Select entire column | Ctrl + Space | Ctrl + Space |
Select entire worksheet | Ctrl + A | Cmd + A |
Add adjacent cells to selection | Shift + Click | Shift + Click |
Add non-adjacent cells to selection | Ctrl + Click | Cmd + Click |
Same selection in next column | Opt + Tab | |
Same selection in the previous column | Opt + Shift + Tab | |
Move right between non-adjacent selections | Ctrl + Alt + → | Ctrl + Alt + → |
Move left between non-adjacent selections | Ctrl + Alt + ← | Ctrl + Alt + ← |
Toggle add or remove to selection mode | Shift + F8 | Fn + Shift + F8 |
Cancel selection | Esc | Esc |
Active Cell
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Select a single (active) cell when the range is selected | Shift + Backspace | Shift + Delete |
Show the active cell on the worksheet | Ctrl + Backspace | Cmd + Delete |
Activate each corner cell in selected range in clockwise direction | Ctrl + . | Ctrl + . |
Activate next cell in the selected range (based on direction set in Excel Options) | Enter | Return |
Activate the previous cell in selection (based on direction set in Excel Options) | Shift + Enter | Shift + Return |
Activate next cell to right/below in the selected range | Tab | Tab |
Activate the previous cell to left/above in a selected range | Shift + Tab | Shift + Tab |
Extend Selection
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
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 + → | Ctrl + Shift + → |
Extend the selection to the last cell left | Ctrl + Shift + ← | Ctrl + Shift + ← |
Extend the selection to the last cell up | Ctrl + Shift + ↑ | Ctrl + Shift + ↑ |
Extend the selection to the last cell down | Ctrl + Shift + ↓ | Ctrl + Shift + ↓ |
Extend selection up one screen | Shift + PgUp | Fn + Shift + ↑ |
Extend selection down one screen | Shift + PgDn | Fn + Shift + ↓ |
Extend selection right one screen | Alt + Shift + PgDn | Fn + Shift + Alt + ↓ |
Extend selection left one screen | Alt + Shift + PgUp | Fn + Shift + Alt + ↑ |
Extend selection to start of the row | Shift + Home | Fn + Shift + ← |
Extend selection to the first cell in a worksheet | Ctrl + Shift + Home | Fn + Ctrl + Shift + ← |
Extend selection to the last cell in a worksheet | Ctrl + Shift + End | Fn + Ctrl + Shift + → |
Toggle extend selection mode | F8 | Fn + F8 |
Select Spill Range | Ctrl + A |
Select Special Cells
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Display ‘Go To’ dialog box | Ctrl + G | Ctrl + G |
Open the Go To Special window | Alt, H, F, D, S | |
Select cells with comments (Note) | Ctrl + Shift + O | Fn + Ctrl + Shift + O |
Select current region around the active cell | Ctrl + Shift + 8 | Shift + Ctrl + Space |
Select current region | Ctrl + A | Cmd + A |
Select current array | Ctrl + / | Ctrl + / |
Select row differences | Ctrl + \ | Ctrl + \ |
Select column differences | Ctrl + Shift + | | Ctrl + Shift + | |
Select direct precedents | Ctrl + [ | Ctrl + [ |
Select all precedents | Ctrl + Shift + { | Ctrl + Shift + { |
Select direct dependents | Ctrl + ] | Ctrl + ] |
Select all dependents | Ctrl + Shift + } | Ctrl + Shift + } |
Select visible cells only (when range is selected) | Alt + ; | Cmd + Shift + Z |
Cell Borders
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Open Border dropdown menu on Home Tab | Alt, H, B | |
Add all borders to cells in the selected range | Alt, H, B, A | |
Add or remove Right Border | Alt, H, B, R | Cmd + Alt + → |
Add or remove Left Border | Alt, H, B, L | Cmd + Alt + ← |
Add or remove Top Border | Alt, H, B, P | Cmd + Alt + ↑ |
Add or remove Bottom Border | Alt, H, B, O | Cmd + Alt + ↓ |
Remove all borders (apply no borders) | Ctrl + Shift + _ | Cmd + Alt + _ |
WorkSheet Tab Shortcuts
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Insert new worksheet | Shift + F11 | Fn + Shift + F11 |
Go to the next worksheet | Ctrl + PgDn | Fn + Ctrl + ↓ |
Go to the previous worksheet | Ctrl + PgUp | Fn + Ctrl + ↑ |
Delete selected worksheets | Alt, E, L | |
Rename current worksheet | Alt, O, H, R | |
Select adjacent worksheets | Ctrl + Shift + PgUp/PgDn | |
Select adjacent worksheets (mouse) | Shift + Click | Shift + Click |
Select non-adjacent worksheets (mouse) | Ctrl + Click | Cmd + Click |
Open Move or Copy window for selected sheets | Alt, E, M | |
Duplicate worksheet (mouse) | Ctrl + drag | Alt + drag |
Protect or Unprotect a WorkSheet | Alt, R, P, S | |
Clear print area | Alt, P, R, C | |
Set print area | Alt, P, R, S |
Workbook Shortcuts
Command | Windows | Mac |
---|---|---|
Create a new Workbook | Ctrl + N | Cmd + N |
Open Workbook | Ctrl + O | Cmd + O |
Save Workbook | Ctrl + S | Cmd + S |
Save As | F12 | Cmd + Shift + S |
Print File | Ctrl + P | Cmd + P |
Open Print Preview Window | Ctrl + F2 | |
Close Current Workbook | Ctrl + W | Cmd + W |
Close Excel | Alt + F4 | Cmd + Q |
Increase or decrease Zoom | Ctrl + Alt + mouse wheel |
Workbook Actions & Options
Command | Windows | Mac |
---|---|---|
Undo the last action | Ctrl + Z | Cmd + Z |
Redo the last action | Ctrl + Y | Cmd + Y |
Repeat last action | F4 | Cmd + Y |
Open Excel Options window | Alt, F, T | Cmd + , |
Open help | F1 | |
Open the Control Menu | Alt + Space | |
Open Spelling window (Spell Check) | F7 | Fn + F7 |
Open Thesaurus dialog box | Shift + F7 | Fn + Shift + F7 |
Open Right-click menu | Shift + F10 | Fn + Shift + F10 |
Move to the next pane in the application window | F6 | Fn + F6 |
Move to the previous pane | Shift + F6 | Fn + Shift + F6 |
Protect and Unprotect Workbook | Alt, R, P, W |
Workbook View Settings
Command | Windows | Mac |
---|---|---|
Minimize current workbook window | Ctrl + F9 | Cmd + M |
Maximize or Restore current workbook window | Ctrl + F10 | Fn + Ctrl + F10 |
Toggle full screen | Ctrl + Shift + F1 | Ctrl + Cmd + F |
Go to previous workbook | Ctrl + Shift + Tab | Ctrl + Shift + Tab |
Go to next workbook | Ctrl + Tab | Ctrl + Tab |
Ribbon Shortcuts
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Quick Access Toolbar (QAT) | Alt, Num keys | |
Activate Ribbon shortcut keys | Alt | |
Move to the next ribbon control | Tab | Tab |
Move through Ribbon tabs and groups | → ← ↑ ↓ | |
Open dropdown menu of the selected button | Alt + ↓ | Alt + ↓ |
Expand or collapse the ribbon | Ctrl + N | Cmd + Alt + R |
Activate access key | Ctrl + O | Ctrl + O |
Move to the next ribbon control | Ctrl + S | Ctrl + S |
Activate or open the selected control | F12 | Crtl + Shift + S |
Confirm control change | Ctrl + P | Ctrl + P |
Get help on selected control | Ctrl + W | Cmd + W |
Table and Filter Shortcuts
Tables are essential in Excel. Filters too. If you want to learn more about filters, check our guide.
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Insert table | Ctrl +T | Ctrl +T |
Insert Table (select style first) | Alt, H, T | |
Insert a row above the current row | Alt, H, I, R | |
Insert a column to the left of the current column | Alt, H, I, C | |
Select Table Body | Ctrl + A | Cmd+A |
Select Table row | Shift + Space | Shift + Space |
Open Filter Dropdown Menu | Alt + ↓ | Alt + ↓ |
Open Filter Dropdown Menu (from any cell in a Table) | Shift + Alt+ ↓ | Shift + Alt+ ↓ |
Toggle Total Row on/off | Ctrl + Shift + T | Cmd + Shift + T |
Clear slicer filter (with slicer selected) | Alt + C | Alt + C |
Copy & Paste Shortcuts (Objects)
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Copy selected object (cells, range, shape) | Ctrl + C | Cmd + C |
Cut selected object | Ctrl + X | Cmd + X |
Paste content from the clipboard | Ctrl + V | Cmd + V |
Paste Values | Alt, E, S, V | Cmd, Ctrl, V, V |
Open the Paste Special window | Ctrl + Alt + V | Cmd + Ctrl + V |
Duplicate selected object (shapes, charts, slicers) | Ctrl + D | Cmd + D |
Copy selected range or shape (mouse) | Ctrl + Drag | Alt + Drag |
Copy selected ojbects and retain vertical or horizontal alignment (mouse) | Ctrl + Shift + Drag | Cmd + Shift + Drag |
Copy selected objects (mouse right-click) | Right-click + Drag | Right-click + Drag |
Copy selected objects and retain vertical or horizontal alignment (right-click mouse) | Right-click + Shift + Drag | Right-click + Shift + Drag |
Pivot Table Shortcuts
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Insert a new Pivot Table | Alt, N, V | |
Refresh Pivot Table or Query | Alt + F5 | |
Refresh All | Ctrl + Alt + F5 | Cmd + Alt + P |
Open pivot table wizard | Alt, D, P | Cmd + Alt + P |
Select entire pivot table | Ctrl + A | Cmd + A |
Group pivot table items | Shift + Alt + → | Cmd + Shift + K |
Ungroup pivot table items | Shift + Alt + ← | Cmd + Shift + J |
Unhide (clear filter on) pivot table item | Alt, H, S, C | |
Filter out (exclude/hide) pivot item | Ctrl + – | Ctrl – |
Open Filter Dropdown Menu in Pivot Table cells | Alt + ↓ | Alt + ↓ |
Toggle pivot table field checkbox | Space | Space |
Insert pivot chart | Alt + F1 | Fn + Alt + F1 |
Create pivot chart on new Chart Sheet | F11 | Fn + F11 |
Navigation Shortcuts
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Move one cell right | → | → |
Move one cell left | ← | ← |
Move one cell up | ↑ | ↑ |
Move one cell down | ↓ | ↓ |
Select cell one screen to the right of the active cell | Alt + PgDn | Fn + Alt + ↓ |
Select cell one screen to the left of the active cell | Alt + PgUp | Fn + Alt + ↑ |
Move one screen down | PgDn | Fn + ↓ |
Select the first/last cell of a region (non-blank cells) moving right | Ctrl + → | Ctrl + → |
Select the first/last cell of a region (non-blank cells) moving down | Ctrl + ← | Ctrl + ← |
Select the first/last cell of a region (non-blank cells) moving up | Ctrl + ↑ | Ctrl + ↑ |
Select the first/last cell of a region (non-blank cells) moving down | Ctrl + ↓ | Ctrl + ↓ |
Move to begin of row | Home | Fn + ← |
Select the last used cell in the sheet | Ctrl + End | Fn + Ctrl + → |
Select the first visible cell in the sheet | Ctrl + Home | Fn + Ctrl + Home |
Turn End mode on (like Ctrl+Arrow Keys) | End | Fn + → |
Go back to the hyperlink | Ctrl+G, Enter | Ctrl+G, Return |
Other Shortcuts
Macros and VBA Editor
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Open the VBE window (edit VBA code) | Alt + F11 | Fn + Alt + F11 |
Open the Macro window to run or edit a macro | Alt + F8 | Fn + Alt + F8 |
Record Macro | Alt, L, R | |
Open Excel Add-ins Window | Alt, L, H | |
Open COM Add-ins Window | Alt, L, J | |
Open Excel Web Add-ins Window | Alt, L, A, 1 |
Power Query
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Open the Power Query Editor | Alt, A, P, L, N | |
Press any button in the Power Query Ribbon | Alt, Letter Sequence | |
Rename Column | F2 | |
Remove Column(s) | Delete | |
Select All Columns | Ctrl + A | |
Select First Column | Home | |
Select Last Column | End | |
Select Multiple Adjacent Columns | Shift + → or ← | |
Select Multiple Non-Adjacent Columns | Ctrl + → or ←, Space | |
Open Filter Drop-down Menu | Alt + ↓ | |
Open Right-click Menus | Menu Key | |
Open Table Options Menu | Select First Column, ← , Space | |
Select Task Panes & Ribbon | Tab & Shift + Tab | |
Close Power Query Window | Alt + F4 | |
Close & Load | Alt, F, Enter |
We hope you find this Excel shortcuts list helpful. Stay tuned.