Excel > Excel 2003 Foundation > Creating a workbook

Selecting Cells

There are plenty of methods for selecting cells in Excel.

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

Follow us on

Facebook  Twitter  You Tube