Selecting cells, rows, and columns in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

How do you select a single cell in Excel?

Click on the cell with your mouse or use arrow keys to move the selection to the cell.

beginner

What is the shortcut to select an entire row in Excel?

Click the row number on the left or press Shift + Spacebar to select the entire row.

beginner

How can you select multiple adjacent columns?

Click the first column letter, hold down Shift, then click the last column letter you want to select.

intermediate

How do you select non-adjacent cells or ranges?

Hold down the Ctrl key (Cmd on Mac) and click each cell or drag to select ranges you want.

beginner

What happens when you click the top-left corner button (above row 1 and left of column A)?

It selects the entire worksheet, all rows and columns at once.

Which key do you hold to select multiple non-adjacent cells?

A Shift

B Tab

C Ctrl (Cmd on Mac)

D Alt

Hold Ctrl (Cmd on Mac) to select multiple cells or ranges that are not next to each other.

What shortcut selects the entire column of the active cell?

A Ctrl + Spacebar

B Shift + Spacebar

C Ctrl + A

D Alt + Spacebar

Ctrl + Spacebar selects the entire column of the current cell.

How do you select all cells in a worksheet quickly?

A Click the first cell and drag to the last cell

B Press Ctrl + A twice

C Press Shift + Ctrl + End

D Click the top-left corner button

Clicking the top-left corner button (above row 1 and left of column A) selects the entire worksheet.

To select multiple adjacent rows, you should:

A Hold Ctrl and click each row number

B Click the first row number, hold Shift, then click the last row number

C Click and drag across columns

D Double-click a row number

Hold Shift and click the first and last row numbers to select all rows in between.

Which of these is NOT a way to select a cell?

A Press Ctrl + C

B Use arrow keys to move the selection

C Click the cell with the mouse

D Type the cell address in the Name Box and press Enter

Ctrl + C copies the selected cell; it does not select a cell.

Explain how to select multiple non-adjacent cells or ranges in Excel.

Think about how to pick cells that are not next to each other.

Describe the steps to select an entire row and an entire column using keyboard shortcuts.

Remember the difference between row and column shortcuts.