Navigation & Selection

Question 1

Switch between applications

Answer 1

Alt + Tab

Question 2

Switch between open Excel workbooks

Answer 2

Ctrl + Tab

Question 3

Go to PREVIOUS worksheet

Answer 3

Ctrl + Page Up

Question 4

Go to NEXT worksheet

Answer 4

Ctrl + Page Down

Question 5

Go to next or last filled cell in a Row (Left or Right)

Answer 5

Ctrl + Arrow

Question 6

Go to next or last filled cell in a Column (Up or Down)

Answer 6

Ctrl + Arrow

Question 7

Go to the first visible cell (typically A1) of the worksheet

Answer 7

Ctrl + Home

Question 8

Go to the intersection of last used row and column the worksheet

Answer 8

Ctrl + End

Question 9

Select the entire Row

Answer 9

Shift + Space

Question 10

Select the entire Column

Answer 10

Ctrl + Space

Question 11

Select a contiguous range around the active cell OR Select entire Worksheet

Answer 11

Ctrl + A

Question 12

Extend selection by one cell in a Row / Column (Works inside cell in Edit (F2) mode)

Answer 12

Shift + Arrow

Question 13

Extend selection to the last Blank / Non-blank cell in the same Row / Column

Answer 13

Ctrl + Shift + Arrow