Select cells that contain formulas

Microsoft Office Excel 2003

Show All Show All

Select cells that contain formulas

  1. Do one of the following:
    • Select the range that includes the type of cells you want to select.
    • Click any cell to select all cells of this type on the active worksheet.

  2. On the Edit menu, click Go To.
  3. Click Special.
  4. Click Formulas, and then select the check box next to the type of data you want to select.