Excel keyboard shortcuts

Save time and boost productivity with these keyboard shortcuts for Windows and Mac.

Action	Windows	Mac
Active cell
Select active cell only	`Shift` + `Backspace`	`Shift` + `Delete`
Move screen to the active cell	`Ctrl` + `Backspace`	`Command` + `Delete`
Move active cell to the corner in the selection	`Ctrl` + `.`	`Control` + `.`
Move active cell down in selection	`Enter`	`Return`
Move active cell up in selection	`Shift` + `Enter`	`Shift` + `Return`
Move active cell right in a selection	`Tab`	`Tab`
Move active cell left in a selection	`Shift` + `Tab`	`Shift` + `Tab`
Borders
Add borders	`Ctrl` + `Shift` + `&`	`Command` + `Option` + `0`
Add or remove right border	`Alt` + `R`	`Command` + `Option` + `Right`
Add or remove left border	`Alt` + `L`	`Command` + `Option` + `Left`
Add or remove top border	`Alt` + `T`	`Command` + `Option` + `Up`
Add or remove bottom border	`Alt` + `B`	`Command` + `Option` + `Down`
Add or remove border upward diagonal	`Alt` + `D`	N/A
Add or remove border horizontal interior	`Alt` + `H`	N/A
Add or remove border vertical interior	`Alt` + `V`	N/A
Remove borders	`Ctrl` + `Shift` + `_`	`Command` + `Option` + `_`
Cell contents
Edit the active cell	`F2`	`Control` + `U`
Insert or edit comment	`Shift` + `F2`	`Function` + `Shift` + `F2`
Cancel editing cell	`Esc`	`Esc`
Select one character right of the cursor	`Shift` + `Right`	`Shift` + `Right`
Select one character left of the cursor	`Shift` + `Left`	`Shift` + `Left`
Move the cursor one word right	`Ctrl` + `Right`	`Control` + `Right`
Move the cursor one word left	`Ctrl` + `Left`	`Control` + `Left`
Select one word right of the cursor	`Ctrl` + `Shift` + `Right`	`Control` + `Shift` + `Right`
Select one word left of the cursor	`Ctrl` + `Shift` + `Left`	`Control` + `Shift` + `Left`
Select everything from the cursor up to the beginning of the cell	`Shift` + `Home`	`Function` + `Shift` + `Left`
Select everything from the cursor up to the end of the cell	`Shift` + `End`	`Function` + `Shift` + `Right`
Delete word to the right of the cursor	`Ctrl` + `Delete`	`Control` + `Delete`
Delete character to the left of cursor	`Backspace`	`Delete`
Delete character to the right of cursor	`Delete`	`Function` + `Delete`
Add a new line inside of a cell	`Alt` + `Enter`	`Control` + `Option` + `Return`
Data entry
Confirm entry and move down	`Enter`	`Return`
Confirm entry and move up	`Shift` + `Enter`	`Shift` + `Return`
Confirm entry and move right	`Tab`	`Tab`
Confirm entry and move left	`Shift` + `Tab`	`Shift` + `Tab`
Confirm entry and stay in the same cell	`Ctrl` + `Enter`	`Control` + `Return`
Enter the same data in multiple cells	`Ctrl` + `Enter`	`Control` + `Return`
Insert the current date	`Ctrl` + `;`	`Control` + `;`
Insert the current time	`Ctrl` + `Shift` + `:`	`Command` + `;`
Fill down from cell above the active cell	`Ctrl` + `D`	`Control` + `D`
Fill right from cell to the left of the active cell	`Ctrl` + `R`	`Control` + `R`
Copy the formula from the cell above the active cell	`Ctrl` + `'`	`Control` + `'`
Copy the value from the cell above the active cell	`Ctrl` + `Shift` + `"`	`Control` + `Shift` + `"`
Add a hyperlink	`Ctrl` + `K`	`Command` + `K`
Display the AutoComplete list	`Alt` + `Down`	`Option` + `Down`
Flash fill	`Ctrl` + `E`	N/A
Drag cells
Drag selection and move	`drag`	`drag`
Drag selection and copy	`Ctrl` + `drag`	`Option` + `drag`
Drag selection and insert	`Shift` + `drag`	`Shift` + `drag`
Drag selection and insert a copy	`Ctrl` + `Shift` + `drag`	`Option` + `Shift` + `drag`
Drag worksheet
Drag worksheet tab	`Alt` + `drag`	`Command` + `drag`
Drag worksheet tab and copy	`Ctrl` + `drag`	`Option` + `drag`
Extending the selection
Extend the selection by one cell right	`Shift` + `Right`	`Shift` + `Right`
Extend the selection by one cell left	`Shift` + `Left`	`Shift` + `Left`
Extend the selection by one cell up	`Shift` + `Up`	`Shift` + `Up`
Extend the selection by one cell down	`Shift` + `Down`	`Shift` + `Down`
Extend the selection to the last cell to the right	`Ctrl` + `Shift` + `Right`	`Control` + `Shift` + `Right`
Extend the selection to the last cell to the left	`Ctrl` + `Shift` + `Left`	`Control` + `Shift` + `Left`
Extend the selection to the last cell upwards	`Ctrl` + `Shift` + `Up`	`Control` + `Shift` + `Up`
Extend the selection to the last cell downwards	`Ctrl` + `Shift` + `Down`	`Control` + `Shift` + `Down`
Extend the selection up one screen	`Shift` + `PageUp`	`Function` + `Shift` + `Up`
Extend the selection down one screen	`Shift` + `PageDown`	`Function` + `Shift` + `Down`
Extend the selection right one screen	`Alt` + `Shift` + `PageDown`	`Function` + `Shift` + `Command` + `Down`
Extend the selection left one screen	`Alt` + `Shift` + `PageUp`	`Function` + `Shift` + `Command` + `Up`
Extend the selection to the start of the row	`Shift` + `Home`	`Function` + `Shift` + `Left`
Extend the selection to the first cell in the worksheet	`Ctrl` + `Shift` + `Home`	`Function` + `Control` + `Shift` + `Left`
Extend the selection to the last cell in the worksheet	`Ctrl` + `Shift` + `End`	`Function` + `Control` + `Shift` + `Right`
Enable or disable the Extend selection mode	`F8`	`Function` + `F8`
File
Create a new workbook	`Ctrl` + `N`	`Command` + `N`
Open a workbook	`Ctrl` + `O`	`Command` + `O`
Save the workbook	`Ctrl` + `S`	`Command` + `S`
Open save as window	`F12`	`Command` + `Shift` + `S`
Print file	`Ctrl` + `P`	`Command` + `P`
Open the print preview window	`Ctrl` + `F2`	N/A
Close the current workbook	`Ctrl` + `F4`	`Command` + `W`
Close Excel application	`Alt` + `F4`	`Command` + `Q`
Formatting
Open the Formatting window	`Ctrl` + `1`	`Command` + `1`
Open Formatting window on the Font tab	`Ctrl` + `Shift` + `F`	`Control` + `Shift` + `F`
Apply or remove bold formatting	`Ctrl` + `B`	`Command` + `B`
Apply or remove italic formatting	`Ctrl` + `I`	`Command` + `I`
Apply or remove underscore formatting	`Ctrl` + `U`	`Command` + `U`
Apply or remove strikethrough formatting	`Ctrl` + `5`	`Command` + `Shift` + `X`
Add or remove a shadow font style	N/A	`Command` + `Shift` + `W`
Add or remove an outline font style	N/A	`Command` + `Shift` + `D`
Align center	`Alt` + `H` + `A` + `C`	`Command` + `E`
Align left	`Alt` + `H` + `A` + `L`	`Command` + `L`
Align right	`Alt` + `H` + `A` + `R`	`Command` + `R`
Indent	`Alt` + `H` + `6`	`Control` + `Option` + `Tab`
Remove indent	`Alt` + `H` + `5`	`Control` + `Option` + `Shift` + `Tab`
Increase the font size by one step	`Alt` + `H` + `F` + `G`	`Command` + `Shift` + `>`
Decrease the font size by one step	`Alt` + `H` + `F` + `K`	`Command` + `Shift` + `<`
Formulas
Switch between absolute, relative and mixed references	`F4`	`Command` + `T`
Open the Insert Function window	`Shift` + `F3`	`Function` + `Shift` + `F3`
Autosum the selected cells	`Alt` + `=`	`Command` + `Shift` + `T`
Enable or disable formulas	`Ctrl` + `	`Control` + `
Insert function arguments	`Ctrl` + `Shift` + `A`	`Control` + `Shift` + `A`
Enter an Array formula	`Ctrl` + `Shift` + `Enter`	`Control` + `Shift` + `Return`
(Re)calculate all worksheets	`F9`	`Function` + `F9`
(Re)calculate the active worksheet	`Shift` + `F9`	`Function` + `Shift` + `F9`
Force (re)calculate all worksheets	`Ctrl` + `Alt` + `F9`	N/A
Evaluate a subset of a formula	`F9`	`Function` + `F9`
Expand or collapse the formula bar	`Ctrl` + `Shift` + `U`	`Control` + `Shift` + `U`
Display Function Arguments window	`Ctrl` + `A`	`Control` + `A`
Confirm autocomplete function	`Tab`	`Tab`
General
Open options	`Alt` + `F` + `T`	`Command` + `,`
Open the help window	`F1`	`Command` + `/`
Undo the last action	`Ctrl` + `Z`	`Command` + `Z`
Redo the last action	`Ctrl` + `Y`	`Command` + `Y`
Copy the contents of the selected cells	`Ctrl` + `C`	`Command` + `C`
Repeat the last action	`F4`	`Command` + `Y`
Cut the contents of the selected cells	`Ctrl` + `X`	`Command` + `X`
Paste the content of the clipboard	`Ctrl` + `V`	`Command` + `V`
Show the Paste Special window	`Ctrl` + `Alt` + `V`	`Control` + `Command` + `V`
Show the find window	`Ctrl` + `F`	`Command` + `F`
Show the find and replace window	`Ctrl` + `H`	`Control` + `H`
Find the next match	`Shift` + `F4`	`Command` + `G`
Find the previous match	`Ctrl` + `Shift` + `F4`	`Command` + `Shift` + `G`
Create an embedded chart	`Alt` + `F1`	`Function` + `Option` + `F1`
Create a chart on a new worksheet	`F11`	`Function` + `F11`
Grid operations
Show Insert window	`Ctrl` + `Shift` + `+`	`Command` + `Shift` + `+`
Insert row(s)	`Ctrl` + `Shift` + `+`	`Command` + `Shift` + `+`
Insert column(s)	`Ctrl` + `Shift` + `+`	`Command` + `Shift` + `+`
Show Delete (rows, columns or cells) window	`Ctrl` + `-`	`Command` + `-`
Delete row(s)	`Ctrl` + `-`	`Command` + `-`
Delete column(s)	`Ctrl` + `-`	`Command` + `-`
Delete cells	`Ctrl` + `-`	`Command` + `-`
Delete the contents of the selected cell(s)	`Delete`	`Function` + `Delete`
Hide selected column(s)	`Ctrl` + `0`	`Control` + `0`
Hide selected row(s)	`Ctrl` + `9`	`Control` + `9`
Unhide/show rows	`Ctrl` + `Shift` + `9`	`Control` + `Shift` + `9`
Unhide/show columns	`Ctrl` + `Shift` + `0`	`Control` + `Shift` + `0`
Group rows or columns	`Alt` + `Shift` + `Right`	`Command` + `Shift` + `K`
Ungroup rows or columns	`Alt` + `Shift` + `Left`	`Command` + `Shift` + `J`
Open Group window	`Alt` + `Shift` + `Right`	`Command` + `Shift` + `K`
Open Ungroup window	`Alt` + `Shift` + `Left`	`Command` + `Shift` + `J`
Hide or show outline/group view	`Ctrl` + `8`	`Control` + `8`
Zoom in	`Ctrl` + `Alt` + `+`	`Option` + `Command` + `+`
Zoom out	`Ctrl` + `Alt` + `-`	`Option` + `Command` + `-`
Naming
Open Name Manager window	`Ctrl` + `F3`	`Function` + `Control` + `F3`
Create names from row/column headings	`Ctrl` + `Shift` + `F3`	`Function` + `Control` + `Shift` + `F3`
Paste name into formula	`F3`	N/A
Navigation
Move one cell to the right	`Right`	`Right`
Move one cell to the left	`Left`	`Left`
Move one cell up	`Up`	`Up`
Move one cell down	`Down`	`Down`
Move one screen right	`Alt` + `PageDown`	`Function` + `Option` + `Down`
Move one screen left	`Alt` + `PageUp`	`Function` + `Option` + `Up`
Move one screen up	`PageUp`	`Function` + `Up`
Move one screen down	`PageDown`	`Function` + `Down`
Move to the right of the worksheet or table	`Ctrl` + `Right`	`Control` + `Right`
Move to the left of the worksheet or table	`Ctrl` + `Left`	`Control` + `Left`
Move to the top of the worksheet or table	`Ctrl` + `Up`	`Control` + `Up`
Move to the bottom of the worksheet or table	`Ctrl` + `Down`	`Control` + `Down`
Move to the first cell of the row	`Home`	`Function` + `Left`
Move to the last cell in the worksheet	`Ctrl` + `End`	`Function` + `Control` + `Right`
Move to the first cell in the worksheet	`Ctrl` + `Home`	`Function` + `Control` + `Left`
Turn on End Mode	`End`	`Function` + `Right`
Go back to hyperlink	`Ctrl` + `G` + `Enter`	`Control` + `G` + `Return`
Number formatting
Apply General number format	`Ctrl` + `Shift` + `~`	`Control` + `Shift` + `~`
Apply Currency number format	`Ctrl` + `Shift` + `$`	`Control` + `Shift` + `$`
Apply Percentage number format	`Ctrl` + `Shift` + `%`	`Control` + `Shift` + `%`
Apply Scientific number format	`Ctrl` + `Shift` + `^`	`Control` + `Shift` + `^`
Apply Date number format	`Ctrl` + `Shift` + `#`	`Control` + `Shift` + `#`
Apply Time number format	`Ctrl` + `Shift` + `@`	`Control` + `Shift` + `@`
Apply Number number format	`Ctrl` + `Shift` + `!`	`Control` + `Shift` + `!`
Pivot tables
Select the entire Pivot table	`Ctrl` + `A`	`Command` + `A`
Toggle Pivot table field checkbox	`Space`	`Space`
Group Pivot table items	`Alt` + `Shift` + `Right`	`Command` + `Shift` + `K`
Ungroup Pivot table items	`Alt` + `Shift` + `Left`	`Command` + `Shift` + `J`
Hide Pivot table item(s)	`Ctrl` + `-`	`Ctrl` + `-`
Create a Pivot chart on the current worksheet	`Alt` + `F1`	N/A
Create a Pivot chart on a new worksheet	`F11`	`Function` + `F11`
Open the Pivot table/Pivot chart wizard	`Alt` + `D` + `P`	`Command` + `Option` + `P`
Pop up windows
Move to the next button/field	`Tab`	`Tab`
Move to the previous button/field	`Shift` + `Tab`	`Shift` + `Tab`
Move to the next tab	`Ctrl` + `Tab`	`Control` + `Tab`
Move to the previous tab	`Ctrl` + `Shift` + `Tab`	`Control` + `Shift` + `Tab`
Accept	`Enter`	`Return`
Check or uncheck a checkbox	`Space`	`Space`
Cancel and close the window	`Esc`	`Esc`
Open Spelling window	`F7`	`Function` + `F7`
Open Thesaurus window	`Shift` + `F7`	`Function` + `Shift` + `F7`
Open Macro window	`Alt` + `F8`	`Function` + `Option` + `F8`
Open VBA Editor window	`Alt` + `F11`	`Function` + `Option` + `F11`
Duplicate object	`Ctrl` + `D`	`Command` + `D`
Snap to grid	`Alt`	`Command`
Hide or show objects	`Ctrl` + `6`	`Control` + `6`
Show cell Style window	`Alt` + `'`	`Command` + `Shift` + `L`
Show right-click menu	`Shift` + `F10`	`Function` + `Shift` + `F10`
Delete comment	`Shift` + `F10` + `D`	`Function` + `Shift` + `F10`
Display control menu	`Alt` + `Space`	N/A
Selecting
Select the entire row	`Shift` + `Space`	`Shift` + `Space`
Select the entire column	`Ctrl` + `Space`	`Control` + `Space`
Select the entire worksheet or table	`Ctrl` + `A`	`Command` + `A`
Add adjacent cells to the current selection	`Shift` + `Click`	`Shift` + `Click`
Add non-adjacent cells to the current selection	`Ctrl` + `Click`	`Command` + `Click`
Get the same selection in the next column	N/A	`Option` + `Tab`
Get the same selection in the previous column	N/A	`Option` + `Shift` + `Tab`
Move to the next selection in multiple selections	`Ctrl` + `Alt` + `Right`	`Control` + `Option` + `Right`
Move to the previous selection in multiple selections	`Ctrl` + `Alt` + `Left`	`Control` + `Option` + `Left`
Toggle Add to selection mode	`Shift` + `F8`	`Function` + `Shift` + `F8`
Cancel selection	`Esc`	`Esc`
Special selecting
Display Go To window	`Ctrl` + `G`	`Control` + `G`
Select cells with comments	`Ctrl` + `Shift` + `O`	`Function` + `Control` + `Shift` + `O`
Select the region around the active cell	`Ctrl` + `Shift` + `*`	`Shift` + `Control` + `Space`
Select the complete worksheet or table	`Ctrl` + `A`	`Command` + `A`
Select the current array	`Ctrl` + `/`	`Control` + `/`
Select row differences	`Ctrl` + `\`	`Control` + `\`
Select column differences	`Ctrl` + `Shift` + `\|`	`Control` + `Shift` + `\|`
Select direct formula precedents	`Ctrl` + `[`	`Control` + `[`
Select all formula precedents	`Ctrl` + `Shift` + `{`	`Control` + `Shift` + `{`
Select direct formula dependents	`Ctrl` + `]`	`Control` + `]`
Select all formula dependents	`Ctrl` + `Shift` + `}`	`Control` + `Shift` + `}`
Remove hidden cells from selection	`Alt` + `;`	`Command` + `Shift` + `Z`
Tables
Insert a table	`Ctrl` + `T`	`Control` + `T`
Enable or disable Autofilter	`Ctrl` + `Shift` + `L`	`Command` + `Shift` + `F`
Activate filter	`Alt` + `Down`	`Option` + `Down`
Select entire table row	`Shift` + `Space`	`Shift` + `Space`
Select entire table column	`Ctrl` + `Space`	`Control` + `Space`
Select entire table	`Ctrl` + `A`	`Command` + `A`
Clear slicer filter	`Alt` + `C`	`Option` + `C`
Enable or disable table total row	`Ctrl` + `Shift` + `T`	`Command` + `Shift` + `T`
The Ribbon
Expand or collapse ribbon	`Ctrl` + `F1`	`Command` + `Option` + `R`
Show access keys (Ribbon shortcuts)	`Alt`	N/A
Move to the next ribbon button/field	`Tab`	`Tab`
Activate the selected button/field	`Space`	`Space`
Confirm button/field change	`Enter`	`Return`
Open help window for the selected button/field	`F1`	N/A
The ribbon
Switch to the File tab	`Alt` + `F`	N/A
Switch to the Home tab	`Alt` + `H`	N/A
Switch to the Insert tab	`Alt` + `N`	N/A
Switch to the Page Layout tab	`Alt` + `P`	N/A
Switch to the Formula tab	`Alt` + `M`	N/A
Switch to the Data tab	`Alt` + `A`	N/A
Switch to the Review tab	`Alt` + `R`	N/A
Switch to the View tab	`Alt` + `W`	N/A
Switch to the Developer tab	`Alt` + `L`	N/A
Switch to the Help tab	`Alt` + `Y`	N/A
Workbook
Insert a new worksheet	`Shift` + `F11`	`Function` + `Shift` + `F11`
Go to the next worksheet	`Ctrl` + `PageDown`	`Function` + `Control` + `Down`
Go to the previous worksheet	`Ctrl` + `PageUp`	`Function` + `Control` + `Up`
Move to the next workbook element	`F6`	`Function` + `F6`
Move to the previous workbook element	`Shift` + `F6`	`Function` + `Shift` + `F6`
Go to the next workbook	`Ctrl` + `Tab`	`Control` + `Tab`
Go to the previous workbook	`Ctrl` + `Shift` + `Tab`	`Control` + `Shift` + `Tab`
Minimize the current workbook window	`Ctrl` + `F9`	`Command` + `M`
Maximize the current workbook window	`Ctrl` + `F10`	`Function` + `Control` + `F10`
Select multiple adjacent worksheet tabs	`Shift` + `Click`	`Shift` + `Click`
Select multiple non-adjacent worksheet tabs	`Ctrl` + `Click`	`Command` + `Click`
Enable or disable scroll lock	`ScrollLock`	`Function` + `Shift` + `F14`
Enable or disable full screen	`Ctrl` + `Shift` + `F1`	`Control` + `Command` + `F`

Select active cell only

Windows

Shift + Backspace

Mac

Shift + Delete

Move screen to the active cell

Windows

Ctrl + Backspace

Mac

Command + Delete

Move active cell to the corner in the selection

Windows

Ctrl + .

Mac

Control + .

Move active cell down in selection

Windows

Enter

Mac

Return

Move active cell up in selection

Windows

Shift + Enter

Mac

Shift + Return

Move active cell right in a selection

Windows

Tab

Mac

Tab

Move active cell left in a selection

Windows

Shift + Tab

Mac

Shift + Tab

Add borders

Windows

Ctrl + Shift + &

Mac

Command + Option + 0

Add or remove right border

Windows

Alt + R

Mac

Command + Option + Right

Add or remove left border

Windows

Alt + L

Mac

Command + Option + Left

Add or remove top border

Windows

Alt + T

Mac

Command + Option + Up

Add or remove bottom border

Windows

Alt + B

Mac

Command + Option + Down

Add or remove border upward diagonal

Windows

Alt + D

Mac

N/A

Add or remove border horizontal interior

Windows

Alt + H

Mac

N/A

Add or remove border vertical interior

Windows

Alt + V

Mac

N/A

Remove borders

Windows

Ctrl + Shift + _

Mac

Command + Option + _

Edit the active cell

Windows

F2

Mac

Control + U

Insert or edit comment

Windows

Shift + F2

Mac

Function + Shift + F2

Cancel editing cell

Windows

Esc

Mac

Esc

Select one character right of the cursor

Windows

Shift + Right

Mac

Shift + Right

Select one character left of the cursor

Windows

Shift + Left

Mac

Shift + Left

Move the cursor one word right

Windows

Ctrl + Right

Mac

Control + Right

Move the cursor one word left

Windows

Ctrl + Left

Mac

Control + Left

Select one word right of the cursor

Windows

Ctrl + Shift + Right

Mac

Control + Shift + Right

Select one word left of the cursor

Windows

Ctrl + Shift + Left

Mac

Control + Shift + Left

Select everything from the cursor up to the beginning of the cell

Windows

Shift + Home

Mac

Function + Shift + Left

Select everything from the cursor up to the end of the cell

Windows

Shift + End

Mac

Function + Shift + Right

Delete word to the right of the cursor

Windows

Ctrl + Delete

Mac

Control + Delete

Delete character to the left of cursor

Windows

Backspace

Mac

Delete

Delete character to the right of cursor

Windows

Delete

Mac

Function + Delete

Add a new line inside of a cell

Windows

Alt + Enter

Mac

Control + Option + Return

Confirm entry and move down

Windows

Enter

Mac

Return

Confirm entry and move up

Windows

Shift + Enter

Mac

Shift + Return

Confirm entry and move right

Windows

Tab

Mac

Tab

Confirm entry and move left

Windows

Shift + Tab

Mac

Shift + Tab

Confirm entry and stay in the same cell

Windows

Ctrl + Enter

Mac

Control + Return

Enter the same data in multiple cells

Windows

Ctrl + Enter

Mac

Control + Return

Insert the current date

Windows

Ctrl + ;

Mac

Control + ;

Insert the current time

Windows

Ctrl + Shift + :

Mac

Command + ;

Fill down from cell above the active cell

Windows

Ctrl + D

Mac

Control + D

Fill right from cell to the left of the active cell

Windows

Ctrl + R

Mac

Control + R

Copy the formula from the cell above the active cell

Windows

Ctrl + '

Mac

Control + '

Copy the value from the cell above the active cell

Windows

Ctrl + Shift + "

Mac

Control + Shift + "

Add a hyperlink

Windows

Ctrl + K

Mac

Command + K

Display the AutoComplete list

Windows

Alt + Down

Mac

Option + Down

Flash fill

Windows

Ctrl + E

Mac

N/A

Drag selection and move

Windows

drag

Mac

drag

Drag selection and copy

Windows

Ctrl + drag

Mac

Option + drag

Drag selection and insert

Windows

Shift + drag

Mac

Shift + drag

Drag selection and insert a copy

Windows

Ctrl + Shift + drag

Mac

Option + Shift + drag

Drag worksheet tab

Windows

Alt + drag

Mac

Command + drag

Drag worksheet tab and copy

Windows

Ctrl + drag

Mac

Option + drag

Extend the selection by one cell right

Windows

Shift + Right

Mac

Shift + Right

Extend the selection by one cell left

Windows

Shift + Left

Mac

Shift + Left

Extend the selection by one cell up

Windows

Shift + Up

Mac

Shift + Up

Extend the selection by one cell down

Windows

Shift + Down

Mac

Shift + Down

Extend the selection to the last cell to the right

Windows

Ctrl + Shift + Right

Mac

Control + Shift + Right

Extend the selection to the last cell to the left

Windows

Ctrl + Shift + Left

Mac

Control + Shift + Left

Extend the selection to the last cell upwards

Windows

Ctrl + Shift + Up

Mac

Control + Shift + Up

Extend the selection to the last cell downwards

Windows

Ctrl + Shift + Down

Mac

Control + Shift + Down

Extend the selection up one screen

Windows

Shift + PageUp

Mac

Function + Shift + Up

Extend the selection down one screen

Windows

Shift + PageDown

Mac

Function + Shift + Down

Extend the selection right one screen

Windows

Alt + Shift + PageDown

Mac

Function + Shift + Command + Down

Extend the selection left one screen

Windows

Alt + Shift + PageUp

Mac

Function + Shift + Command + Up

Extend the selection to the start of the row

Windows

Shift + Home

Mac

Function + Shift + Left

Extend the selection to the first cell in the worksheet

Windows

Ctrl + Shift + Home

Mac

Function + Control + Shift + Left

Extend the selection to the last cell in the worksheet

Windows

Ctrl + Shift + End

Mac

Function + Control + Shift + Right

Enable or disable the Extend selection mode

Windows

F8

Mac

Function + F8

Create a new workbook

Windows

Ctrl + N

Mac

Command + N

Open a workbook

Windows

Ctrl + O

Mac

Command + O

Save the workbook

Windows

Ctrl + S

Mac

Command + S

Open save as window

Windows

F12

Mac

Command + Shift + S

Print file

Windows

Ctrl + P

Mac

Command + P

Open the print preview window

Windows

Ctrl + F2

Mac

N/A

Close the current workbook

Windows

Ctrl + F4

Mac

Command + W

Close Excel application

Windows

Alt + F4

Mac

Command + Q

Open the Formatting window

Windows

Ctrl + 1

Mac

Command + 1

Open Formatting window on the Font tab

Windows

Ctrl + Shift + F

Mac

Control + Shift + F

Apply or remove bold formatting

Windows

Ctrl + B

Mac

Command + B

Apply or remove italic formatting

Windows

Ctrl + I

Mac

Command + I

Apply or remove underscore formatting

Windows

Ctrl + U

Mac

Command + U

Apply or remove strikethrough formatting

Windows

Ctrl + 5

Mac

Command + Shift + X

Add or remove a shadow font style

Windows

N/A

Mac

Command + Shift + W

Add or remove an outline font style

Windows

N/A

Mac

Command + Shift + D

Align center

Windows

Alt + H + A + C

Mac

Command + E

Align left

Windows

Alt + H + A + L

Mac

Command + L

Align right

Windows

Alt + H + A + R

Mac

Command + R

Indent

Windows

Alt + H + 6

Mac

Control + Option + Tab

Remove indent

Windows

Alt + H + 5

Mac

Control + Option + Shift + Tab

Increase the font size by one step

Windows

Alt + H + F + G

Mac

Command + Shift + >

Decrease the font size by one step

Windows

Alt + H + F + K

Mac

Command + Shift + <

Switch between absolute, relative and mixed references

Windows

F4

Mac

Command + T

Open the Insert Function window

Windows

Shift + F3

Mac

Function + Shift + F3

Autosum the selected cells

Windows

Alt + =

Mac

Command + Shift + T

Enable or disable formulas

Windows

Ctrl + `

Mac

Control + `

Insert function arguments

Windows

Ctrl + Shift + A

Mac

Control + Shift + A

Enter an Array formula

Windows

Ctrl + Shift + Enter

Mac

Control + Shift + Return

(Re)calculate all worksheets

Windows

F9

Mac

Function + F9

(Re)calculate the active worksheet

Windows

Shift + F9

Mac

Function + Shift + F9

Force (re)calculate all worksheets

Windows

Ctrl + Alt + F9

Mac

N/A

Evaluate a subset of a formula

Windows

F9

Mac

Function + F9

Expand or collapse the formula bar

Windows

Ctrl + Shift + U

Mac

Control + Shift + U

Display Function Arguments window

Windows

Ctrl + A

Mac

Control + A

Confirm autocomplete function

Windows

Tab

Mac

Tab

Open options

Windows

Alt + F + T

Mac

Command + ,

Open the help window

Windows

F1

Mac

Command + /

Undo the last action

Windows

Ctrl + Z

Mac

Command + Z

Redo the last action

Windows

Ctrl + Y

Mac

Command + Y

Copy the contents of the selected cells

Windows

Ctrl + C

Mac

Command + C

Repeat the last action

Windows

F4

Mac

Command + Y

Cut the contents of the selected cells

Windows

Ctrl + X

Mac

Command + X

Paste the content of the clipboard

Windows

Ctrl + V

Mac

Command + V

Show the Paste Special window

Windows

Ctrl + Alt + V

Mac

Control + Command + V

Show the find window

Windows

Ctrl + F

Mac

Command + F

Show the find and replace window

Windows

Ctrl + H

Mac

Control + H

Find the next match

Windows

Shift + F4

Mac

Command + G

Find the previous match

Windows

Ctrl + Shift + F4

Mac

Command + Shift + G

Create an embedded chart

Windows

Alt + F1

Mac

Function + Option + F1

Create a chart on a new worksheet

Windows

F11

Mac

Function + F11

Show Insert window

Windows

Ctrl + Shift + +

Mac

Command + Shift + +

Insert row(s)

Windows

Ctrl + Shift + +

Mac

Command + Shift + +

Insert column(s)

Windows

Ctrl + Shift + +

Mac

Command + Shift + +

Show Delete (rows, columns or cells) window

Windows

Ctrl + -

Mac

Command + -

Delete row(s)

Windows

Ctrl + -

Mac

Command + -

Delete column(s)

Windows

Ctrl + -

Mac

Command + -

Delete cells

Windows

Ctrl + -

Mac

Command + -

Delete the contents of the selected cell(s)

Windows

Delete

Mac

Function + Delete

Hide selected column(s)

Windows

Ctrl + 0

Mac

Control + 0

Hide selected row(s)

Windows

Ctrl + 9

Mac

Control + 9

Unhide/show rows

Windows

Ctrl + Shift + 9

Mac

Control + Shift + 9

Unhide/show columns

Windows

Ctrl + Shift + 0

Mac

Control + Shift + 0

Group rows or columns

Windows

Alt + Shift + Right

Mac

Command + Shift + K

Ungroup rows or columns

Windows

Alt + Shift + Left

Mac

Command + Shift + J

Open Group window

Windows

Alt + Shift + Right

Mac

Command + Shift + K

Open Ungroup window

Windows

Alt + Shift + Left

Mac

Command + Shift + J

Hide or show outline/group view

Windows

Ctrl + 8

Mac

Control + 8

Zoom in

Windows

Ctrl + Alt + +

Mac

Option + Command + +

Zoom out

Windows

Ctrl + Alt + -

Mac

Option + Command + -

Open Name Manager window

Windows

Ctrl + F3

Mac

Function + Control + F3

Create names from row/column headings

Windows

Ctrl + Shift + F3

Mac

Function + Control + Shift + F3

Paste name into formula

Windows

F3

Mac

N/A

Move one cell to the right

Windows

Right

Mac

Right

Move one cell to the left

Windows

Left

Mac

Left

Move one cell up

Windows

Up

Mac

Up

Move one cell down

Windows

Down

Mac

Down

Move one screen right

Windows

Alt + PageDown

Mac

Function + Option + Down

Move one screen left

Windows

Alt + PageUp

Mac

Function + Option + Up

Move one screen up

Windows

PageUp

Mac

Function + Up

Move one screen down

Windows

PageDown

Mac

Function + Down

Move to the right of the worksheet or table

Windows

Ctrl + Right

Mac

Control + Right

Move to the left of the worksheet or table

Windows

Ctrl + Left

Mac

Control + Left

Move to the top of the worksheet or table

Windows

Ctrl + Up

Mac

Control + Up

Move to the bottom of the worksheet or table

Windows

Ctrl + Down

Mac

Control + Down

Move to the first cell of the row

Windows

Home

Mac

Function + Left

Move to the last cell in the worksheet

Windows

Ctrl + End

Mac

Function + Control + Right

Move to the first cell in the worksheet

Windows

Ctrl + Home

Mac

Function + Control + Left

Turn on End Mode

Windows

End

Mac

Function + Right

Go back to hyperlink

Windows

Ctrl + G + Enter

Mac

Control + G + Return

Apply General number format

Windows

Ctrl + Shift + ~

Mac

Control + Shift + ~

Apply Currency number format

Windows

Ctrl + Shift + $

Mac

Control + Shift + $

Apply Percentage number format

Windows

Ctrl + Shift + %

Mac

Control + Shift + %

Apply Scientific number format

Windows

Ctrl + Shift + ^

Mac

Control + Shift + ^

Apply Date number format

Windows

Ctrl + Shift + #

Mac

Control + Shift + #

Apply Time number format

Windows

Ctrl + Shift + @

Mac

Control + Shift + @

Apply Number number format

Windows

Ctrl + Shift + !

Mac

Control + Shift + !

Select the entire Pivot table

Windows

Ctrl + A

Mac

Command + A

Toggle Pivot table field checkbox

Windows

Space

Mac

Space

Group Pivot table items

Windows

Alt + Shift + Right

Mac

Command + Shift + K

Ungroup Pivot table items

Windows

Alt + Shift + Left

Mac

Command + Shift + J

Hide Pivot table item(s)

Windows

Ctrl + -

Mac

Ctrl + -

Create a Pivot chart on the current worksheet

Windows

Alt + F1

Mac

N/A

Create a Pivot chart on a new worksheet

Windows

F11

Mac

Function + F11

Open the Pivot table/Pivot chart wizard

Windows

Alt + D + P

Mac

Command + Option + P

Move to the next button/field

Windows

Tab

Mac

Tab

Move to the previous button/field

Windows

Shift + Tab

Mac

Shift + Tab

Move to the next tab

Windows

Ctrl + Tab

Mac

Control + Tab

Move to the previous tab

Windows

Ctrl + Shift + Tab

Mac

Control + Shift + Tab

Windows

Enter

Mac

Return

Check or uncheck a checkbox

Windows

Space

Mac

Space

Cancel and close the window

Windows

Esc

Mac

Esc

Open Spelling window

Windows

F7

Mac

Function + F7

Open Thesaurus window

Windows

Shift + F7

Mac

Function + Shift + F7

Open Macro window

Windows

Alt + F8

Mac

Function + Option + F8

Open VBA Editor window

Windows

Alt + F11

Mac

Function + Option + F11

Duplicate object

Windows

Ctrl + D

Mac

Command + D

Snap to grid

Windows

Alt

Mac

Command

Hide or show objects

Windows

Ctrl + 6

Mac

Control + 6

Show cell Style window

Windows

Alt + '

Mac

Command + Shift + L

Show right-click menu

Windows

Shift + F10

Mac

Function + Shift + F10

Delete comment

Windows

Shift + F10 + D

Mac

Function + Shift + F10

Display control menu

Windows

Alt + Space

Mac

N/A

Select the entire row

Windows

Shift + Space

Mac

Shift + Space

Select the entire column

Windows

Ctrl + Space

Mac

Control + Space

Select the entire worksheet or table

Windows

Ctrl + A

Mac

Command + A

Add adjacent cells to the current selection

Windows

Shift + Click

Mac

Shift + Click

Add non-adjacent cells to the current selection

Windows

Ctrl + Click

Mac

Command + Click

Get the same selection in the next column

Windows

N/A

Mac

Option + Tab

Get the same selection in the previous column

Windows

N/A

Mac

Option + Shift + Tab

Move to the next selection in multiple selections

Windows

Ctrl + Alt + Right

Mac

Control + Option + Right

Move to the previous selection in multiple selections

Windows

Ctrl + Alt + Left

Mac

Control + Option + Left

Toggle Add to selection mode

Windows

Shift + F8

Mac

Function + Shift + F8

Cancel selection

Windows

Esc

Mac

Esc

Display Go To window

Windows

Ctrl + G

Mac

Control + G

Select cells with comments

Windows

Ctrl + Shift + O

Mac

Function + Control + Shift + O

Select the region around the active cell

Windows

Ctrl + Shift + *

Mac

Shift + Control + Space

Select the complete worksheet or table

Windows

Ctrl + A

Mac

Command + A

Select the current array

Windows

Ctrl + /

Mac

Control + /

Select row differences

Windows

Ctrl + \

Mac

Control + \

Select column differences

Windows

Ctrl + Shift + |

Mac

Control + Shift + |

Select direct formula precedents

Windows

Ctrl + [

Mac

Control + [

Select all formula precedents

Windows

Ctrl + Shift + {

Mac

Control + Shift + {

Select direct formula dependents

Windows

Ctrl + ]

Mac

Control + ]

Select all formula dependents

Windows

Ctrl + Shift + }

Mac

Control + Shift + }

Remove hidden cells from selection

Windows

Alt + ;

Mac

Command + Shift + Z

Insert a table

Windows

Ctrl + T

Mac

Control + T

Enable or disable Autofilter

Windows

Ctrl + Shift + L

Mac

Command + Shift + F

Activate filter

Windows

Alt + Down

Mac

Option + Down

Select entire table row

Windows

Shift + Space

Mac

Shift + Space

Select entire table column

Windows

Ctrl + Space

Mac

Control + Space

Select entire table

Windows

Ctrl + A

Mac

Command + A

Clear slicer filter

Windows

Alt + C

Mac

Option + C

Enable or disable table total row

Windows

Ctrl + Shift + T

Mac

Command + Shift + T

Expand or collapse ribbon

Windows

Ctrl + F1

Mac

Command + Option + R

Show access keys (Ribbon shortcuts)

Windows

Alt

Mac

N/A

Move to the next ribbon button/field

Windows

Tab

Mac

Tab

Activate the selected button/field

Windows

Space

Mac

Space

Confirm button/field change

Windows

Enter

Mac

Return

Open help window for the selected button/field

Windows

F1

Mac

N/A

Switch to the File tab

Windows

Alt + F

Mac

N/A

Switch to the Home tab

Windows

Alt + H

Mac

N/A

Switch to the Insert tab

Windows

Alt + N

Mac

N/A

Switch to the Page Layout tab

Windows

Alt + P

Mac

N/A

Switch to the Formula tab

Windows

Alt + M

Mac

N/A

Switch to the Data tab

Windows

Alt + A

Mac

N/A

Switch to the Review tab

Windows

Alt + R

Mac

N/A

Switch to the View tab

Windows

Alt + W

Mac

N/A

Switch to the Developer tab

Windows

Alt + L

Mac

N/A

Switch to the Help tab

Windows

Alt + Y

Mac

N/A

Insert a new worksheet

Windows

Shift + F11

Mac

Function + Shift + F11

Go to the next worksheet

Windows

Ctrl + PageDown

Mac

Function + Control + Down

Go to the previous worksheet

Windows

Ctrl + PageUp

Mac

Function + Control + Up

Move to the next workbook element

Windows

F6

Mac

Function + F6

Move to the previous workbook element

Windows

Shift + F6

Mac

Function + Shift + F6

Go to the next workbook

Windows

Ctrl + Tab

Mac

Control + Tab

Go to the previous workbook

Windows

Ctrl + Shift + Tab

Mac

Control + Shift + Tab

Minimize the current workbook window

Windows

Ctrl + F9

Mac

Command + M

Maximize the current workbook window

Windows

Ctrl + F10

Mac

Function + Control + F10

Select multiple adjacent worksheet tabs

Windows

Shift + Click

Mac

Shift + Click

Select multiple non-adjacent worksheet tabs

Windows

Ctrl + Click

Mac

Command + Click

Enable or disable scroll lock

Windows

ScrollLock

Mac

Function + Shift + F14

Enable or disable full screen

Windows

Ctrl + Shift + F1

Mac

Control + Command + F

Excel keyboard shortcuts

Active cell

Borders

Cell contents

Data entry

Drag cells

Drag worksheet

Extending the selection

File

Formatting

Formulas

General

Grid operations

Naming

Navigation

Number formatting

Pivot tables

Pop up windows

Selecting

Special selecting

Tables

The Ribbon

The ribbon

Workbook

Active cell

Borders

Cell contents

Data entry

Drag cells

Drag worksheet

Extending the selection

File

Formatting

Formulas

General

Grid operations

Naming

Navigation

Number formatting

Pivot tables

Pop up windows

Selecting

Special selecting

Tables

The Ribbon

The ribbon

Workbook