Here are some tips for selecting different Excel elements.

Selecting Excel Ranges

With the Selector Tool , drag the desired range

Click on the first cell in the top left corner of the range and then, while holding the SHIFT key, click on the last cell in the bottom right corner of the range. TIP: You can add to the selected range by holding down the SHIFT key and clicking on the last desired cell. Likewise, you can subtract cells from the range by holding the SHIFT key and clicking on the last desired cell.

To select two separate ranges, select the first range, then hold the CTRL key down while dragging the second range. You can continue adding additional ranges while holding the CTRL key.

Using only the keyboard, hold the SHIFT key whil pressing the arrow key in the direction of the desired range.

Selecting Columns / Rows in Excel

To select an entire column or row, click on the column or row header. To select multiple columns or rows, drag the black arrow across the desired headers.

Excel Worksheet

To select the entire Excel worksheet, click with the Selector Tool  in the box where the row and column headers intersect in the top left corner of the sheet.

Excel 2003		Excel 2007

Excel Sheets

To select a sheet, click on the desired sheet tab.

To select multiple sheets:

CAUTION! While multiple sheets are selected anything you type will be entered on ALL selected sheets!