Topics

Apr 10, 2011

Selecting cells that contain formulas in Excel 2007

To select cells that contain formulas in the worksheet, perform the following steps:
1. On the Home tab, in the Editing group, click Find & Select and then click Go To Special...
2. In the Go To Special dialog box, click Formulas.
3. Click OK.

Note:
  • You can choose the formulas that returns numbers or text or logicals or errors by placing or removing the checkmark besides Numbers, Text, Logicals, Errors.
  • You can select the cells with formulas in a range of cells by selecting the cells first and performing the above steps.

0 comments:

Post a Comment