Intermediate Excel Shortcuts

A

1

Ctrl + %

Add Percentage

2

Ctrl + 1

Format Cells

3

When in active cell -> Alt + Enter

Insert line break in cell

4

Shift + F11

New worksheet

B

1

F2

Edit active cell

2

Alt, A, T or Ctrl + Shift + L

Filter

3

Ctrl + $

Add currency (Defaulted to £)

4

Ctrl + D

Ctrl + R

Copy and populate cells downwards

Copy and populate cells rightwards

C

1

Ctrl + "-"

Ctrl + "+"

Delete row / column

Add row / column

2

F7

Spell check

3

Ctrl + 9, Ctrl + 0

Ctrl + (, Ctrl + )

Hide row, hide column

unhide row, unhide column (if it doesn't work, use Alt, O, C, U

4

When filtered -> Alt + Down

Filter Dropdown

D

1

Ctrl + Page down

Ctrl + Page up

Navigate through worksheets (right)

Navigate through worksheets (left)

2

Ctrl + 5

Strikethrough

3

Ctrl + Spacebar

Shift + Spacebar

Select entire column

Select entire row

4

Ctrl + Alt + V, V

Paste special values