Excel Keyboard Shortcuts Library

Question 2

Displays the Insert dialog box to insert blank cells.

Answer 2

CTRL+SHIFT+Plus (+)

Question 3

Displays the Delete dialog box to delete the selected cells.

Answer 3

CTRL+Minus (-)

Question 4

Alternates between displaying cell values and displaying formulas in the worksheet.

Answer 4

CTRL+`

Question 5

Copies a formula from the cell above the active cell into the cell or the Formula Bar.

Answer 5

CTRL+’

Question 6

Moves to the edge of the current data region in a worksheet.

Answer 6

CTRL+ARROW KEY

Question 7

Extends the selection of cells by one cell.

Answer 7

SHIFT+ARROW KEY

Question 8

Extends the selection of cells to the last nonblank cell in the same column or row as the active cell, or if the next cell is blank, extends the selection to the next nonblank cell.

Answer 8

CTRL+SHIFT+ARROW KEY

Question 9

Selects an entire column in a worksheet.

Answer 9

CTRL+SPACEBAR

Question 10

Selects an entire row in a worksheet. – If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. Pressing CTRL+SHIFT+SPACEBAR a second time selects the current region and its summary rows. Pressing CTRL+SHIFT+SPACEBAR a third time selects the entire worksheet.

Answer 10

SHIFT+SPACEBAR