Microsoft Office

Excel Shortcuts

Productivity shortcuts for Word, Excel, PowerPoint

Bold

Formatting

Make selected text bold

Windows:
Ctrl+
B
Click to view details →

Italic

Formatting

Make selected text italic

Windows:
Ctrl+
I
Click to view details →

Underline

Formatting

Underline selected text

Windows:
Ctrl+
U
Click to view details →

Merge Cells

Formatting

Merge selected cells into one

Windows:
Alt+
H+
M+
C
Click to view details →

Center Align

Formatting

Center align cell content

Windows:
Alt+
H+
A+
C
Click to view details →

Go to Cell

Navigation

Navigate directly to specific cell

Windows:
Ctrl+
G
Click to view details →

Find and Replace

Edit

Find and replace text

Windows:
Ctrl+
H
Click to view details →

Insert Row

Insert

Insert row above selected row

Windows:
Ctrl+
Shift+
+
Click to view details →

Insert Column

Insert

Insert column to left of selected column

Windows:
Ctrl+
Shift+
+
Click to view details →

Delete Row

Edit

Delete selected row

Windows:
Ctrl+
-
Click to view details →

Delete Column

Edit

Delete selected column

Windows:
Ctrl+
-
Click to view details →

AutoSum

Data

Auto calculate sum of selected range

Windows:
Alt+
=
Click to view details →

Format Cells

Formatting

Open Format Cells dialog

Windows:
Ctrl+
1
Click to view details →

Insert Chart

Insert

Create chart from selected data

Windows:
F11
Click to view details →

Freeze Panes

View

Freeze panes above and left of selected cell

Windows:
Alt+
W+
F+
F
Click to view details →

Insert Function

Data

Open Insert Function dialog

Windows:
Shift+
F3
Click to view details →

Auto Calculate

Data

Recalculate worksheet

Windows:
F9
Click to view details →

Absolute Reference

Data

Toggle cell reference to absolute

Windows:
F4
Click to view details →

Fill Down

Edit

Copy selected cells down

Windows:
Ctrl+
D
Click to view details →

Fill Right

Edit

Copy selected cells right

Windows:
Ctrl+
R
Click to view details →

Fill Series

Data

Create series data

Windows:
Ctrl+
Shift+
L
Click to view details →

Data Validation

Data

Open Data Validation dialog

Windows:
Alt+
D+
L
Click to view details →

Conditional Formatting

Formatting

Apply conditional formatting

Windows:
Alt+
H+
L
Click to view details →

Remove Duplicates

Data

Remove duplicate data

Windows:
Alt+
A+
M
Click to view details →

Sort Ascending

Data

Sort selected range in ascending order

Windows:
Alt+
A+
S+
A
Click to view details →

Sort Descending

Data

Sort selected range in descending order

Windows:
Alt+
A+
S+
D
Click to view details →

Filter

Data

Apply or remove filter

Windows:
Ctrl+
Shift+
L
Click to view details →

Pivot Table

Data

Create pivot table

Windows:
Alt+
N+
V
Click to view details →

Chart Wizard

Insert

Open Chart Wizard

Windows:
Alt+
N+
C
Click to view details →

Insert Table

Insert

Insert table

Windows:
Ctrl+
T
Click to view details →

Name Manager

Data

Open Name Manager dialog

Windows:
Ctrl+
F3
Click to view details →

Go to Special

Navigation

Select special cells

Windows:
Ctrl+
G → Special
Click to view details →

Hide Columns

View

Hide selected columns

Windows:
Ctrl+
0
Click to view details →

Hide Rows

View

Hide selected rows

Windows:
Ctrl+
9
Click to view details →

Unhide Columns

View

Show hidden columns

Windows:
Ctrl+
Shift+
0
Click to view details →

Unhide Rows

View

Show hidden rows

Windows:
Ctrl+
Shift+
9
Click to view details →

Group Columns

Data

Group selected columns

Windows:
Alt+
Shift+
Click to view details →

Group Rows

Data

Group selected rows

Windows:
Alt+
Shift+
Click to view details →

Ungroup

Data

Ungroup grouped items

Windows:
Alt+
Shift+
Click to view details →

Subtotal

Data

Insert subtotals

Windows:
Alt+
A+
B
Click to view details →

Outline

View

Show or hide outline

Windows:
Alt+
A+
O
Click to view details →

Data Table

Data

Create data table

Windows:
Alt+
A+
W+
T
Click to view details →

Scenario Manager

Data

Open Scenario Manager

Windows:
Alt+
A+
W+
S
Click to view details →

Goal Seek

Data

Run Goal Seek

Windows:
Alt+
A+
W+
G
Click to view details →

Solver

Data

Open Solver

Windows:
Alt+
A+
W+
V
Click to view details →

Data Analysis

Data

Open Data Analysis tools

Windows:
Alt+
A+
W+
D
Click to view details →

Macro Recorder

Tools

Start/stop macro recording

Windows:
Alt+
T+
M+
R
Click to view details →

Visual Basic Editor

Tools

Open Visual Basic Editor

Windows:
Alt+
F11
Click to view details →

Add-ins

Tools

Manage add-ins

Windows:
Alt+
T+
I
Click to view details →

Options

Tools

Open Excel options

Windows:
Alt+
F+
T
Click to view details →