Extend Selection

Question 1

Extend selection right

Answer 1

SHIFT + >

Question 2

Extend Selection left

Answer 2

SHIFT + <

Question 3

Extend selection up

Answer 3

SHIFT + ^

Question 4

Extend selection down

Answer 4

SHIFT + (down arrow)

Question 5

Extend the selection to the last cell on the right that contains data, or to the next cell that contains data, or to the last column

Answer 5

CTRL + SHIFT + >

Question 6

Extend the selection to the last cell on the left that contains data, or to the next cell that contains data, or to the first column

Answer 6

CTRL + SHIFT + <

Question 7

Extend the selection to the last cell up that contains data, or to the next cell that contains data, or to the first row

Answer 7

CTRL + SHIFT + ^

Question 8

Extend th e selection to the last cell that contains data, or to the next cell that contains data, or to the last row

Answer 8

CTRL + SHIFT + (down arrow)

Question 9

Extend selection up one screen

Answer 9

SHIFT + PgUp

Question 10

Extend selection down one screen

Answer 10

SHIFT+ PgDn

Question 11

Extend selection right one screen

Answer 11

ALT + SHIFT + PgDn

Question 12

Extend selection left one screen

Answer 12

ALT + SHIFT + PgUp

Question 13

Extend selection to start of row(s)

Answer 13

SHIFT + HOME

Question 14

Extend selection to first cell in worksheet

Answer 14

CTRL + SHIFT + HOME

Question 15

Extend selection to last cell in worksheet

Answer 15

CTRL + SHIFT + End

Question 16

Toggle ‘Extend Selection’ mode

Answer 16

F8

Question 17

Cancel ‘Extend Selection’ mode

Answer 17

Esc