About this lesson
Utilize the keyboard or mouse to select cells and ranges in a spreadsheet.
Download this lesson’s exercise file.Navigating the Interface.xlsx
Navigating the Excel Interface.
When to use
Selecting cells and ranges in the Excel interface.
Selecting cells with the mouse
- To select a single cell, just click on it
- To select multiple contiguous cells, left-click the first cell, and drag to the last one you want to include in the range
- To select non-contiguous cells, left-click the first cell, hold down the CTRL key and click each other cell you’d like to select
On a Mac: hold down the ⌘ (Command) key and click each other cell you’d like to select.
Selecting cells with the keyboard
- To select a single cell, use the arrow keys to navigate to it
- To select multiple contiguous cells, select the first cell, hold down the SHFT key, and arrow to the last one you want to include in the range
- Unfortunately, selecting non-contiguous cells cannot be done without the use of the mouse
Tab and Enter Functionality
- Pressing Enter will move you one cell down
- Pressing Tab will move you one cell to the right
- Pressing Enter AFTER PRESSING TAB will move you to the cell immediately below the cell you started tabbing from
- Right-click the Column header (column letter) or Row number and choose Delete to remove a column or row
- Right-click the Column header (column letter) or Row number and choose Insert to insert a column or row
- In the QAT, the arrow that points to the left is the Undo arrow
- Clicking Undo will revert the last change in the “undo stack”
- Undo can also be triggered by pressing CTRL+Z (or ⌘+Z on a Mac)
Lesson notes are only available for subscribers.