formulas

  • Thread starter Thread starter Flavio Tinoco
  • Start date Start date
F

Flavio Tinoco

As you know a formula will ask for the value in a
particular cell. My problem is that I have a very long
spreasheet with several different columns with formulas.
Sometimes I want to delete a cell but I am not sure how
many formulas will be affected because this cell may be
involved in 10 different formulas. Is there a way to click
on a particular cell and find out all the formulas in the
spreadsheet that asks for the value in that cell. Thank
you.
 
Flavio Tinoco said:
As you know a formula will ask for the value in a
particular cell. My problem is that I have a very long
spreasheet with several different columns with formulas.
Sometimes I want to delete a cell but I am not sure how
many formulas will be affected because this cell may be
involved in 10 different formulas. Is there a way to click
on a particular cell and find out all the formulas in the
spreadsheet that asks for the value in that cell. Thank
you.
Click to expand...

These are called 'dependent' cells.
Select a cell. Bring up the auditing toolbar. Click the 'Trace dependents'
button. All dependent cells will be marked with a coloured arrow.
 
Back
Top