Selecting Cells

To Select

Mouse

Keyboard

Single Cell

Click on cell

Move arrow keys to required cell

Range Of Cells

Click & drag through required cells; click 1 st cell, hold shift key, click last cell

Move to 1 st cell, hold shift key and use arrow keys to move to last cell

Row

Click on row number

Select any cell on required row; Press shift + spacebar

Several rows

Click & drag through required row numbers

Select range of cells extending through required rows; Press shift + spacebar

Column

Click column letter

Select any cell on required row; Press ctrl + spacebar

Several Columns

Click & drag through required column letters

Select range of cells extending through required columns; Press ctrl + spacebar

Entire Worksheet

Click on small rectangle at the intersection of rows & columns

Press ctrl+shift+spacebar

Multiple Selections

Hold ctrl key and click & drag required selections

Select 1 st cell range; Press shift + f8; select additional ranges; Press shift + f8

• Undo and Redo
• Autofill