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:
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