Select cells that contain formulas
- 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.
- On the Edit menu, click Go To.
- Click Special.
- Click Formulas, and then select the check box next to the type of data you want to select.