Excel Shortcuts Flashcards
1
Q
Highlight and Delete entire column
A
CRTL and Spacebar
CRTL and - (minus)
2
Q
Highlight and Delete entire row
A
Shift and Spacebar
CRTL and - (minus)
3
Q
Jump to next cell with something in it
A
CRTL and Arrow
4
Q
Forward a sheet tab
A
CRTL and Pg Dn
5
Q
Back a sheet tab
A
CRTL and Pg Up
6
Q
Copy down the cells from above
A
CRTL and D
7
Q
Copy cells to right
A
CRTL and R
8
Q
Sum up a column above
A
ALT and +
9
Q
Paste values
A
ALT + E + S + V
10
Q
Resize Columns
A
ALT HOI
11
Q
Resize rows
A
ALT HOA
12
Q
Wrap Text
A
ALT HW
13
Q
Increase Font Size
A
ALT HFG
14
Q
Decrease Font Size
A
ALT HFK
15
Q
Access ‘Styles’
A
Alt HJ