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

G

Guest

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
 
N

Niek Otten

Edit>Go To>Special>Dependents. Click Direct only or All levels

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a formula by joining text and the value from a formula 3
help with IF formula 2
Cell shows the last typed text, no matter where it is typed 0
Last Modified By in a cell by user 3
Hide columns based on row values 2
#N/A In Cells 7
Formula apparently successful but #VALUE displayed 2
count formula question 2

Top