Excel hotkeys/shortcuts

Function

Shortcut

CTRL+I

Apply / remove underlining

CTRL+U

Start of a row

HOME

Apply / remove strikethrough

CTRL+5

A:1 position

CTRL+HOME

Apply / remove bold formatting

CTRL+B

Next cell (top to bottom)

ENTER

Insert hyperlink

CTRL+K

Next cell (left to right)

TAB

Display Format Cells dialog box (w/ Font

tab selected)

CTRL+1 or CTRL+SHIFT+P, or
CTRL+SHIFT+F

Previous cell (bottom to top)

SHIFT+ENTER

Apply outline border to selected cells

CTRL+SHIFT+7

Previous cell (right to left)

SHIFT+TAB

Remove outline border from selected cells

CTRL+SHIFT+_ (underline)

Edge of current data region

CTRL+Arrow keys

Hide selected rows

CTRL+9

Last used cell in worksheet

CTRL+END

Unhide hidden rows in the selection

CTRL+SHIFT+( (open parenth.)

F8 (use arrow keys / mouse to
extend selection)

One screen to the right / left

ALT+PG UP / PG DOWN

Unhide hidden columns in selection

Extend selection by one cell
Apply General number format (12)
Extend selection to last nonblank cell in
Sp same column / row as active cell
Apply Currency format ($12.00)
Extend selection to beginning of row
Apply Percentage format (12%)
Extend selection to beginning of worksheet

CTRL+0
SHIFT+F8
CTRL+SHIFT+) (close parenth.)
SHIFT+Arrow key

Move to:

Ex
ce
l
na
vi
ga
tio
n

Select:
Clockwise to next corner of range
First cell in the row

HOME

Previous / next worksheet

CTRL+PG UP / DOWN

Only active
(collapse
selection)
Move
/ Copycell
selected
worksheet(s)

SHIFT+BACKSPACE
CTRL+ drag to location (copy)
or ALT+E+M (move), ALT+C
(copy)
CTRL+SHIFT+8

CTRL+SHIFT+~
CTRL+SHIFT+Arrow key
CTRL+SHIFT+$
SHIFT+HOME
CTRL+SHIFT+%
CTRL+SHIFT+HOME

CTRL+ . (period)

Region
Next workbook
Current region (press 1x), region /
summary rows (press 2x), entire
worksheet (press 3x)
Next windows application
Current region around the active cell
Next / previous pane in split
worksheet

CTRL+F6
CTRL+SHIFT+SPACEBAR
ALT+TAB
CTRL+SHIFT+* (asterisk)

Apply Date format (12-Jan-00)

Extend selection to last used cell in
worksheet

CTRL+SHIFT+#

Apply # format w/ 000s separator, 2

decimals (12.00)

CTRL+SHIFT+!

Occupied cells in current range (press

1x); all cells in worksheet (press 2x)
Group rows / columns
Entire row

SHIFT+SPACEBAR

Enter the euro symbol

ALT+0128 (On Number Pad)

Ungroup rows / columns

ALT+A+U+U / SHIFT+ALT+

Extend selection down / up one screen

CTRL+SHIFT+END

SHIFT+PG DOWN / UP

Enter the pound sterling symbol

ALT+0163 (On Number Pad)

Help
Enter the yen symbol

F1
ALT+0165 (On Number Pad)

Start a new line in the same cell

Display Windows Start Menu
Insert current date in cell

ALT+ENTER
CTRL+ESC
CTRL+; (semi-colon)

Delete character left / right

Show/hide Ribbon
Page Set-up

BACKSPACE / DELETE
CTRL+F1
ALT+P (follow key tips)

Delete text to the end of the line

Switch between worksheet, Ribbon, task
Print Preview
Pr pane,
Zoom (and split panes if appl)

int
in Cut / Copy / Paste
Ribbon tabs / show key tips
g Activate
Set Print Area

En
ter
/
ed
it
da
ta

Function

Apply / remove italic formatting

For Turn extend mode on / off

ma
t Hide selected columns
dat
a Add another range of cells to selection

ec
ial
se
le
ct
co
m
m
an
ds

Shortcut

CTRL+DELETE
F6 (use TAB, SHIFT+TAB , or
CTRL+F2
arrow keys to move b/t tabs)

F6 / SHIFT+F6
CTRL+A
ALT+A+G+G / SHIFT+ALT+

Entire column

CTRL+SPACEBAR

Insert row or column

CTRL+SHIFT+ (plus sign) /

Ta
Entire worksheet
bl
es
Delete row or column
,
Li Create
chart
new sheet / active sheet
Lasta cell
in in
a worksheet
st
Sel
Change data into a table
s,
ect
Et
co
next // previous
chart in workbook
Current
next worksheet
Ch
c. Select
m
Turn Auto Filters on/off (column
art
ma
headers)
s
nd
s Create
column
chart ofworksheet
selected data on
Current
/ previous
current worksheet
Define a range name

CTRL+SHIFT+SPACEBAR
CTRL+- (minus sign)
F11 or ALT+F1
CTRL+END
CTRL+T
CTRL+ PG DOWNDOWN
/ UP
CTRL+SHIFT+PG
CTRL+SHIFT+L
ALT+F1
CTRL+SHIFT+PG
UP
CTRL+F3

CTRL+X / CTRL+C / CTRL+V

F10 or ALT
ALT+P+R+S

StartVisible
a formula
cells

Copy / Paste Special Formats

Show shortcuts / simulate right-click
Print

CTRL+C, CTRL+ALT+V; or
ALT+H+V (follow key tips)
SHIFT+F10
CTRL+P

Edit Unequal
active cell
cells

F2
CTRL +SHIFT + \

Undo
Show Office Clipboard

CTRL+Z (ALT+2)
CTRL+C followed by CTRL+C

Anchor
cell
/ switch
to comments
absolute reference
Cells
that
contain

F4 (While in Cell (letter

Edit) O)
CTRL+SHIFT+O

Redo
Open Control menu

CTRL+Y (ALT+3)
ALT+SPACEBAR

In selected
cells
don'tbar
match
Cancel
entry in row,
the cell
orthat
formula
value in active cell

ESC
CTRL+\

Repeat last action

Show shortcuts

F4 or CTRL+Y
SHIFT+F10 (same as right-click)

AutoSum
values above
Array containing
thecell
active cell

ALT+= (equal sign)

CTRL+/

Find
Start new workbook

CTRL+F or SHIFT+F5
CTRL+N

directly
by formulas
In a Cells
formula,
showreferenced
Insert Function
dialog
theWizard)
selection
box in
(aka

SHIFT+F3
(can also
click 'fx')
CTRL+[
(opening
bracket)

CTRL+H
CTRL+O

Cells
directly
ordialog
indirectly
Open
Paste
Name
boxreferenced
by formulas in the selection

F3
CTRL+SHIFT+{
(opening brace)

N
av Find & Replace
ig Open a workbook
ati

Create range names from text labels

= (equal
ALT
+ ; sign)
CTRL+SHIFT+F3

Excel hotkeys/shortcuts
Key

Alone

F1

Help

Shift

Ctrl

F2
F3

Edit Mode
Paste Name Formula

Edit Comment
Insert Function

Define Name

F4
F5

Repeat Action
Go To

Find Again
Find

Close Window
Restore Window Size

F6

Prev Toggle Ribbon,

Pane, Sheet, Zoom

Next Workbook

F7

Toggle Ribbon, Pane,

Sheet, Zoom (Split Pane)
Spell Check

F8
F9

Extend Selection
Calculate All

Add To Selection
Calculate Worksheet

Resize Window
Minimize Workbook

F10
F11

Activate Ribbon / key tips

New Chart

Same as right-click
New Worksheet

Restore Workbook
New Macro Sheet

F12
A

Save As

Save As

Open
Select All

Alt

Shift Ctrl

Insert Chart Sheet

Save As
Names From Labels
Quit Excel

Prev Workbook

Move Window
Macro List

VB Editor
Print
Formula Arguments

B
C

Bold
Copy

D
E

Fill Down

Data Menu
Edit Menu

F
G

Find
Goto

File Menu

H
I

Replace
Italics

Help Menu
Insert Menu

J
K

Insert Hyperlink

Font Name

L
M
N
O

New Workbook
Open Workbook

P
Q

Print

R
S

Fill Right
Save

T
U

Underline

V
W

Paste
Close Workbook

X
Y

Cut
Repeat Active

Z
` (~)

Undo
Toggle Formula / Values

General Format

1 (!)
2 (@)

Cell Format
Toggle Bold

Number Format
Time Format

3 (#)
4 ($)

Toggle Italics
Toggle Underline

Date Format
Currency Format

5 (%)
6 (^)

Toggle Strikethru

Percent Format
Exponent Format

Format Menu

Select Comments
Font Size

Tools Menu

Window Menu

7 (&)
8 (*)

Outline Symbols

Apply Border
Select Region

9 (()
0 ())

Hide Rows
Hide Columns

Unhide Rows
Unhide Columns