Selecting Data

Close Window 

Selecting the Active Area of a Worksheet

The "active area" of an Excel worksheet is the part that contains any cells you've used. To select the active area, go to the top left cell in that area, press and hold the Shift key, and press Ctrl+End. (If Excel seems to select a lot of extra cells below and to the right of your work, save the workbook and try the keystroke again.)

(Posted 6/23/2000)