Advanced Excel Shortcuts

A

1

Alt, N, V, T

Create Pivot Table

2

Ctrl + K

Add hyperlink

3

Alt + "="

Auto sum

4

Alt, H, O, R

Rename sheet

B

1

Ctrl + Shift + U

Expand or collapse formula bar

2

Alt, A, M

Remove Duplicates

3

Ctrl + ;

Today's Date

4

Alt + Shift + Left

Alt + Shift + Right

Ungroup columns

Group columns

C

1

Alt, E, L

Delete worksheet

2

Alt, A, H

Alt, A, J

Minimise / Expand Grouping

3

Alt, H, O, I

Auto fit column width

4

Alt, A, S, A

Alt, A, S, D

Sort ascending

Sort descending

D

1

Alt, H, H

Fill Colour

2

Ctrl + :

Current time

3

Alt, W, F

Freeze panes

4

Alt + ;

Select visible cells only