Frequently Used Shortcuts

Question 1

Choose a fill color

Answer 1

Alt+H, H

Question 2

Go to Insert tab

Answer 2

Alt+N

Question 3

Center align cell contents

Answer 3

Alt+H, A, C

Question 4

Add borders

Answer 4

Alt+H, B

Question 5

Delete column

Answer 5

Alt+H, D, then C

Question 6

Go to Formula tab

Answer 6

Alt+M

Question 7

Hide the selected rows

Answer 7

Ctrl+9

Question 8

Hide the selected columns

Answer 8

Ctrl+0

Question 9

Move to the previous cell in a worksheet or the previous option in a dialog box.

Answer 9

Shift+Tab

Question 10

Move to the edge of the current data region in a worksheet

Answer 10

Ctrl+arrow key

Question 11

Enter End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column.

Answer 11

End, arrow key

Question 12

Move to the last cell on a worksheet, to the lowest used row of the rightmost used column.

Answer 12

Ctrl+End

Question 13

Extend the selection of cells to the last used cell on the worksheet (lower-right corner).

Answer 13

Ctrl+Shift+End

Question 14

Move to the cell in the upper-left corner of the window when Scroll Lock is turned on.

Answer 14

Home+Scroll Lock

Question 15

Move to the beginning of a worksheet.

Answer 15

Ctrl+Home

Question 16

Move one screen down in a worksheet

Answer 16

Page dowm

Question 17

Move one screen down in a worksheet

Answer 17

Ctrl+Page down