Selection Shortcuts

Question 1

Select Current Region (Possibly Entire Worksheet)

Answer 1

Ctrl + A

Question 2

Select Visible Cells Only

Answer 2

Alt + ;

Question 3

Select Cells With Comments

Answer 3

Ctrl + Shift + O

Question 4

Display ‘Go To’ Dialog Box

Answer 4

Ctrl + G

Question 5

Select Region Directly Around Active Cell

Answer 5

Ctrl + Shift + *

Question 6

Select Current Array

Answer 6

Ctrl + /

Question 7

Select Row Differences

Answer 7

Ctrl + \

Question 8

Select Column Differences

Answer 8

Ctrl + Shift + |

Question 9

Select All Precedents

Answer 9

Ctrl + Shift + {

Question 10

Select All Dependents

Answer 10

Ctrl + Shift + }

Question 11

Select Direct Precedents

Answer 11

Ctrl + [

Question 12

Select Direct Dependents

Answer 12

Ctrl + ]