Select the range that includes the type of cells you want to select.
To select a range of filled-in cells in a row or column
For example, to select the range of filled-in cells above the active cell, double-click the top of the cell. The selection extends only to the next blank cell in the row or column.
To select named ranges or cell references
To select | Do this |
---|---|
A named range of cells | In the Name box, select the range. |
Two or more named ranges | In the Name box, select the first range, and then hold down CTRL and select the other ranges. |
Specific cells not in a named range | On the Edit menu, click Go To. In the Reference box, type the cell reference for the cell or range of cells. |
Microsoft Excel keeps track of the named ranges you have selected. To return to a previous selection, click Go To on the Edit menu, and then double-click the cell reference in the Go To box.