From Wikibooks, open books for an open world
| To select
|
Do this (If you are left-handed use Right click in place of Left
|
| a single cell |
Left click on it
|
| a range of adjacent cells |
Drag from the first cell to the last cell, or click on the first cell, hold the Shift key and click on the last cell (scrolling if necessary)
|
| non-adjacent cells or ranges |
Hold CTRL (Windows) or Command (Mac) key and click or drag
|
| an entire row or column |
Left click on the row or column heading
|
| all cells |
Left click on the blank header in the upper left corner
|
| the next cell to the right |
Use the Tab key
|
| the next cell down the column |
Use the Enter key
|
| the A1 Home cell |
Press Ctrl + Home keys together
|
| the last cell in a sheet |
Press Ctrl + End keys together
|
| the cells around the active cell |
Press Ctrl + Shift + 8 keys together (Select Region)
|
