Find where else in a spreadsheet a cell is referenced with formula
 

I am working in a spreadsheet that uses many formulas for calculations.

There is a variable(s) (call it Cell A5 to Cell H5) that, if any of the
cells are changed, will change the result of the spreadsheet. I want to know
how to search for all formulas that access cells A5 to H5.

Are there any tricks or do I need to read each formula in the spreadsheet ?

Any help appreciated
Thanks
Analyser

Find where else in a spreadsheet a cell is referenced with formula
 

EditGo ToSpecialDependents. Click Direct only or All levels

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Analyser" wrote in message ...
|I am working in a spreadsheet that uses many formulas for calculations.
|
| There is a variable(s) (call it Cell A5 to Cell H5) that, if any of the
| cells are changed, will change the result of the spreadsheet. I want to know
| how to search for all formulas that access cells A5 to H5.
|
| Are there any tricks or do I need to read each formula in the spreadsheet ?
|
| Any help appreciated
| Thanks
| Analyser