ALT + O + C + A Fit Column Width F2 Edit Cells Navigation ...

[Pages:1]EXCEL SHORTCUT LIST

Formatting Shortcuts

CTRL + 1

Format Box

ALT + E + S + T

Copy Format

ALT + H + 0 ALT + H + 9

Increase Decimal Decrease Decimal

CTRL + SHIFT + 7 Boxing

ALT + O + C + A ALT + H + O + R

Fit Column Width Change Tab Name

ALT + W + F

(Un)Split Panes

ALT + W + S SHIFT + CTRL + #

(Un)freeze windows Date Format

SHIFT + CTRL + $ $ Dollar Format

SHIFT + CTRL + % % Percentage Format

ALT + "="

Sum Function

CTRL Shortcuts

CTRL + A

Select All

CTRL + B CTRL + C

Bold Copy

CTRL + D

Fill Down

CTRL + F CTRL + I

Find Italic

CTRL + N

New Workbook

CTRL + O CTRL + P

Open Print

CTRL + R

Fill Right

CTRL + S CTRL + U

Save Workbook Underline

CTRL + V

Paste

CTRL + W

Close Window

CTRL + X

Cut

CTRL + Z

Undo

Function Key Shortcuts

F2

Edit Cells

F4

Anchor Cells

F7

Spell Check

F12 SHIFT + F2

Save As Insert a Comment

SHIFT + F8

Add to Selection

SHIFT + F10 CTRL + F3

Right Click Name a Cell

Windows Flag + D

Minimize Programs

Navigation Shortcuts

Arrows CTRL + Arrows SHIFT + Arrows CTRL + SHIFT + Arrows ALT + Tab CTRL + Pg Up/Down Enter Shift + Enter Home CTRL + Home ESC Alt + Enter (when in a cell)

Move Go to End of Continuous Range Select A Cell Range Highlight A Continuous Range Switch Programs Switch Worksheets Move below Move Up Move to Beginning of Line Go to Cell A1 Cancel Add a Line

Columns & Rows Shortcuts

CTRL + 9 SHIFT + CTRL + 9 CTRL + 0 SHIFT + CTRL + 0 SHIFT + Spacebar

Hide Row Unhide Row Hide Column Unhide Column Highlight Row

CTRL + Spacebar

Highlight Column

SHIFT + CTRL + Plus sign Insert Blank Cells

CTRL + Minus Sign

Delete Selected Cells

SHIFT + ALT + Left Arrow Group Rows/Columns

SHIFT + ALT + Right Arrow Ungroup Rows/Columns

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download