Microsoft KB Archive/31315

Finding All Cell(s) Dependent on the Value of a Given Cell PSS ID Number: Q31315 Article last modified on 02-26-1993 PSS database name: W_eXceL

2.x 3.00 | 2.20 2.21 3.00

WINDOWS | OS/2

Summary:

To find all cells that are dependent on the value of a given cell or group of cells on a worksheet, use the Select Special feature of Excel, as follows:


 * 1) Select the cell or cells in which you want to find dependents.
 * 2) Choose Select Special from the Formula menu.
 * 3) Select Dependents and highlight All Levels.
 * 4) Click OK or press ENTER.

This procedure highlights all cells that are dependent on the value of the cell or cells selected in Step 1.

Additional reference words: 2.0 2.00 2.1 2.10 3.0 3.00

Copyright Microsoft Corporation 1993.