Show All

Select cells containing specific data

1. To select all cells of this type on the active worksheet, click any cell.

   Select the range that includes the type of cells you want to select.

2. On the Edit menu, click Go To.
3. Click Special.
4. Do one of the following:
   • To select blank cells, click Blanks.
   • To select cells that contain comments, click Comments.
   • To select cells that contain constants, click Constants.
   • To select only cells that are visible in a range that crosses hidden rows or columns, click Visible cells only.
   • To select the current region, such as an entire list, click Current region.

   To select a range of filled-in cells in a row or column

   1. Click the first or last cell in the range.
   2. Hold down SHIFT and double-click the side of the active cell in the direction that you want to select.

      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.

   Tip

   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.