About this lesson
Utilize the keyboard or mouse to select cells and ranges in a spreadsheet.
Multiple versions of this lesson are available, choose the appropriate version for you:
Download the Excel workbook used in the video tutorial and try the lesson yourself.Navigation.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
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
Lesson notes are only available for subscribers.