Excel Short-cuts

Question 1

Time

Answer 1

Ctrl-:

Question 2

Select row of active cell

Answer 2

Shift-space bar

Question 3

Cycle through open Excel files backwards (other direction)

Answer 3

Ctrl-shift-tab

Question 4

Personal macro workbook file name

Answer 4

Personal.xlsb

Question 5

Close Excel and all open workbooks

Answer 5

Alt-F4

Question 6

Change sheets

Answer 6

Ctrl-page down

Question 7

Cycle through sheets other direction

Answer 7

Ctrl-page up

Question 8

Open the VBE

Answer 8

Alt-F11

Question 9

Select a recently used file to open

Answer 9

Alt, f, r

Question 10

Cycle through open Excel files

Answer 10

Ctrl-tab

Question 11

Redo

Answer 11

Ctrl-y

Question 12

To evaluate an expression in the Immediate window, precede the expression with a _____ .

Answer 12

?

”?” is a shortcut for Print

Question 13

Execute a procedure when the cursor is located in the procedure (shortcut)

Answer 13

F5

Question 14

Go to cell A1

Answer 14

Ctrl-home

Question 15

Select column of active cell

Answer 15

Ctrl-space bar

Question 16

Activate the Immediate window

Answer 16

Ctrl-g

Question 17

Move to end of continuous data

Answer 17

Ctrl-arrow keys

Question 18

Undo

Answer 18

Ctrl-z

Question 19

Display pop-up key tips

Answer 19

Alt

Question 20

Hide row of active cell(s)

Answer 20

Ctrl-9

Question 21

Close workbook

Answer 21

Ctrl-w

Question 22

Move to farthest cell

Answer 22

Ctrl-end

Question 23

Insert new row or column

Answer 23

Ctrl-shift-=

Question 24

Select block of data

Answer 24

Ctrl-shift-end

Question 25

Date

Answer 25

Ctrl-;

Question 26

Run a macro

Answer 26

Alt-F8

Question 27

Hide column of active cell

Answer 27

Ctrl-0

Question 28

Save

Answer 28

Ctrl-s