Excel keyboard shortcuts (Windows and Mac)

File

Create new workbook
Ctrl
N
⌘
N
Open workbook
Ctrl
O
⌘
O
Save workbook
Ctrl
S
⌘
S
Save as
F12
⌘
⇧
S
Open print options window
Ctrl
P
⌘
P
Close current workbook
Ctrl
F4
⌘
W
Close Excel
Alt
F4
⌘
Q

Ribbon

Expand or collapse ribbon
Ctrl
F1
⌘
⌥
R
Activate access keys
Alt
Move to next ribbon control
Tab
Tab
Active selected control
Space
Space
Confirm change
Enter
Return
Move one control up
↑
↑
Move one control down
↓
↓
Move one control right
→
→
Move one control left
←
←

General

Show help
F1
F1
Undo last change
Ctrl
Z
⌘
Z
Redo last change
Ctrl
Y
⌘
Y
Toggle Autofilter
Ctrl
Shift
L
⌘
⇧
F

Navigation

Move one cell up
↑
↑
Move one cell down
↓
↓
Move one cell right
→
→
Move one cell left
←
←
Move one screen up
PgUp
Fn
↑
Move one screen down
PgDn
Fn
↓
Move one screen right
Alt
PgDn
Fn
⌥
↑
Move one screen left
Alt
PgUp
Fn
⌥
↓
Move to top edge of data region
Ctrl
↑
⌃
↑
Move to bottom edge of data region
Ctrl
↓
⌃
↓
Move to right edge of data region
Ctrl
→
⌃
→
Move to left edge of data region
Ctrl
←
⌃
←
Move to beginning of row
Home
Fn
←
Show active cell
Ctrl
Backspace
⌘
Delete
Move one cell up
Shift
Enter
⇧
Return
Move one cell down
Enter
Return
Move one cell right
Tab
Tab
Move one cell left
Shift
Tab
⇧
Tab

Selection

Select entire row
Shift
Space
⇧
Space
Select entire column
Ctrl
Space
⌃
Space
Select region around active cell
Ctrl
A
⌘
A
Select entire worksheet
Ctrl
A
⌘
A
Add non-adjacent cells to selection
Ctrl
click
⌘
click
Expand selection
Shift
click
⇧
click
Move right between selections
Ctrl
Alt
→
⌃
⌥
→
Move left between selections
Ctrl
Alt
←
⌃
⌥
←
Toggle add to selection mode
Shift
F8
Fn
⇧
F8
Select active cell only
Shift
Backspace
⇧
Delete
Move active cell clockwise in selection
Ctrl
.
⌃
.
Move active cell down in selection
Enter
Return
Move active cell up in selection
Shift
Enter
⇧
Return
Move active cell right in selection
Tab
Tab
Move active cell left in selection
Shift
Tab
⇧
Tab
Extend selection by one cell up
Shift
↑
⇧
↑
Extend selection by one cell down
Shift
↓
⇧
↓
Extend selection by one cell right
Shift
→
⇧
→
Extend selection by one cell left
Shift
←
⇧
←
Extend the selection to the last cell up
Ctrl
Shift
↑
⌃
⇧
↑
Extend the selection to the last cell down
Ctrl
Shift
↓
⌃
⇧
↓
Extend the selection to the last cell right
Ctrl
Shift
→
⌃
⇧
→
Extend the selection to the last cell left
Ctrl
Shift
←
⌃
⇧
←
Extend selection up one screen
Shift
PgUp
Fn
⇧
↑
Extend selection down one screen
Shift
PgDn
Fn
⇧
↓
Extend selection to beginning of row
Shift
Home
Fn
⇧
←
Extend selection to first cell in worksheet
Ctrl
Shift
Home
Fn
⌃
⇧
←
Extend selection to last cell in data range
Ctrl
Shift
End
Fn
⌃
⇧
→
Toggle extend selection mode
F8
Fn
F8
Select region around active cell
Ctrl
Shift
*
⇧
⌃
Space
Open Name Manager window
Ctrl
F3
L
Create names from selection
Ctrl
Shift
F3
⌃
⇧
F3

Advanced selection

Open “Go To” window
Ctrl
G
⌃
G
Select all cells with comments
Ctrl
Shift
O
Fn
⌃
⇧
O
Select current array
Ctrl
/
⌃
/
Select row differences
Ctrl
\
⌃
\
Select column differences
Ctrl
Shift
|
⌃
⇧
|
Select direct precedents
Ctrl
[
⌃
[
Select all precedents
Ctrl
Shift
{
⌃
⇧
{
Select direct dependents
Ctrl
]
⌃
]
Select all dependents
Ctrl
Shift
}
⌃
⇧
}
Select visible cells only
Alt
;
⌘
⇧
Z

Copy, cut and paste

Copy selected data
Ctrl
C
⌘
C
Cut selected data
Ctrl
X
⌘
X
Paste data
Ctrl
V
⌘
V
Open Paste special window
Ctrl
Alt
V
⌃
⌘
V
Cut and paste
drag
drag
Copy and paste
Ctrl
drag
⌥
drag
Cut and insert
Shift
drag
⇧
drag
Copy and insert
Ctrl
Shift
drag
⌥
⇧
drag
Cut and paste to different worksheet
Alt
drag
⌘
drag
Duplicate worksheet
Ctrl
drag
⌥
drag
Copy above cell and paste in active cell
Ctrl
D
⌃
D
Copy cell to the left and paste in active cell
Ctrl
R
⌃
R
Copy above cell and edit in active cell
Ctrl
“
⌃
“
Copy above cell and edit as value in active cell
Ctrl
Shift
“
⌃
⇧
“

Editing cells

Cancel edition
Esc
Esc
Edit active cell
F2
⌃
U
Insert or edit comment
Shift
F2
Fn
⇧
F2
Select one character right
Shift
→
⇧
→
Select one character left
Shift
←
⇧
←
Move one word right
Ctrl
→
⌃
→
Move one word left
Ctrl
←
⌃
←
Select one word right
Ctrl
Shift
→
⌃
⇧
→
Select one word left
Ctrl
Shift
←
⌃
⇧
←
Select to beginning of cell
Shift
Home
Fn
⇧
←
Select to end of cell
Shift
End
Fn
⇧
→
Delete after cursor
Ctrl
Delete
⌃
Delete
Delete character to the left
Backspace
Delete
Delete character to the right
Delete
Fn
Delete
Start a new line in the same cell
Alt
Enter
⌃
⌥
Return

Entering data

Confirm entry and move down
Enter
Return
Confirm entry and move up
Shift
Enter
⇧
Return
Confirm entry and move right
Tab
Tab
Confirm entry and move left
Shift
Tab
⇧
Tab
Confirm entry and stay in the cell
Ctrl
Enter
⌃
Return
Enter data into multiple cells at once
Ctrl
Enter
⌃
Return
Insert hyperlink
Ctrl
K
⌘
K
Display Autocomplete list
Alt
↓
⌥
↓
Flash fill
Ctrl
E

Data formatting

Apply general format
Ctrl
Shift
~
⌃
⇧
~
Apply currency format
Ctrl
Shift
$
⌃
⇧
$
Apply percentage format
Ctrl
Shift
%
⌃
⇧
%
Apply scientific format
Ctrl
Shift
^
⌃
⇧
^
Apply number format
Ctrl
Shift
!
⌃
⇧
!

Find and replace

Open Find window
Ctrl
F
⌘
F
Open Replace window
Ctrl
H
⌃
H
Find next match
Shift
F4
⌘
G
Find previous match
Ctrl
Shift
F4
⌘
⇧
G

Charts

Create chart in current worksheet
Alt
F1
Create chart in new worksheet
F11
Fn
F11

Date and time

Insert current date
Ctrl
;
⌃
;
Insert current time
Ctrl
Shift
;
⌃
⇧
;
Apply date format
Ctrl
Shift
#
⌃
⇧
#
Apply time format
Ctrl
Shift
@
⌃
⇧
@

Dialog boxes

Move to next control
Tab
Tab
Move to previous control
Shift
Tab
⇧
Tab
Move to next tab
Ctrl
Tab
⌃
Tab
Move to previous tab
Ctrl
Shift
Tab
⌃
⇧
Tab
Apply changes
Enter
Return
Check or uncheck checkbox
Space
Space
Close without saving
Esc
Esc

Formulas

Toggle absolute, relative and mixed references
F4
⌃
Y
Open Insert Function window
Shift
F3
Fn
⇧
F3
Use autosum
Alt
=
⌘
⇧
T
Toggle Value / Formula display
Ctrl
⌃
Insert function arguments
Ctrl
Shift
A
⌃
⇧
A
Confirm entry as array formula
Ctrl
Shift
Enter
⌃
⇧
Return
Calculate all worksheets in workbook
F9
Fn
F9
Calculate current worksheet
Shift
F9
Fn
⇧
F9
Force calculate all worksheets
Ctrl
Alt
F9
Expand the formula bar
Ctrl
Shift
U
⌃
⇧
U
Move cursor to formula bar
Ctrl
A
⌃
A
Paste name into formula
F3
Autocomplete function name
Tab
↓
Tab
Force calculate all worksheets
Ctrl
Shift
Alt
F9

Grid operations

Delete contents of selected cells
Delete
Fn
Delete
Hide or show outline symbols
Ctrl
8
⌃
8

Rows and columns

Open Insert window
Ctrl
Shift
+
⌃
I
Insert rows
Ctrl
Shift
+
⌃
I
Insert columns
Ctrl
Shift
+
⌃
I
Open Delete window
Ctrl
–
⌃
–
Delete rows
Ctrl
–
⌃
–
Delete columns
Ctrl
–
⌃
–
Hide columns
Ctrl
0
⌃
0
Hide rows
Ctrl
9
⌃
9
Unhide columns
Ctrl
Shift
0
⌃
⇧
0
Unhide rows
Ctrl
Shift
9
⌃
⇧
9
Group rows or columns
Alt
Shift
→
⌘
⇧
K
Ungroup rows or columns
Alt
Shift
←
⌘
⇧
J
Open Group window
Alt
Shift
→
⌘
⇧
K
Open Ungroup window
Alt
Shift
←
⌘
⇧
J

Table

Create table
Ctrl
T
⌃
T
Select table row
Shift
Space
⇧
Space
Select table column
Ctrl
Space
⌃
Select table
Ctrl
A
⌘
A

Visual formatting

Open Format Cells window (last active tab)
Ctrl
1
⌘
1
Open Format Cells window (font tab)
Ctrl
Shift
F
Apply most recently used format
F4
⌃
Y
Make text bold
Ctrl
B
⌘
B
Make text italic
Ctrl
I
⌘
I
Underline text
Ctrl
U
⌘
U
Strikethrough text
Ctrl
5
⌘
⇧
X
Apply outside borders
Ctrl
Shift
&
⌘
⌥
0
Remove borders
Ctrl
Shift
_
⌘
⌥
_

Workbooks and worksheets

Insert new worksheet
Shift
F11
⇧
F11
Go to next worksheet
Ctrl
PgDn
Fn
⌃
↓
Go to previous worksheet
Ctrl
PgUp
Fn
⌃
↑
Move to next pane
F6
F6
Move to previous pane
Shift
F6
⇧
F6
Move to next workbook
Ctrl
Tab
⌃
Tab
Move to previous workbook
Ctrl
Shift
Tab
⌃
⇧
Tab
Minimize current workbook
Ctrl
F9
⌘
M
Maximize current workbook
Ctrl
F10
Restore down current workbook
Ctrl
F5
Select adjacent worksheets
Shift
click
⇧
click
Select non-adjacent worksheets
Ctrl
click
⌘
click
Insert macro sheet
Ctrl
F11

Pivot tables

Select entire pivot table
Ctrl
A
⌘
A
Check table field
Space
Space
Group pivot table items
Alt
Shift
→
⌘
⇧
K
Ungroup pivot table items
Alt
Shift
←
⌘
⇧
J
Hide pivot table item
Ctrl
–
Ctrl
–
Create pivot chart on same worksheet
Alt
F1
Create pivot chart on new worksheet
F11
Fn
F11

Other

Open Spelling window
F7
F7
Open Thesaurus
Shift
F7
⇧
F7
Open Macro window
Alt
F8
Fn
⌥
F8
Open VBA Editor
Alt
F11
Fn
⌥
F11
Snap to grid
Alt
⌘
Hide or show objects
Ctrl
6
⌃
6
Open Style window
Alt
“
⌘
⇧
L
Display contextual menu
Shift
F10
Fn
⇧
F10
Display contextual menu (fn)
Fn
Display control menu
Alt
Space
?
Post Views: 2,717