ExcelExplained

Keyboard Shortcuts

Learning Excel keyboard shortcuts can save you a lot of time in the long run. It may be difficult to remember all those combinations, but if you set a goal to learn one or two per day, you will realize that within the next two months you will master the most important ones.

Challenge yourself and start using a new shortcut today! How about using Ctrl + C (Copy) and Ctrl + V (Paste) the next time you want to copy a formula from one cell to another?

Below I’ve put together a list of over 200 Excel shortcuts, grouped into categories. If you ever need help understanding one of those shortcuts please send me a message and I will do my best to help you out.

File management

Create new workbook

Ctrl
N
N

Open workbook

Crtl
O
O

Save workbook

Ctrl
S
S

Save As

F12
S

Print file

Ctrl
P
P

Open print preview window

Ctrl
F12

Close current workbook

Ctrl
F4
W

Close Excel

Alt
F4
Q

General

Open options

Alt
F
T
,

Open help

F1
/

Undo last action

Ctrl
Z
Z

Redo last action

Ctrl
Y
Y

Copy selected cells

Ctrl
C
C

Cut selected cells

Ctrl
X
X

Paste content from clipboard

Ctrl
V
V

Repeat last action

F4
Y

Display the Paste Special dialog box

Ctrl
Alt
V
V

Display find and replace box

Ctrl
F
F

Display find and replace, replace selected box

Ctrl
H
H

Find next match

Ctrl
F4
G

Find previous match

Ctrl
Shift
F4
G

Create embedded chart

Alt
F1
Fn
F1

Create chart in a new worksheet

F11
Fn
F11

Ribbon

Expand or collapse ribbon

Ctrl
F1
R

Activate ribbon access keys

Alt

Change to next ribbon control

Tab
Tab

Activate selected control

Space
Space

Confirm control change

Enter
Return

Help related to the selected control

F1

Navigation

Move one cell right

Move one cell left

Move one cell up

Move one cell down

Move one screen to the right

Alt
Pg Dn
Fn

Move one screen to the left

Alt
Pg Up
Fn

Move one screen up

Pg Up
Fn

Move one screen down

Pg Dn
Fn

Move to right edge of data section

Ctrl

Move to left edge of data section

Ctrl

Move to top edge of data section

Ctrl

Move to bottom edge of data section

Ctrl

Move to the beginning of row

Home
Fn

Move to last the cell in worksheet

Ctrl
End
Fn

Move to the first cell in worksheet

Ctrl
Home
Fn

Turn End mode on

End
Fn

Go back to hyperlink

Ctrl
G
Enter
G
Return

Drag and Drop

Drag and cut

drag
drag

Drag and copy

Ctrl
drag
drag

Drag and insert

Shift
drag
drag

Drag and insert copy

Ctrl
Shift
drag
drag

Drag to worksheet

Alt
drag
drag

Drag to duplicate worksheet

Ctrl
drag
drag

Formulas

Toggle absolute and relative references

F4
T

Open the Insert Function Dialog Box

Shift
F3
Fn
F3

Autosum selected cells

Alt
=
T

Toggle formulas on and off

Ctrl
`
`

Insert function arguments

Ctrl
Shift
A
A

Enter array formula

Ctrl
Shift
Enter
Return

Calculate worksheets

F9
Fn
F9

Calculate active worksheet

Shift
F9
Fn
F9

Force calculate all worksheets

Ctrl
Alt
F9

Evaluate part of a formula

F9
Fn
F9

Expand or collapse the formula bar

Ctrl
Shift
U
U

Display function arguments dialog box

Ctrl
A
A

Define name

Ctrl
F3
Fn
F3

Define name using row and column labels

Ctrl
Shift
F3
Fn
F3

Paste name into formula

F3
Fn
F3

Accept function with autocomplete

Tab
Tab

Workbook

Insert new worksheet

Shift
F11
Fn
F11

Change to next worksheet

Ctrl
Pg Dn
Fn

Change to previous worksheet

Ctrl
Pg Up
Fn

Move to next pane

F6
Fn
F6

Move to previous pane

Shift
F6
Fn
F6

Go to next workbook

Ctrl
Tab
Tab

Go to previous workbook

Ctrl
Shift
Tab
Tab

Minimize current workbook window

Ctrl
F9
M

Maximize current workbook window

Ctrl
F10
Fn
F10

Select adjacent worksheets

Shift
Click
Click

Select non-adjacent worksheets

Ctrl
Click
Click

Toggle scroll lock on/off

Scr Lk
Fn
F14

Toggle full screen

Ctrl
Shift
F1
F

Selection

Select entire row

Shift
Space
Space

Select entire column

Ctrl
Space
Space

Select entire worksheet

Ctrl
A
A

Add adjacent cells to selection

Shift
Click
Click

Add non-adjacent cells to selection

Ctrl
Click
Click

Same selection in the next column

Tab

Same selection in the previous column

Tab

Move right between non-adjacent selections

Ctrl
Alt

Move left between non-adjacent selections

Ctrl
Alt

Toggle add to selection mode

Shift
F8
Fn
F8

Cancel selection

Esc
Esc

Extend Selection

Extend selection to the right

Shift

Extend selection to the left

Shift

Extend selection up

Shift

Extend selection down

Shift

Extend selection to the last cell right

Shift
Ctrl

Extend selection to the last cell left

Shift
Ctrl

Extend selection to the last cell up

Shift
Ctrl

Extend selection to the last cell down

Shift
Ctrl

Extend selection one screen up

Shift
Pg Up
Fn

Extend selection one screen down

Shift
Pg Dn
Fn

Extend selection one screen right

Alt
Shift
Pg Dn
Fn

Extend selection one screen right

Alt
Shift
Pg Up
Fn

Extend selection to beginning of the row

Shift
Home
Fn

Extend selection to first cell in the worksheet

Ctrl
Shift
Home
Fn

Extend selection to last cell in the worksheet

Ctrl
Shift
End
Fn

Toggle extend selection mode

F8
Fn
F8

Active Cell

Select only the active cell

Shift
Backspace
Delete

Show the active cell

Ctrl
Backspace
Delete

Move active cell clockwise in selection corners

Ctrl
.
.

Move active cell right in a selection

Tab
Tab

Move active cell left in a selection

Shift
Tab
Tab

Move active cell down in selection

Enter
Return

Move active cell up in selection

Shift
Enter
Return

Formatting

Format cell

Ctrl
1
1

Open Format Cells(Font tab selected)

Ctrl
Shift
F
F

Apply or remove bold formatting

Ctrl
B
B

Apply or remove underline formatting

Ctrl
U
U

Apply or remove italic formatting

Ctrl
I
I

Apply or remove strikethrough formatting

Ctrl
5
X

Add or remove the shadow font style

W

Add or remove the outline font style

D

Align center

Alt
H
A
C
E

Align left

Alt
H
A
L
L

Align right

Alt
H
A
R
R

Increase indent

Alt
H
6
Tab

Decrease indent

Alt
H
5
Tab

Number Formatting

Apply general format

Ctrl
Shift
~
~

Apply currency format

Ctrl
Shift
$
$

Apply percentage format

Ctrl
Shift
%
%

Apply scientific format

Ctrl
Shift
^
^

Apply date format

Ctrl
Shift
#
#

Apply time format

Ctrl
Shift
@
@

Apply number format

Ctrl
Shift
!
!

Cell edit mode

Edit the active cell

F2
U

Insert or edit comment

Shift
F2
Fn
F2

Cancel entry

Esc
Esc

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

Ctrl
Home
Fn

Select to end of cell

Shift
End
Fn

Delete to end of line

Ctrl
Delete
Delete

Delete character to the left

Backspace
Delete

Delete character to the right

Delete
Fn
Delete

Add new line in the same cell

Alt
Enter
Return

Select Special

Display ‘Go To’ dialog box

Ctrl
G
G

Select all cells with comments

Ctrl
Shift
O
Fn
O

Select current region

Ctrl
A
A

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

Tables and Filters

Insert table

Ctrl
T
T

Toggle Autofilter

Ctrl
Shift
L
F

Activate filter

Alt

Select table row

Shift
Space
Space

Select table column

Ctrl
Space
Space

Select entire table

Ctrl
A
A

Clear slicer filter

Alt
C
C

Toggle total row

Ctrl
Shift
T
A

Pivot Tables

Select entire pivot table

Ctrl
A
A

Toggle pivot table field checkbox

Space
Space

Group pivot table items

Alt
Shift
K

Ungroup pivot table items

Alt
Shift
J

Create pivot chart on the same worksheet

Alt
F1

Create pivot chart on a new worksheet

F11
Fn
F11

Open pivot table wizard

Alt
D
P
P

Entering data

Enter and move to cell below

Enter
Return

Enter and move to cell above

Shift
Enter
Return

Enter and move to right cell

Tab
Tab

Enter and move to left cell

Shift
Tab
Tab

Complete entry and remain in same cell

Ctrl
Enter
Return

Enter same data in all selected cells

Ctrl
Enter
Return

Insert current date

Ctrl
;
;

Insert current time

Ctrl
Shift
:
:

Copy formula from cell above

Ctrl

Copy value from cell above

Ctrl
Shift

Insert hyperlink

Ctrl
K
K

Display AutoComplete list

Alt

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

Accept and apply

Enter
Return

Check and uncheck box

Space
Space

Cancel and close the dialog box

Esc
Esc

Borders

Add or remove border right

Alt
R

Add or remove border left

Alt
L

Add or remove border top

Alt
T

Add or remove border bottom

Alt
B

Add border outline

Ctrl
Shift
&
0

Remove borders

Ctrl
Shift
_
_

Other Shortcuts

Open Spelling dialog box

F7
Fn
F7

Open Thesaurus

Shift
F7
Fn
F7

Open VBA Editor

Alt
F11
Fn
F11

Open Macro dialog box

Alt
F8
Fn
F8

Duplicate object

Ctrl
D
D

Snap to grid

Alt

Hide or show objects

Ctrl
6
6

Display Modify Cell Style dialog box

Alt
L

Show right-click menu

Shift
F10
Fn
F10

Display control menu

Alt
Space
?

Delete comment

Shift
F10
D