Spreadsheet Selection Methods

To select

a single cell

• click in the cell
• that cell is now the active cell and it will be outlined by a nonprinting border

a cell range

• point to the first anchor cell and drag to the other anchor cell
• or click in the first anchor cell and Shift-Click in the second

an entire row or column

• click the row or column heading

the entire worksheet

• press the [Select All] button, the box to the left of the A and above the 1 (in Excel X, this box has a diamond in it)

  Select All Button Excel XP	Select All Button Excel X
  the Select All button in earlier versions is essentially the same

• or press Cmd + A (Macintosh) or Ctrl + A (Windows)

Copyright©2002
last updated August 12, 2003