Excel Shortcuts Flashcards

1
Q

Highlight and Delete entire column

A

CRTL and Spacebar
CRTL and - (minus)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Highlight and Delete entire row

A

Shift and Spacebar
CRTL and - (minus)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Jump to next cell with something in it

A

CRTL and Arrow

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Forward a sheet tab

A

CRTL and Pg Dn

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Back a sheet tab

A

CRTL and Pg Up

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Copy down the cells from above

A

CRTL and D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Copy cells to right

A

CRTL and R

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Sum up a column above

A

ALT and +

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Paste values

A

ALT + E + S + V

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Resize Columns

A

ALT HOI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Resize rows

A

ALT HOA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Wrap Text

A

ALT HW

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Increase Font Size

A

ALT HFG

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Decrease Font Size

A

ALT HFK

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Access ‘Styles’

A

Alt HJ

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Open Pivot Table

A

ALT DP

17
Q

Add ‘All Borders’

A

ALT HBA

18
Q

Change Cell colour

A

ALT HH arrows

19
Q

Center cell contents

A

ALT HAC

20
Q

Difference between CRTL SHIFT Arrow, and Shift ARROW and CRTL arrow

A

CRTL SHIFT Arrow - extend selection to end
Shift Arrow - select current and one across
CRTL Arrow

21
Q

Display Insert Dialog Box

A

CRTL SHIFT +

22
Q

Hide Row

A

CRTL 9

23
Q

Hide Columns

A

CRTL 0

24
Q

Unhide Row

A

CRTL SHIFT 9

25
Q

Unhide Column

A

CRTL SHIFT 0

26
Q
A