Excel Shortcuts

Question 1

Highlight and Delete entire column

Answer 1

CRTL and Spacebar
CRTL and - (minus)

Question 2

Highlight and Delete entire row

Answer 2

Shift and Spacebar
CRTL and - (minus)

Question 3

Jump to next cell with something in it

Answer 3

CRTL and Arrow

Question 4

Forward a sheet tab

Answer 4

CRTL and Pg Dn

Question 5

Back a sheet tab

Answer 5

CRTL and Pg Up

Question 6

Copy down the cells from above

Answer 6

CRTL and D

Question 7

Copy cells to right

Answer 7

CRTL and R

Question 8

Sum up a column above

Answer 8

ALT and +

Question 9

Paste values

Answer 9

ALT + E + S + V

Question 10

Resize Columns

Answer 10

ALT HOI

Question 11

Resize rows

Answer 11

ALT HOA

Question 12

Wrap Text

Answer 12

ALT HW

Question 13

Increase Font Size

Answer 13

ALT HFG

Question 14

Decrease Font Size

Answer 14

ALT HFK

Question 15

Access ‘Styles’

Answer 15

Alt HJ

Question 16

Open Pivot Table

Answer 16

ALT DP

Question 17

Add ‘All Borders’

Answer 17

ALT HBA

Question 18

Change Cell colour

Answer 18

ALT HH arrows

Question 19

Center cell contents

Answer 19

ALT HAC

Question 20

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

Answer 20

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

Question 21

Display Insert Dialog Box

Answer 21

CRTL SHIFT +

Question 22

Hide Row

Answer 22

CRTL 9

Question 23

Hide Columns

Answer 23

CRTL 0

Question 24

Unhide Row

Answer 24

CRTL SHIFT 9

Question 25

Unhide Column

Answer 25

CRTL SHIFT 0