Craig Nelson
EMM111 HOME
SELECTING COLUMNS, ROWS and the WHOLE SHEET
1. Creation of simple spreadsheets to explore numeracy  
 
 
 
 
 
 
2. Graphical aspects of spreadsheets  
 
 
 
 
 
3. Functions  
 
4. Exploring Mathematical Ideas  
 
 
 
 
 
 
 

Select a column:

A

Use Shift+Click to select another column:

Hold down Shift, click on B

Or you can use Ctrl+Click to select columns that aren't side by side:

Hold down Ctrl, click on D

You can do the same for rows.

To select the Whole Sheet, click in the top corner:

You can also use the keyboard to select cells:

Arrow keys
Shift+arrow keys
Shift+spacebar (selects rows)
Ctrl+spacebar (selects columns)

 

 

l>