Excel Keyboard Shortcuts Cheat Sheet

The complete reference for Microsoft Excel hotkeys on Windows and Mac. Updated February 2026.

1. Essential Shortcuts

Action	Windows	Mac
Copy	`Ctrl` + `C`	`Cmd` + `C`
Cut	`Ctrl` + `X`	`Cmd` + `X`
Paste	`Ctrl` + `V`	`Cmd` + `V`
Undo	`Ctrl` + `Z`	`Cmd` + `Z`
Redo	`Ctrl` + `Y`	`Cmd` + `Y`
Save	`Ctrl` + `S`	`Cmd` + `S`
Print	`Ctrl` + `P`	`Cmd` + `P`
Find	`Ctrl` + `F`	`Cmd` + `F`
Replace	`Ctrl` + `H`	`Ctrl` + `H`
Select All	`Ctrl` + `A`	`Cmd` + `A`
Bold	`Ctrl` + `B`	`Cmd` + `B`
Italic	`Ctrl` + `I`	`Cmd` + `I`
Underline	`Ctrl` + `U`	`Cmd` + `U`
New Workbook	`Ctrl` + `N`	`Cmd` + `N`
Open Workbook	`Ctrl` + `O`	`Cmd` + `O`

2. Navigation

Action	Windows	Mac
Move one cell up/down/left/right	`Arrow Keys`	`Arrow Keys`
Move to edge of data region	`Ctrl` + `Arrow`	`Cmd` + `Arrow`
Move to beginning of row	`Home`	`Fn` + `Left`
Move to cell A1	`Ctrl` + `Home`	`Ctrl` + `Fn` + `Left`
Move to last used cell	`Ctrl` + `End`	`Ctrl` + `Fn` + `Right`
Move one screen down	`Page Down`	`Fn` + `Down`
Move one screen up	`Page Up`	`Fn` + `Up`
Move one screen right	`Alt` + `Page Down`	`Fn` + `Option` + `Down`
Move one screen left	`Alt` + `Page Up`	`Fn` + `Option` + `Up`
Go to a specific cell	`Ctrl` + `G`	`Ctrl` + `G`
Switch to next worksheet	`Ctrl` + `Page Down`	`Ctrl` + `Page Down`
Switch to previous worksheet	`Ctrl` + `Page Up`	`Ctrl` + `Page Up`
Move between unlocked cells	`Tab`	`Tab`
Move to previous cell	`Shift` + `Tab`	`Shift` + `Tab`
Scroll to active cell	`Ctrl` + `Backspace`	`Ctrl` + `Delete`
Move to next pane	`F6`	`F6`
Toggle End mode	`End`	—
Enter data and move down	`Enter`	`Return`

3. Selection

Action	Windows	Mac
Extend selection one cell	`Shift` + `Arrow`	`Shift` + `Arrow`
Extend selection to edge of data	`Ctrl` + `Shift` + `Arrow`	`Cmd` + `Shift` + `Arrow`
Select entire row	`Shift` + `Space`	`Shift` + `Space`
Select entire column	`Ctrl` + `Space`	`Ctrl` + `Space`
Select entire worksheet	`Ctrl` + `A`	`Cmd` + `A`
Select to beginning of row	`Shift` + `Home`	`Shift` + `Fn` + `Left`
Select to cell A1	`Ctrl` + `Shift` + `Home`	`Ctrl` + `Shift` + `Fn` + `Left`
Select to last used cell	`Ctrl` + `Shift` + `End`	`Ctrl` + `Shift` + `Fn` + `Right`
Extend selection one screen down	`Shift` + `Page Down`	`Shift` + `Fn` + `Down`
Extend selection one screen up	`Shift` + `Page Up`	`Shift` + `Fn` + `Up`
Select cells with comments	`Ctrl` + `Shift` + `O`	`Ctrl` + `Shift` + `O`
Select current region	`Ctrl` + `Shift` + `*`	`Ctrl` + `Shift` + `*`
Select current array	`Ctrl` + `/`	`Ctrl` + `/`
Select row differences	`Ctrl` + `\`	`Ctrl` + `\`
Select column differences	`Ctrl` + `Shift` + `\`	`Ctrl` + `Shift` + `\`
Select dependent cells	`Ctrl` + `]`	`Ctrl` + `]`
Select all dependent cells	`Ctrl` + `Shift` + `]`	`Ctrl` + `Shift` + `]`
Select precedent cells	`Ctrl` + `[`	`Ctrl` + `[`

4. Editing and Data Entry

Action	Windows	Mac
Edit active cell	`F2`	`F2`
Cancel cell entry	`Esc`	`Esc`
Delete character to the right	`Delete`	`Fn` + `Delete`
Delete character to the left	`Backspace`	`Delete`
Delete to end of line	`Ctrl` + `Delete`	`Ctrl` + `Fn` + `Delete`
Enter current date	`Ctrl` + `;`	`Ctrl` + `;`
Enter current time	`Ctrl` + `Shift` + `;`	`Cmd` + `;`
Fill down	`Ctrl` + `D`	`Cmd` + `D`
Fill right	`Ctrl` + `R`	`Cmd` + `R`
Insert line break in cell	`Alt` + `Enter`	`Option` + `Return`
Enter same data in multiple cells	`Ctrl` + `Enter`	`Ctrl` + `Return`
Complete cell entry and move down	`Enter`	`Return`
Complete cell entry and move up	`Shift` + `Enter`	`Shift` + `Return`
Complete entry and move right	`Tab`	`Tab`
Complete entry and move left	`Shift` + `Tab`	`Shift` + `Tab`
Define a name	`Ctrl` + `F3`	`Cmd` + `F3`
Insert hyperlink	`Ctrl` + `K`	`Cmd` + `K`
Check spelling	`F7`	`F7`

5. Clipboard Operations

Action	Windows	Mac
Copy	`Ctrl` + `C`	`Cmd` + `C`
Cut	`Ctrl` + `X`	`Cmd` + `X`
Paste	`Ctrl` + `V`	`Cmd` + `V`
Paste Special	`Ctrl` + `Alt` + `V`	`Cmd` + `Option` + `V`
Copy value from cell above	`Ctrl` + `Shift` + `"`	`Ctrl` + `Shift` + `"`
Copy formula from cell above	`Ctrl` + `'`	`Ctrl` + `'`

6. Formatting (Text)

Action	Windows	Mac
Bold	`Ctrl` + `B`	`Cmd` + `B`
Italic	`Ctrl` + `I`	`Cmd` + `I`
Underline	`Ctrl` + `U`	`Cmd` + `U`
Strikethrough	`Ctrl` + `5`	`Cmd` + `Shift` + `X`
Format Cells dialog	`Ctrl` + `1`	`Cmd` + `1`
Apply outline border	`Ctrl` + `Shift` + `&`	`Cmd` + `Option` + `0`
Remove all borders	`Ctrl` + `Shift` + `_`	`Cmd` + `Option` + `_`
Increase font size	`Alt` + `H`, `F`, `G`	`Cmd` + `Shift` + `>`
Decrease font size	`Alt` + `H`, `F`, `K`	`Cmd` + `Shift` + `<`
Indent	`Alt` + `H`, `6`	`Ctrl` + `Option` + `Tab`
Apply General format	`Ctrl` + `Shift` + `~`	`Ctrl` + `Shift` + `~`
Apply Currency format	`Ctrl` + `Shift` + `$`	`Ctrl` + `Shift` + `$`
Apply Percentage format	`Ctrl` + `Shift` + `%`	`Ctrl` + `Shift` + `%`

7. Number Formatting

Action	Windows	Mac
General format	`Ctrl` + `Shift` + `~`	`Ctrl` + `Shift` + `~`
Number format (2 decimals)	`Ctrl` + `Shift` + `!`	`Ctrl` + `Shift` + `!`
Currency format	`Ctrl` + `Shift` + `$`	`Ctrl` + `Shift` + `$`
Percentage format	`Ctrl` + `Shift` + `%`	`Ctrl` + `Shift` + `%`
Scientific format	`Ctrl` + `Shift` + `^`	`Ctrl` + `Shift` + `^`
Date format	`Ctrl` + `Shift` + `#`	`Ctrl` + `Shift` + `#`
Time format	`Ctrl` + `Shift` + `@`	`Ctrl` + `Shift` + `@`
Format Cells dialog	`Ctrl` + `1`	`Cmd` + `1`

8. Rows and Columns

Action	Windows	Mac
Insert cells/rows/columns	`Ctrl` + `Shift` + `+`	`Ctrl` + `Shift` + `+`
Delete cells/rows/columns	`Ctrl` + `-`	`Ctrl` + `-`
Hide selected rows	`Ctrl` + `9`	`Ctrl` + `9`
Unhide rows in selection	`Ctrl` + `Shift` + `9`	`Ctrl` + `Shift` + `9`
Hide selected columns	`Ctrl` + `0`	`Ctrl` + `0`
Unhide columns in selection	`Ctrl` + `Shift` + `0`	`Ctrl` + `Shift` + `0`
Group rows or columns	`Alt` + `Shift` + `Right`	`Cmd` + `Shift` + `K`
Ungroup rows or columns	`Alt` + `Shift` + `Left`	`Cmd` + `Shift` + `J`
Auto-fit column width	`Alt` + `H`, `O`, `I`	—
Auto-fit row height	`Alt` + `H`, `O`, `A`	—
Set column width	`Alt` + `H`, `O`, `W`	—
Set row height	`Alt` + `H`, `O`, `H`	—

9. Formulas and Functions

Action	Windows	Mac
Start a formula	`=`	`=`
Insert AutoSum	`Alt` + `=`	`Cmd` + `Shift` + `T`
Insert function	`Shift` + `F3`	`Shift` + `F3`
Toggle absolute/relative reference	`F4`	`Cmd` + `T`
Enter array formula	`Ctrl` + `Shift` + `Enter`	`Cmd` + `Shift` + `Return`
Calculate all worksheets	`F9`	`F9`
Calculate active worksheet	`Shift` + `F9`	`Shift` + `F9`
Force calculate all worksheets	`Ctrl` + `Alt` + `F9`	—
Show all formulas	`Ctrl` + `	`Ctrl` + `
Name Manager	`Ctrl` + `F3`	`Cmd` + `F3`
Define name from selection	`Ctrl` + `Shift` + `F3`	`Cmd` + `Shift` + `F3`
Paste name into formula	`F3`	`F3`
Accept AutoComplete suggestion	`Tab`	`Tab`
Evaluate part of formula	`F9` (in formula bar)	`F9` (in formula bar)
Toggle formula reference style	—	—
Trace precedents	`Alt` + `M`, `P`	—
Trace dependents	`Alt` + `M`, `D`	—
Remove all arrows	`Alt` + `M`, `A`, `A`	—

10. Find and Replace

Action	Windows	Mac
Find	`Ctrl` + `F`	`Cmd` + `F`
Find Next	`Shift` + `F4`	`Cmd` + `G`
Find Previous	`Ctrl` + `Shift` + `F4`	`Cmd` + `Shift` + `G`
Replace	`Ctrl` + `H`	`Ctrl` + `H`
Go To	`Ctrl` + `G`	`Ctrl` + `G`
Go To Special	`Ctrl` + `G` then Special	`Ctrl` + `G` then Special
Find and select comments	`Ctrl` + `Shift` + `O`	`Ctrl` + `Shift` + `O`
Close Find toolbar	`Esc`	`Esc`

11. Workbook and Worksheet Management

Action	Windows	Mac
New workbook	`Ctrl` + `N`	`Cmd` + `N`
Open workbook	`Ctrl` + `O`	`Cmd` + `O`
Save workbook	`Ctrl` + `S`	`Cmd` + `S`
Save As	`F12`	`Cmd` + `Shift` + `S`
Close workbook	`Ctrl` + `W`	`Cmd` + `W`
Close Excel	`Alt` + `F4`	`Cmd` + `Q`
Insert new worksheet	`Shift` + `F11`	`Shift` + `F11`
Move to next sheet	`Ctrl` + `Page Down`	`Ctrl` + `Page Down`
Move to previous sheet	`Ctrl` + `Page Up`	`Ctrl` + `Page Up`
Rename worksheet	`Alt` + `H`, `O`, `R`	—
Move or copy sheet	`Alt` + `H`, `O`, `M`	—
Delete worksheet	`Alt` + `H`, `D`, `S`	—
Switch between open workbooks	`Ctrl` + `Tab`	`Cmd` + `~`
Minimize workbook	`Ctrl` + `F9`	`Cmd` + `M`
Maximize workbook	`Ctrl` + `F10`	—
Toggle ribbon	`Ctrl` + `F1`	`Cmd` + `Option` + `R`

12. Printing and View

Action	Windows	Mac
Print	`Ctrl` + `P`	`Cmd` + `P`
Print Preview	`Ctrl` + `F2`	`Cmd` + `P`
Page Break Preview	`Alt` + `W`, `I`	—
Normal view	`Alt` + `W`, `L`	—
Zoom in	`Ctrl` + `Alt` + `=`	`Cmd` + `Option` + `=`
Zoom out	`Ctrl` + `Alt` + `-`	`Cmd` + `Option` + `-`
Toggle full screen	`Ctrl` + `Shift` + `F1`	`Ctrl` + `Cmd` + `F`
Freeze panes	`Alt` + `W`, `F`	—
Split window	`Alt` + `W`, `S`	—
Show/hide gridlines	`Alt` + `W`, `V`, `G`	—
Show/hide headings	`Alt` + `W`, `V`, `H`	—
New window	`Alt` + `W`, `N`	—

Process Excel Data Faster

NiceData uses AI to extract and organize data from any document. Upload spreadsheets, PDFs, and images to get clean, structured data in minutes.

Try NiceData Free

No credit card required