Select cells that contain formulas - Help and How-to

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

Select cells that contain formulas

Applies to: Microsoft Office Excel 2003

Do one of the following:
- Select the range (range: Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.) 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.

See Also

Audio course: Get to know Excel: Enter formulas
Buy Microsoft Office 2007
Figure out dates by using formulas
Free trial of the 2007 Microsoft Office system
Get to know Excel 2007: Enter formulas
Get to know Excel: Enter formulas
Make time count by using formulas

Printer-Friendly Version

Original page: http://office.microsoft.com/en-gb/help/HP052404781033.aspx