​​​​230+ Excel Keyboard Shortcuts (Windows & Mac)

​​Get a printable PDF version

​Easily improve your Excel speed ​by printing the PDF version of these keyboard shortcuts.

Search:

Filter by category:

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

+

Add or remove left border

Windows

Alt

+

L

Mac

⌘Command

+

⌥Option

+

Add or remove top border

Windows

Alt

+

T

Mac

⌘Command

+

⌥Option

+

Add or remove bottom border

Windows

Alt

+

B

Mac

⌘Command

+

⌥Option

+

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

Fn(Function)

+

⇧Shift

+

F2

Cancel editing cell

Windows

Esc

Mac

Esc

Select one character right of the cursor

Windows

⇧Shift

+

Mac

⇧Shift

+

Select one character left of the cursor

Windows

⇧Shift

+

Mac

⇧Shift

+

Move the cursor one word right

Windows

Ctrl

+

Mac

⌃Control

+

Move the cursor one word left

Windows

Ctrl

+

Mac

⌃Control

+

Select one word right of the cursor

Windows

Ctrl

+

⇧Shift

+

Mac

⌃Control

+

⇧Shift

+

Select one word left of the cursor

Windows

Ctrl

+

⇧Shift

+

Mac

⌃Control

+

⇧Shift

+

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

Windows

⇧Shift

+

Home

Mac

Fn(Function)

+

⇧Shift

+

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

Windows

⇧Shift

+

End

Mac

Fn(Function)

+

⇧Shift

+

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

Fn(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

+

Mac

⌥Option

+

Flash fill

Windows

Ctrl

+

E

Mac

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

+

Mac

⇧Shift

+

Extend the selection by one cell left

Windows

⇧Shift

+

Mac

⇧Shift

+

Extend the selection by one cell up

Windows

⇧Shift

+

Mac

⇧Shift

+

Extend the selection by one cell down

Windows

⇧Shift

+

Mac

⇧Shift

+

Extend the selection to the last cell to the right

Windows

Ctrl

+

⇧Shift

+

Mac

⌃Control

+

⇧Shift

+

Extend the selection to the last cell to the left

Windows

Ctrl

+

⇧Shift

+

Mac

⌃Control

+

⇧Shift

+

Extend the selection to the last cell upwards

Windows

Ctrl

+

⇧Shift

+

Mac

⌃Control

+

⇧Shift

+

Extend the selection to the last cell downwards

Windows

Ctrl

+

⇧Shift

+

Mac

⌃Control

+

⇧Shift

+

Extend the selection up one screen

Windows

⇧Shift

+

PageUp

Mac

Fn(Function)

+

⇧Shift

+

Extend the selection down one screen

Windows

⇧Shift

+

PageDown

Mac

Fn(Function)

+

⇧Shift

+

Extend the selection right one screen

Windows

Alt

+

⇧Shift

+

PageDown

Mac

Fn(Function)

+

⇧Shift

+

⌘Command

+

Extend the selection left one screen

Windows

Alt

+

⇧Shift

+

PageUp

Mac

Fn(Function)

+

⇧Shift

+

⌘Command

+

Extend the selection to the start of the row

Windows

⇧Shift

+

Home

Mac

Fn(Function)

+

⇧Shift

+

Extend the selection to the first cell in the worksheet

Windows

Ctrl

+

⇧Shift

+

Home

Mac

Fn(Function)

+

⌃Control

+

⇧Shift

+

Extend the selection to the last cell in the worksheet

Windows

Ctrl

+

⇧Shift

+

End

Mac

Fn(Function)

+

⌃Control

+

⇧Shift

+

Enable or disable the Extend selection mode

Windows

F8

Mac

Fn(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

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

Mac

⌘Command

+

⇧Shift

+

W

Add or remove an outline font style

Windows

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

Fn(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

Fn(Function)

+

F9

(Re)calculate the active worksheet

Windows

⇧Shift

+

F9

Mac

Fn(Function)

+

⇧Shift

+

F9

Force (re)calculate all worksheets

Windows

Ctrl

+

Alt

+

F9

Mac

Evaluate a subset of a formula

Windows

F9

Mac

Fn(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

Fn(Function)

+

⌥Option

+

F1

Create a chart one a new worksheet

Windows

F11

Mac

Fn(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 the contents of the selected cell(s)

Windows

Delete

Mac

Fn(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

+

Mac

⌘Command

+

⇧Shift

+

K

Ungroup rows or columns

Windows

Alt

+

⇧Shift

+

Mac

⌘Command

+

⇧Shift

+

J

Open Group window

Windows

Alt

+

⇧Shift

+

Mac

⌘Command

+

⇧Shift

+

K

Open Ungroup window

Windows

Alt

+

⇧Shift

+

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

Fn(Function)

+

⌃Control

+

F3

Create names from row/column headings

Windows

Ctrl

+

⇧Shift

+

F3

Mac

Fn(Function)

+

⌃Control

+

⇧Shift

+

F3

Paste name into formula

Windows

F3

Mac

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

Group Pivot table items

Windows

Alt

+

⇧Shift

+

Mac

⌘Command

+

⇧Shift

+

K

Ungroup Pivot table items

Windows

Alt

+

⇧Shift

+

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

Create a Pivot chart on a new worksheet

Windows

F11

Mac

Fn(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

Accept

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

Fn(Function)

+

F7

Open Thesaurus window

Windows

⇧Shift

+

F7

Mac

Fn(Function)

+

⇧Shift

+

F7

Open Macro window

Windows

Alt

+

F8

Mac

Fn(Function)

+

⌥Option

+

F8

Open VBA Editor window

Windows

Alt

+

F11

Mac

Fn(Function)

+

⌥Option

+

F11

Show cell Style window

Windows

Alt

+

'

Mac

⌘Command

+

⇧Shift

+

L

Show right-click menu

Windows

⇧Shift

+

F10

Mac

Fn(Function)

+

⇧Shift

+

F10

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

Mac

⌥Option

+

Tab

Get the same selection in the previous column

Windows

Mac

⌥Option

+

⇧Shift

+

Tab

Move to the next selection in multiple selections

Windows

Ctrl

+

Alt

+

Mac

⌃Control

+

⌥Option

+

Move to the previous selection in multiple selections

Windows

Ctrl

+

Alt

+

Mac

⌃Control

+

⌥Option

+

Toggle Add to selection mode

Windows

⇧Shift

+

F8

Mac

Fn(Function)

+

⇧Shift

+

F8

Cancel selection

Windows

Esc

Mac

Esc

Display Go To window

Windows

Ctrl

+

G

Mac

⌃Control

+

G

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

+

Mac

⌥Option

+

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

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