Excel Shortcuts

ESC

Stop / Go back to live sheet

Ctrl + Shift + Arrows

Highlight Area

Ctrl + Arrows

Navigate to next blank cell

Ctrl + Home

Go to Cell A1

Ctrl + PgUp

Navigate sheet LEFT

Ctrl + PgDn

Navigate sheet RIGHT

Spacebar

Check box inside Tab / Command

Tab

From Toolbar, go INTO Sheet/Tab

Tab

Move one Cell to the RIGHT

Shift + Tab

Go back / reverse Tab

Ctrl + 1

Format Cells

Ctrl + c

Copy

Ctrl + x

Cut

Ctrl + v

Paste

Ctrl + z

Undo

Ctrl + y

Redo

Ctrl + R

Fill Right

Ctrl + D

Fill Down

Ctrl + g

Go To

Ctrl + N

Open New Workbook

F2

Activate Cell

F2, F4

Lock / Unlock cells

F4

Repeat Last Action

F5

Go To

F9

Iterate Model

F12

Save As

ALT, w, Q

Zoom

ALT, o, c, a

Format Column Autofit

ALT, o, c, w

Format Column Width

ALT, T, O

Tools, Options (Manual Iterations)

ALT, i, R

Insert Row (above)

ALT, i, c

Insert Column (to the left)

Ctrl + B

Bold

Ctrl + i

Italicize

Ctrl + c then ALT, e, s

Copy, Edit, Paste Special

Ctrl + c then ALT, e, s, f

Copy, Edit, Paste Special, Formula

Ctrl + c then ALT, e, s, v

Copy, Edit, Paste Special, Value

Ctrl + c then ALT, e, s, t

Copy, Edit, Paste Special, Format

Ctrl + c then ALT, e, s, c

Copy, Edit, Paste Special, Comment

Custom % Format

0.0%;(0.0%)

BLUE

Hardcode / Input

BLACK

Equation

GREEN

Link