Excel Keyboard Shortcuts

Master Excel with these essential keyboard shortcuts

How to Use Shortcut Keys

If you notice the shortcuts below, you will see that there are two types of separators:

Plus (+) separator: Press all keys together simultaneously.
Example:

Ctrl +
                                            N

means press and hold both Ctrl and N at the same time.

Comma (,) separator: Press each key one after the other.
Example:

Alt, H,
                                            B, A

means press Alt, then H, then B, then A in sequence.

💡 Tap any shortcut to see step-by-step examples!

Alignment Shortcuts

Description	Windows	Mac
Align content to the center of the cell	`Alt, H, A, C`	`⌘ + Option + C`
Align content to the left of the cell	`Alt, H, A, L`	`⌘ + Option + L`
Align content to the right of the cell	`Alt, H, A, R`	`⌘ + Option + R`
Align content to the middle of the cell	`Alt, H, A, M`	`⌘ + Option + M`

Charting Shortcuts

Description	Windows	Mac
Insert chart in the worksheet (using selected data)	`Alt + F1`	`⌘ + Option + F1`
Insert a ChartSheet with a chart (using selected data)	`F11`	`⌘ + Option + F11`

Clear Shortcuts in Excel

Description	Windows	Mac
Clear all contents with formatting and comments	`Alt, H, E, A`	`⌘ + Option + E, A`
Clear only the cell formatting	`Alt, H, E, F`	`⌘ + Option + E, F`
Clear only the cell content	`Alt, H, E, C`	`⌘ + Option + E, C`
Clear only hyperlinks from selected cells	`Alt, H, E, L`	`⌘ + Option + E, L`
Clear only comments from selected cells	`Alt, H, E, M`	`⌘ + Option + E, M`

Conditional Formatting Shortcuts

Description	Windows	Mac
Open Conditional Formatting dialog box	`Alt, O, D`	`⌘ + Option + D`
Remove Conditional Formatting from Selected Cells	`Alt, H, L, C, S`	`⌘ + Option + Command + C`
Remove Conditional Formatting from the Entire Worksheet	`Alt, H, L, C, E`	`⌘ + Option + Command + E`

Cut, Copy, and Paste Shortcuts in Excel

Description	Windows	Mac
Copy the values from selected cells	`Ctrl + C`	`⌘ + C`
Cut the values from selected cells	`Ctrl + X`	`⌘ + X`
Paste copied content from the clipboard	`Ctrl + V`	`⌘ + V`
Copy the formula from the cell above	`Ctrl + ‘`	`⌘ + Shift + ‘`
Copy the value from above cell	`Ctrl + Shift + ‘`	`⌘ + Option + ‘`
Show the Paste Special dialog box	`Ctrl + Alt + V`	`⌘ + Option + V`

Data Entry Shortcuts in Excel

Description	Windows	Mac
Move to the next cell below	`Enter`	`Enter`
Enter data and stay in the same cell	`Ctrl + Enter`	`⌘ + Enter`
Move to the previous cell	`Shift + Enter`	`Shift + Enter`
Move to the right cell	`Tab`	`Tab`
Move to the left cell	`Shift + Tab`	`Shift + Tab`
Display the AutoComplete list	`Alt + ↓`	`⌥ + ↓`
Fill down in the column with the selected cells	`Ctrl + D`	`⌘ + D`
Fill right in the row with the selected cells	`Ctrl + R`	`⌘ + R`
Insert the current date	`Ctrl + ;`	`⌘ + ;`
Insert the current time	`Ctrl + Shift + ;`	`⌘ + Shift + ;`
Start a new line within the same cell	`Alt + Enter`	`Option + Return`
Cancel the current cell entry	`Esc`	`Esc`

Drag (Mouse) Shortcuts

Description	Windows	Mac
Drag and copy the selected cells	`Ctrl + Drag`	`⌘ + Drag`
Drag and cut the selected cells	`Drag`	`Drag`
Duplicate worksheet	`Ctrl + Drag`	`⌘ + Drag`
Switch position of cells/rows/columns	`Shift + Drag`	`Shift + Drag`

Excel Cell Editing Shortcuts

Description	Windows	Mac
Edit the content of the active cell	`F2`	`Ctrl + U`
Start a new line within the same cell	`Alt + ENTER`	`Option + Return`
Select the cell to the right	`SHIFT + →`	`Shift + →`
Select the cell to the left	`SHIFT + ←`	`Shift + ←`
Navigate the cursor to the right	`Ctrl + →`	`Option + →`
Navigate the cursor to the left	`Ctrl + ←`	`Option + ←`
Select all cells to the right with values	`Ctrl + SHIFT + →`	`Option + Shift + →`
Select all cells to the left with values	`Ctrl + SHIFT + ←`	`Option + Shift + ←`
Delete the character to the left	`Backspace`	`Delete`
Delete the character to the right	`Delete`	`Delete`
Delete the word to the right of the cursor	`Ctrl + Delete`	`Fn + Option + Delete`
Cancel the current cell entry	`Esc`	`Esc`

Excel Formula-Related Shortcuts

Description	Windows	Mac
Insert Autosum formula	`Alt + =`	`⌘ + Shift + T`
Switch cell reference from absolute to relative in formula	`F4`	`⌘ + T`
Toggle the Visibility of the Formula Bar	`Ctrl + Shift + U`	`⌘ + Option + U`
Launch the function wizard or dialog box	`Shift + F3`	`Shift + Fn + F3`
Enter a formula as an array formula	`Ctrl + Shift + Enter`	`⌘ + Shift + Enter`
Evaluate part of the formula	`F9`	`Fn + F9`
Select the array containing the active cell	`Ctrl + /`	`⌘ + /`
Select All Cells Referenced by Formulas	`Ctrl + [`	`⌘ + [`
Highlight All Cells Referenced by the Formula in the Active cell	`Ctrl + ]`	`⌘ + ]`
Toggle value/formula display	Ctrl + `	⌘ + `
Recheck dependent formulas and calculate all cells in all open workbooks	`Ctrl + Alt + Shift + F9`	`⌘ + Option + Shift + F9`

Extending the Selection Shortcuts

Description	Windows	Mac
Extend selection to the right by one cell	`Shift + →`	`Shift + →`
Extend selection to the left by one cell	`Shift + ←`	`Shift + ←`
Extend selection upwards by one cell	`Shift + ↑`	`Shift + ↑`
Extend selection downwards by one cell	`Shift + ↓`	`Shift + ↓`
Extend selection to the right till the last cell	`Ctrl + Shift + →`	`⌘ + Shift + →`
Extend selection to the left till the last cell	`Ctrl + Shift + ←`	`⌘ + Shift + ←`
Extend selection upwards to the last cell	`Ctrl + Shift + ↑`	`⌘ + Shift + ↑`
Extend selection to the above by one screen	`Shift + PageUp`	`Shift + Fn + ↑`
Extend selection to the below by one screen	`Shift + PageDown`	`Shift + Fn + ↓`
Extend selection to the right by one screen	`Alt + Shift + PageUp`	`Option + Shift + Fn + →`
Extend selection to the left by one screen	`Alt + Shift + PageDown`	`Option + Shift + Fn + ←`
Extend selection to the start of the row	`Shift + Home`	`Shift + ⌘ + ←`
Extend selection to the first cell in the worksheet	`Ctrl + Shift + Home`	`⌘ + Shift + ↑ + ←`
Extend selection to the last cell in the worksheet	`Ctrl + Shift + End`	`⌘ + Shift + ↓ + →`
Toggle extend selection mode	`F8`	`F8`

Find and Replace Shortcuts

Description	Windows	Mac
Display Find Dialog box	`Ctrl + F`	`⌘ + F`
Display Replace Dialog box	`Ctrl + H`	`⌘ + H`
Find next match	`Shift + F4`	`Shift + ⌘ + G`
Find the previous match	`Ctrl + Shift + F4`	`⌘ + Shift + ⌘ + G`

Formatting Shortcuts

Description	Windows	Mac
Bold Text	`Ctrl + B`	`⌘ + B`
Italicize Text	`Ctrl + I`	`⌘ + I`
Add Outline Border Around Selected Cells	`Ctrl + Shift + 7`	`⌘ + Option + 0`
Remove Outline Border	`Ctrl + Shift + _`	`⌘ + Option + –`
Underline Text	`Ctrl + U`	`⌘ + U`
Apply Strikethrough to Text	`Ctrl + 5`	`⌘ + Shift + X`
Increase Text Indentation	`Alt, H, 6`	`⌘ + Option + Command + 6`
Decrease Text Indentation	`Alt, H, 5`	`⌘ + Option + Command + 5`
Increase Font Size by One Step	`Alt, H, F, G`	`⌘ + Option + Shift + >`
Decrease Font Size by One Step	`Alt, H, F, K`	`⌘ + Option + Shift + <`
Format Numbers with Two Decimal Places and Commas for Thousands	`Ctrl + Shift + !`	`⌘ + Shift + !`
Set Date Format with Day - Month and Year	`Ctrl + Shift + #`	`⌘ + Shift + #`
Apply Currency Format with Two Decimal Points	`Ctrl + Shift + $`	`⌘ + Shift + $`
Format as Percentage Without Decimal Points	`Ctrl + Shift + %`	`⌘ + Shift + %`
Format Time Displaying Hours - Minutes and AM/PM	`Ctrl + Shift + @`	`⌘ + Shift + @`
Apply General Number Formatting	`Ctrl + Shift + ~`	`⌘ + Shift + ~`
Use Scientific Notation for Numbers	`Ctrl + Shift + ^`	`⌘ + Shift + ^`
Open the Format Style Dialog Box	`Alt + ‘`	`⌘ + Option + ‘`
Open the Format Cells Dialog Box	`Ctrl + 1`	`⌘ + 1`
Open Font Formatting Options	`Shift + Ctrl + F`	`⌘ + Shift + F`

General Excel Shortcuts

Description	Windows	Mac
Open the Help window	`F1`	`⌘ + Shift + /`
Repeat the last action	`Ctrl + Y or F4`	`⌘ + Y`
Undo the last command or action	`Ctrl + Z`	`⌘ + Z`
Spelling Check	`F7`	`⌘ + Shift + ;`
Apply a data filter	`Ctrl + Shift + L`	`⌘ + Shift + L`
Activate filter dropdown (when the cell with filter is selected)	`Alt + ↓`	`⌥ + ↓`
Display the Go To dialog box	`Ctrl + G`	`Fn + F5`
Recalculate all open workbooks	`F9`	`⌘ + =`
Calculate the active worksheet	`Shift + F9`	`⌘ + Shift + =`
Open the Print menu	`Ctrl + P`	`⌘ + P`
Turn on End mode	`End`	`Fn + Right Arrow`

Hide/Unhide (Rows, Columns, Objects) Shortcuts

Description	Windows	Mac
Hide selected rows in selection	`Ctrl + 9`	`⌘ + Option + 9`
Hide selected columns in selection	`Ctrl + 0`	`⌘ + Option + 0`
Unhide hidden rows in selection	`Ctrl + Shift + 9`	`⌘ + Option + Shift + 9`
Unhide hidden columns in selection	`Ctrl + Shift + 0`	`⌘ + Option + Shift + 0`
Show/hide objects	`Ctrl + 6`	`⌘ + 6`

Insert Shortcuts

Description	Windows	Mac
Add a New Line Within the Same Cell	`Alt + Enter`	`Option + Return`
Insert a New Worksheet	`Shift + F11`	`Shift + Fn + F11`
Insert Row or Cell (Opens Dialog Box)	`Ctrl + Shift + =`	`⌘ + Shift + =`
Insert the Current Date	`Ctrl + ;`	`⌘ + ;`
Insert the Current Time	`Ctrl + Shift + ;`	`⌘ + Shift + ;`
Insert a Table	`Ctrl + T`	`⌘ + T`
Add a Hyperlink	`Ctrl + K`	`⌘ + K`
Insert Function Arguments into Formula	`Ctrl + Shift + A`	`⌘ + Shift + A`
Add/Edit a Cell Comment	`Shift + F2`	`Shift + Fn + F2`
Delete Row or Cell (Opens Dialog Box)	`Ctrl + –`	`⌘ + –`

Named Ranges Shortcuts

Description	Windows	Mac
Get a list of all defined named ranges	`F3`	`⌘ + F3`
Create named range from selection	`Ctrl + Shift + F3`	`⌘ + Shift + F3`
Define Name dialog box	`Ctrl + F3`	`⌘ + F3`

Navigation Shortcuts in Excel

Description	Windows	Mac
Move Up One Cell	`↑`	`↑`
Move Down One Cell	`↓`	`↓`
Move Right One Cell	`→`	`→`
Move Left One Cell	`←`	`←`
Scroll down one screen	`PageDown`	`Fn + ↓`
Scroll up one screen	`PageUp`	`Fn + ↑`
Move one screen to the right	`Alt + PageDown`	`Option + Fn + ↓`
Move one screen to the left	`Alt + PageUp`	`Option + Fn + ↑`
Go toward the Right of the Data	`Ctrl + →`	`⌘ + →`
Go towards the Left of the Data	`Ctrl + ←`	`⌘ + ←`
Go towards the Bottom of the Data	`Ctrl + ↓`	`⌘ + ↓`
Go towards the Top of the Data	`Ctrl + ↑`	`⌘ + ↑`
Move to the last used cell at bottom right	`Ctrl + End`	`⌘ + End`
Go to the First Cell in the Current Region	`Ctrl + Home`	`⌘ + ↑`
Move to the Beginning of the Row	`Home`	`⌘ + ←`
Switch to the Next Worksheet	`Ctrl + PageDown`	`⌘ + Fn + ↓`
Switch to the Previous Worksheet	`Ctrl + PageUp`	`⌘ + Fn + ↑`
Move to the next worksheet	`Ctrl + Tab`	`Ctrl + Tab`
Move to the previous worksheet	`Ctrl + Shift + Tab`	`Ctrl + Shift + Tab`

Pivot Table Shortcuts

Description	Windows	Mac
Create a Pivot Table	`Alt, N, V`	`⌘ + Option + P`
Create a PivotChart	`Alt, N, S, T`	`⌘ + Option + C`
Open the Pivot Table Field List	`Alt + H`	`⌘ + Option + F`
Refresh all Pivot Tables in the workbook	`Alt + F5`	`⌘ + R`
Expand all fields in the Pivot Table	`Alt + Shift + →`	`Option + Shift + →`
Collapse all fields in the Pivot Table	`Alt + Shift + ←`	`Option + Shift + ←`

Row and Column Shortcuts

Description	Windows	Mac
Select the entire row	`Shift + Space`	`Shift + Space`
Select the entire column	`Ctrl + Space`	`Ctrl + Space`
Insert an entire row	`Ctrl + Shift + +`	`⌘ + Shift + +`
Insert an entire column	`Ctrl + Shift + +`	`⌘ + Shift + +`
Delete the entire row	`Ctrl + –`	`⌘ + –`
Delete the entire column	`Ctrl + –`	`⌘ + –`

Selection Shortcuts

Description	Windows	Mac
Select the current region	`Ctrl + A`	`⌘ + A`
Select all the cells in the worksheet	`Ctrl + A (double click)`	`⌘ + A`
Select non-contiguous cells	`Ctrl + Mouse Click`	`⌘ + Mouse Click`
Select a range of cells	`Shift + Mouse Click`	`Shift + Mouse Click`
Add to the selection	`Shift + F8`	`Shift + F8`
Select a single cell from the selection	`Tab or Shift + Tab`	`Tab or Shift + Tab`
Find the Next Match	`Shift + F4`	`⌘ + Shift + G`
Find the Previous Match	`Ctrl + Shift + F4`	`⌘ + Shift + G`

Special Cells Shortcuts

Description	Windows	Mac
Select the current region around the active cell	`Ctrl + Shift + 8`	`⌘ + Shift + 8`
Highlight all cells with comments	`Ctrl + Shift + O`	`⌘ + Option + O`
Highlight all cells with formulas	Ctrl + `	Ctrl + `
Select visible cells only	`Alt + ;`	`⌘ + Option + Z`
Go To dialog box	`F5`	`Fn + F5`

VBA Editor and the Excel Worksheet

Description	Windows	Mac
Open the VBA editor	`Alt + F11`	`⌘ + Option + F11`

VBA Shortcuts

Description	Windows	Mac
Open VB Help	`F1`	`F1`
View Object Browser	`F2`	`F2`
View Properties	`F4`	`F4`
View Code window	`F7`	`F7`
View Immediate window	`Ctrl + G`	`⌘ + Option + G`
View Shortcut Menu	`Shift + F10`	`Shift + F10`
Run a Sub/UserForm	`F5`	`F5`
Step Into the code	`F8`	`F8`
Step Over	`Shift + F8`	`Shift + F8`
Step Out	`Ctrl + Shift + F8`	`⌘ + Shift + F8`
Run to Cursor	`Ctrl + F8`	`⌘ + F8`
Toggle Breakpoint	`F9`	`F9`
Clear All Breakpoints	`Ctrl + F9`	`⌘ + Option + F9`
Close VBA Editor and return to the Excel Worksheet	`Alt + Q`	`⌘ + Q`

Workbook Related Shortcuts

Description	Windows	Mac
Create a new blank workbook	`Ctrl + N`	`⌘ + N`
Open the dialog box to find a file	`Ctrl + O`	`⌘ + O`
Save the active workbook	`Ctrl + S`	`⌘ + S`
Save As dialog box	`F12`	`⌘ + Shift + S`
Display the Print Preview window	`Ctrl + F2`	`⌘ + P`
Maximize or restore the workbook window	`Ctrl + F10`	`⌃ + F10`
Close the active workbook	`Ctrl + W or Ctrl + F4`	`⌘ + W or ⌘ + F4`
Create a new blank worksheet	`Shift + F11`	`Fn + Shift + F11`
Go to the next worksheet	`Ctrl + PageDown`	`⌘ + Tab`
Go to the previous worksheet	`Ctrl + PageUp`	`⌘ + Shift + Tab`

Worksheet Tab Shortcuts

Description	Windows	Mac
Select multiple worksheets	`Ctrl + Click`	`⌘ + Click`
Add a new worksheet	`Shift + F11`	`Shift + F11`
Move to the next worksheet	`Ctrl + PageDown`	`⌘ + PageDown`
Move to the previous worksheet	`Ctrl + PageUp`	`⌘ + PageUp`
Copy a worksheet	`Ctrl + Drag Sheet`	`Option + Drag Sheet`
Delete a worksheet	`Alt + E, L`	`Option + Delete`
Rename the active worksheet	`Alt + O, R`	`Ctrl + Click, then select "Rename"`

Worksheet Window Shortcuts

Description	Windows	Mac
Split the window	`Alt + W, S`	`⌘ + Option + S`
Remove the split	`Alt + W, S`	`⌘ + Option + S`
Arrange all open workbooks	`Alt + W, A`	`⌘ + Option + A`
Create a new window for the active workbook	`Alt + W, N`	`⌘ + N`

Worksheet Zoom Shortcuts

Description	Windows	Mac
Zoom in	`Ctrl + Mouse Wheel Up`	`⌘ + +`
Zoom out	`Ctrl + Mouse Wheel Down`	`⌘ + -`
Zoom to 100%	`Ctrl + 0`	`⌘ + 0`
Open Zoom dialog box	`Alt + V, Z`	`⌘ + Option + Z`

💡 Pro Tips

Practice Daily

Use shortcuts regularly to build muscle memory

Bookmark This Page

Keep this reference handy for quick lookup

Print for Reference

Print specific categories for desk reference

Start with Basics

Master common shortcuts before advanced ones