200+ Excel Keyboard Shortcuts (Windows & Mac)

Here’s a complete list of 200+ Excel keyboard shortcuts for both Windows and Mac.

Whether you’re on a PC or a MacBook, learning even a handful of these shortcuts can save you hours every week.

You don’t need to memorize all of them. Just start with the ones you’d use daily, and build from there.

These shortcuts work in Excel 365, Excel 2024, 2021, 2019, and most earlier versions.

Use these buttons to filter the shortcuts

📁

Workbook Shortcuts

12 shortcuts

Action	⊞ Windows	⌘ Mac
Create a New Blank Workbook	`Ctrl` + `N`	`⌘` + `N`
Open a Workbook	`Ctrl` + `O`	`⌘` + `O`
Save the Current Workbook	`Ctrl` + `S`	`⌘` + `S`
Open the Save As Dialog Box	`F12`	`⌘` + `Shift` + `S`
Open the Print Preview Window	`Ctrl` + `F2`	`⌘` + `P`
Print the Workbook	`Ctrl` + `P`	`⌘` + `P`
Close the Current Workbook	`Ctrl` + `W`	`⌘` + `W`
Close Excel	`Alt` + `F4`	`⌘` + `Q`
Switch to the Next Workbook	`Ctrl` + `Tab`	`⌘` + `~`
Switch to the Previous Workbook	`Ctrl` + `Shift` + `Tab`	`⌘` + `Shift` + `~`
Maximize or Restore Workbook Window	`Ctrl` + `F10`	Not available
Minimize Workbook Window	`Ctrl` + `F9`	`⌘` + `M`

🧭

Navigation Shortcuts

16 shortcuts

Action	⊞ Windows	⌘ Mac
Move One Cell Up	`↑`	`↑`
Move One Cell Down	`↓`	`↓`
Move One Cell to the Right	`→`	`→`
Move One Cell to the Left	`←`	`←`
Move to the Edge of the Data Region	`Ctrl` + `Arrow Key`	`⌘` + `Arrow Key`
Move to the Beginning of the Row	`Home`	`Fn` + `←`
Move to the First Cell (A1) in the Worksheet	`Ctrl` + `Home`	`Ctrl` + `Fn` + `←`
Move to the Last Used Cell in the Worksheet	`Ctrl` + `End`	`Ctrl` + `Fn` + `→`
Scroll Down One Screen	`Page Down`	`Fn` + `↓`
Scroll Up One Screen	`Page Up`	`Fn` + `↑`
Move One Screen to the Right	`Alt` + `Page Down`	`Fn` + `Option` + `↓`
Move One Screen to the Left	`Alt` + `Page Up`	`Fn` + `Option` + `↑`
Move to the Next Worksheet Tab	`Ctrl` + `Page Down`	`Ctrl` + `Fn` + `↓`
Move to the Previous Worksheet Tab	`Ctrl` + `Page Up`	`Ctrl` + `Fn` + `↑`
Open the Go To Dialog Box	`Ctrl` + `G`	`Ctrl` + `G`
Open the Go To Dialog Box (Alt)	`F5`	`F5`

✏️

Cell Editing Shortcuts

16 shortcuts

Action	⊞ Windows	⌘ Mac
Edit the Active Cell	`F2`	`F2`
Confirm Cell Entry and Move Down	`Enter`	`Return`
Confirm Cell Entry and Stay in Same Cell	`Ctrl` + `Enter`	`Ctrl` + `Return`
Start a New Line in the Same Cell	`Alt` + `Enter`	`Option` + `Return`
Cancel Cell Entry	`Esc`	`Esc`
Delete Character to the Left of Cursor	`Backspace`	`Delete`
Delete Character to the Right of Cursor	`Delete`	`Fn` + `Delete`
Delete Text to the End of the Line	`Ctrl` + `Delete`	`Ctrl` + `Fn` + `Delete`
Move Cursor One Word to the Right	`Ctrl` + `→`	`Option` + `→`
Move Cursor One Word to the Left	`Ctrl` + `←`	`Option` + `←`
Select One Character to the Right	`Shift` + `→`	`Shift` + `→`
Select One Character to the Left	`Shift` + `←`	`Shift` + `←`
Select One Word to the Right	`Ctrl` + `Shift` + `→`	`Option` + `Shift` + `→`
Select One Word to the Left	`Ctrl` + `Shift` + `←`	`Option` + `Shift` + `←`
Undo the Last Action	`Ctrl` + `Z`	`⌘` + `Z`
Redo / Repeat the Last Action	`Ctrl` + `Y`	`⌘` + `Y`

⌨️

Data Entry Shortcuts

12 shortcuts

Action	⊞ Windows	⌘ Mac
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`
Enter Same Data in All Selected Cells	`Ctrl` + `Enter`	`Ctrl` + `Return`
Insert the Current Date	`Ctrl` + `;`	`Ctrl` + `;`
Insert the Current Time	`Ctrl` + `Shift` + `;`	`⌘` + `;`
Fill Down from the Cell Above	`Ctrl` + `D`	`Ctrl` + `D`
Fill Right from the Cell to the Left	`Ctrl` + `R`	`Ctrl` + `R`
Display the AutoComplete List	`Alt` + `↓`	`Option` + `↓`
Insert a Hyperlink	`Ctrl` + `K`	`⌘` + `K`
Open the Flash Fill Feature	`Ctrl` + `E`	`Ctrl` + `E`

🔲

Selection Shortcuts

12 shortcuts

Action	⊞ Windows	⌘ Mac
Select All Cells / Current Region	`Ctrl` + `A`	`⌘` + `A`
Select the Entire Row	`Shift` + `Space`	`Shift` + `Space`
Select the Entire Column	`Ctrl` + `Space`	`Ctrl` + `Space`
Select the Current Region Around Active Cell	`Ctrl` + `Shift` + `*`	`Ctrl` + `Shift` + `*`
Select Only Visible Cells in Selection	`Alt` + `;`	`⌘` + `Shift` + `Z`
Select All Cells with Comments	`Ctrl` + `Shift` + `O`	Not available
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` + `}`

↔️

Extend Selection Shortcuts

9 shortcuts

Action	⊞ Windows	⌘ Mac
Extend Selection by One Cell (Any Direction)	`Shift` + `Arrow Key`	`Shift` + `Arrow Key`
Extend Selection to the Last Non-Empty Cell	`Ctrl` + `Shift` + `Arrow Key`	`⌘` + `Shift` + `Arrow Key`
Extend Selection Up One Screen	`Shift` + `Page Up`	`Shift` + `Fn` + `↑`
Extend Selection Down One Screen	`Shift` + `Page Down`	`Shift` + `Fn` + `↓`
Extend Selection to the Start of the Row	`Shift` + `Home`	`Shift` + `Fn` + `←`
Extend Selection to the First Cell (A1)	`Ctrl` + `Shift` + `Home`	`Ctrl` + `Shift` + `Fn` + `←`
Extend Selection to the Last Used Cell	`Ctrl` + `Shift` + `End`	`Ctrl` + `Shift` + `Fn` + `→`
Toggle Extend Selection Mode	`F8`	`F8`
Add to Selection Mode	`Shift` + `F8`	`Shift` + `F8`

📋

Cut, Copy and Paste Shortcuts

6 shortcuts

Action	⊞ Windows	⌘ Mac
Copy Selected Cells	`Ctrl` + `C`	`⌘` + `C`
Cut Selected Cells	`Ctrl` + `X`	`⌘` + `X`
Paste from Clipboard	`Ctrl` + `V`	`⌘` + `V`
Open the Paste Special Dialog Box	`Ctrl` + `Alt` + `V`	`⌘` + `Ctrl` + `V`
Copy Formula from the Cell Above	`Ctrl` + `'`	`Ctrl` + `'`
Copy Value from the Cell Above	`Ctrl` + `Shift` + `"`	`Ctrl` + `Shift` + `"`

🎨

Formatting Shortcuts

20 shortcuts

Action	⊞ Windows	⌘ Mac
Open the Format Cells Dialog Box	`Ctrl` + `1`	`⌘` + `1`
Apply or Remove Bold Formatting	`Ctrl` + `B`	`⌘` + `B`
Apply or Remove Italic Formatting	`Ctrl` + `I`	`⌘` + `I`
Apply or Remove Underline	`Ctrl` + `U`	`⌘` + `U`
Apply or Remove Strikethrough	`Ctrl` + `5`	`⌘` + `Shift` + `X`
Apply Outline Border to Selected Cells	`Ctrl` + `Shift` + `&`	`⌘` + `Option` + `0`
Remove Outline Border	`Ctrl` + `Shift` + `_`	`⌘` + `Option` + `-`
Apply the General Number Format	`Ctrl` + `Shift` + `~`	`Ctrl` + `Shift` + `~`
Apply Currency Format (2 Decimals)	`Ctrl` + `Shift` + `$`	`Ctrl` + `Shift` + `$`
Apply Percentage Format (No Decimals)	`Ctrl` + `Shift` + `%`	`Ctrl` + `Shift` + `%`
Apply Scientific/Exponential Format	`Ctrl` + `Shift` + `^`	`Ctrl` + `Shift` + `^`
Apply Date Format (Day, Month, Year)	`Ctrl` + `Shift` + `#`	`Ctrl` + `Shift` + `#`
Apply Time Format (Hour, Minute, AM/PM)	`Ctrl` + `Shift` + `@`	`Ctrl` + `Shift` + `@`
Apply Number Format (2 Decimals, Thousands Separator)	`Ctrl` + `Shift` + `!`	`Ctrl` + `Shift` + `!`
Increase Font Size by One Step	`Alt` + `H` then `F` then `G`	`⌘` + `Shift` + `>`
Decrease Font Size by One Step	`Alt` + `H` then `F` then `K`	`⌘` + `Shift` + `<`
Apply Indent	`Alt` + `H` then `6`	`Ctrl` + `Option` + `Tab`
Remove Indent	`Alt` + `H` then `5`	`Ctrl` + `Option` + `Shift` + `Tab`
Open the Font Dialog Box	`Ctrl` + `Shift` + `F`	`⌘` + `Shift` + `F`
Show or Hide Objects	`Ctrl` + `6`	`Ctrl` + `6`

↕️

Alignment Shortcuts

3 shortcuts

Action	⊞ Windows	⌘ Mac
Align Content to the Left	`Alt` + `H` then `A` then `L`	`⌘` + `L`
Center Content Horizontally	`Alt` + `H` then `A` then `C`	`⌘` + `E`
Align Content to the Right	`Alt` + `H` then `A` then `R`	`⌘` + `R`

🔢

Formula Shortcuts

13 shortcuts

Action	⊞ Windows	⌘ Mac
Insert an AutoSum Formula	`Alt` + `=`	`⌘` + `Shift` + `T`
Toggle Between Absolute and Relative Cell References	`F4`	`⌘` + `T`
Open the Insert Function Dialog Box	`Shift` + `F3`	`Shift` + `F3`
Enter a Formula as an Array Formula	`Ctrl` + `Shift` + `Enter`	`⌘` + `Shift` + `Return`
Expand or Collapse the Formula Bar	`Ctrl` + `Shift` + `U`	`Ctrl` + `Shift` + `U`
Toggle Between Displaying Formulas and Values	`Ctrl` + `	`Ctrl` + `
Evaluate Part of a Formula (in edit mode)	`F9`	`F9`
Recalculate All Open Workbooks	`F9`	`F9`
Calculate the Active Worksheet Only	`Shift` + `F9`	`Shift` + `F9`
Force Recalculate All Workbooks	`Ctrl` + `Alt` + `F9`	Not available
Recheck Dependent Formulas Then Calculate All	`Ctrl` + `Alt` + `Shift` + `F9`	Not available
Insert Argument Names into a Formula	`Ctrl` + `Shift` + `A`	`Ctrl` + `Shift` + `A`
Select the Array Containing the Active Cell	`Ctrl` + `/`	`Ctrl` + `/`

🔍

Find and Replace Shortcuts

5 shortcuts

Action	⊞ Windows	⌘ Mac
Open the Find Dialog Box	`Ctrl` + `F`	`⌘` + `F`
Open the Replace Dialog Box	`Ctrl` + `H`	`⌘` + `H`
Find the Next Match	`Shift` + `F4`	`⌘` + `G`
Find the Previous Match	`Ctrl` + `Shift` + `F4`	`⌘` + `Shift` + `G`
Spell Check	`F7`	`F7`

➕

Insert and Delete Shortcuts

6 shortcuts

Action	⊞ Windows	⌘ Mac
Insert Cells / Rows / Columns (Dialog Box)	`Ctrl` + `Shift` + `=`	`Ctrl` + `Shift` + `=`
Delete Cells / Rows / Columns (Dialog Box)	`Ctrl` + `-`	`Ctrl` + `-`
Insert a New Worksheet	`Shift` + `F11`	`Shift` + `F11`
Insert / Edit a Cell Comment or Note	`Shift` + `F2`	`Shift` + `F2`
Insert a Threaded Comment	`Ctrl` + `Shift` + `F2`	Not available
Create a Table from Selection	`Ctrl` + `T`	`⌘` + `T`

👁️

Hide and Unhide Shortcuts

4 shortcuts

Action	⊞ Windows	⌘ Mac
Hide Selected Rows	`Ctrl` + `9`	`⌘` + `9`
Unhide Rows in Selection	`Ctrl` + `Shift` + `9`	`⌘` + `Shift` + `9`
Hide Selected Columns	`Ctrl` + `0`	`⌘` + `0`
Unhide Columns in Selection	`Ctrl` + `Shift` + `0`	`⌘` + `Shift` + `0`

🧹

Clear Shortcuts

5 shortcuts

Action	⊞ Windows	⌘ Mac
Clear Everything (Content and Format)	`Alt` + `H` then `E` then `A`	Not available
Clear Formatting Only	`Alt` + `H` then `E` then `F`	Not available
Clear Cell Contents Only	`Alt` + `H` then `E` then `C`	Not available
Clear Hyperlinks Only	`Alt` + `H` then `E` then `L`	Not available
Clear Comments Only	`Alt` + `H` then `E` then `M`	Not available

📊

Charting Shortcuts

2 shortcuts

Action	⊞ Windows	⌘ Mac
Insert a Chart in the Current Worksheet	`Alt` + `F1`	Not available
Insert a Chart on a New Chart Sheet	`F11`	`F11`

🔽

Data Filters and Sorting Shortcuts

3 shortcuts

Action	⊞ Windows	⌘ Mac
Toggle AutoFilter On/Off	`Ctrl` + `Shift` + `L`	`⌘` + `Shift` + `L`
Open Filter Drop-Down on Selected Cell	`Alt` + `↓`	`Option` + `↓`
Display the Data Validation Dialog	`Alt` + `D` then `L`	Not available

🌈

Conditional Formatting Shortcuts

3 shortcuts

Action	⊞ Windows	⌘ Mac
Open Conditional Formatting Rules Manager	`Alt` + `O` then `D`	Not available
Clear Conditional Formatting from Selected Cells	`Alt` + `H` then `L` then `C` then `S`	Not available
Clear Conditional Formatting from Entire Sheet	`Alt` + `H` then `L` then `C` then `E`	Not available

📐

Pivot Table Shortcuts

6 shortcuts

Action	⊞ Windows	⌘ Mac
Open the Insert Pivot Table Dialog Box	`Alt` + `N` then `V`	Not available
Select the Entire Pivot Table	`Ctrl` + `A`	`⌘` + `A`
Group Selected Pivot Table Items	`Alt` + `Shift` + `→`	`⌘` + `Shift` + `K`
Ungroup Selected Pivot Table Items	`Alt` + `Shift` + `←`	`⌘` + `Shift` + `J`
Hide the Selected Pivot Table Item	`Ctrl` + `-`	`Ctrl` + `-`
Open the Field List for the Active Cell	`Alt` + `↓`	`Option` + `↓`

🖱️

Drag (Mouse) Shortcuts

4 shortcuts

Action	⊞ Windows	⌘ Mac
Drag and Move Selected Cells	`Drag`	`Drag`
Drag and Copy Selected Cells	`Ctrl` + `Drag`	`Option` + `Drag`
Duplicate the Current Worksheet Tab	`Ctrl` + `Drag Tab`	`Option` + `Drag Tab`
Switch Position of Cells/Rows/Columns	`Shift` + `Drag`	`Shift` + `Drag`

🏷️

Named Ranges Shortcuts

3 shortcuts

Action	⊞ Windows	⌘ Mac
Paste a Defined Name into a Formula	`F3`	`F3`
Open the Name Manager	`Ctrl` + `F3`	Not available
Create Names from Row and Column Labels	`Ctrl` + `Shift` + `F3`	Not available

📌

Paste Special Shortcuts

7 shortcuts

Action	⊞ Windows	⌘ Mac
Paste Values Only	`Ctrl` + `Alt` + `V` then `V`	`⌘` + `Ctrl` + `V` then `V`
Paste Formulas Only	`Ctrl` + `Alt` + `V` then `F`	`⌘` + `Ctrl` + `V` then `F`
Paste Formatting Only	`Ctrl` + `Alt` + `V` then `T`	`⌘` + `Ctrl` + `V` then `T`
Paste Column Widths	`Ctrl` + `Alt` + `V` then `W`	`⌘` + `Ctrl` + `V` then `W`
Paste Comments Only	`Ctrl` + `Alt` + `V` then `C`	`⌘` + `Ctrl` + `V` then `C`
Paste All Except Borders	`Ctrl` + `Alt` + `V` then `X`	`⌘` + `Ctrl` + `V` then `X`
Paste with Transpose	`Ctrl` + `Alt` + `V` then `E`	`⌘` + `Ctrl` + `V` then `E`

🧩

Ribbon Navigation Shortcuts

10 shortcuts

Action	⊞ Windows	⌘ Mac
Activate Access Keys / KeyTips	`Alt`	`Option` (tap and release)
Go to the Home Tab	`Alt` + `H`	Not available
Go to the Insert Tab	`Alt` + `N`	Not available
Go to the Page Layout Tab	`Alt` + `P`	Not available
Go to the Formulas Tab	`Alt` + `M`	Not available
Go to the Data Tab	`Alt` + `A`	Not available
Go to the Review Tab	`Alt` + `R`	Not available
Go to the View Tab	`Alt` + `W`	Not available
Open the File Menu	`Alt` + `F`	Not available
Move to the Search / Tell Me Field	`Alt` + `Q`	`⌘` + `F6`

⚙️

General Shortcuts

11 shortcuts

Action	⊞ Windows	⌘ Mac
Open Help	`F1`	`F1`
Repeat the Last Action	`F4`	`⌘` + `Y`
Open the Context (Right-Click) Menu	`Shift` + `F10`	`Shift` + `F10`
Turn On End Mode	`End`	`Fn` + `→`
Open the Quick Analysis Tool	`Ctrl` + `Q`	Not available
Expand or Collapse the Ribbon	`Ctrl` + `F1`	`⌘` + `Option` + `R`
Open the Macro Dialog Box	`Alt` + `F8`	`Option` + `F8`
Open the Power Query Editor	`Alt` + `F12`	Not available
Display or Hide Outline Symbols	`Ctrl` + `8`	`Ctrl` + `8`
Zoom In	`Ctrl` + `Alt` + `=`	Not available
Zoom Out	`Ctrl` + `Alt` + `-`	Not available

🪟

Window Management Shortcuts

5 shortcuts

Action	⊞ Windows	⌘ Mac
Switch to the Next Window/Pane	`F6`	`F6`
Switch to the Previous Pane	`Shift` + `F6`	`Shift` + `F6`
Restore the Window Size	`Ctrl` + `F5`	Not available
Move the Window (Keyboard Mode)	`Ctrl` + `F7`	Not available
Resize the Window (Keyboard Mode)	`Ctrl` + `F8`	Not available

💻

VBA Shortcuts

13 shortcuts

Action	⊞ Windows	⌘ Mac
Open the VBA Editor	`Alt` + `F11`	`Option` + `F11`
Open VBA Help	`F1` (in VBE)	`F1` (in VBE)
View the Object Browser	`F2` (in VBE)	Not available
View the Properties Window	`F4` (in VBE)	Not available
View the Code Window	`F7` (in VBE)	Not available
Open the Immediate Window	`Ctrl` + `G` (in VBE)	Not available
Run a Sub / UserForm	`F5` (in VBE)	`F5` (in VBE)
Step Into the Code	`F8` (in VBE)	`F8` (in VBE)
Step Over	`Shift` + `F8` (in VBE)	`Shift` + `F8` (in VBE)
Step Out	`Ctrl` + `Shift` + `F8` (in VBE)	Not available
Toggle a Breakpoint	`F9` (in VBE)	`F9` (in VBE)
Clear All Breakpoints	`Ctrl` + `Shift` + `F9` (in VBE)	Not available
Close VBA Editor and Return to Excel	`Alt` + `Q`	Not available

Some Excel Shortcuts Related Questions You May Have

Do Excel keyboard shortcuts work the same on Mac and Windows?
Most Windows Excel shortcuts have a Mac equivalent, but the keys are different. On Mac, you use ⌘ (Command) instead of Ctrl, and Option instead of Alt.

What is the Mac equivalent of the Ctrl key in Excel?
It's the ⌘ (Command) key. So Ctrl + C on Windows becomes ⌘ + C on Mac.

Are there Excel shortcuts that only work on Windows?
Yes. The Alt key shortcuts for ribbon navigation are Windows-only. There's no direct Mac equivalent for those. I've marked these as "Not available" in the list above.

What is the fastest way to learn Excel keyboard shortcuts?
Pick 5-10 that you'd actually use every day. Ctrl + C, Ctrl + V, Ctrl + Z, and Ctrl + Shift + L are good ones to start with. Use them until they're automatic, then add more.

Do Excel keyboard shortcuts work in Google Sheets?
The basic ones like Ctrl + C, Ctrl + V, and Ctrl + Z work in both. But the Alt key sequences for ribbon navigation are Excel-only and won't work in Google Sheets.

Can I create custom keyboard shortcuts in Excel?
Not directly. There's no built-in option for it. But there's a workaround. You can record a macro, then assign a Ctrl-based shortcut to it using the Macro Dialog Box (Alt + F8 on Windows, Option + F8 on Mac)

Useful Excel Resources:

200+ Excel Keyboard Shortcuts (Windows & Mac)

Workbook Shortcuts

Navigation Shortcuts

Cell Editing Shortcuts

Data Entry Shortcuts

Selection Shortcuts

Extend Selection Shortcuts

Cut, Copy and Paste Shortcuts

Formatting Shortcuts

Alignment Shortcuts

Formula Shortcuts

Find and Replace Shortcuts

Insert and Delete Shortcuts

Hide and Unhide Shortcuts

Clear Shortcuts

Charting Shortcuts

Data Filters and Sorting Shortcuts

Conditional Formatting Shortcuts

Pivot Table Shortcuts

Drag (Mouse) Shortcuts

Named Ranges Shortcuts

Paste Special Shortcuts

Ribbon Navigation Shortcuts

General Shortcuts

Window Management Shortcuts

VBA Shortcuts

Some Excel Shortcuts Related Questions You May Have

1 thought on “200+ Excel Keyboard Shortcuts (Windows & Mac)”

Leave a Comment Cancel reply