Find out if a cell is being used in a formula
Hi!
Is there a way for my to know if a determined cell with a numeric value in it is being used by a formula inside the file?
Thanks!
Question marked as
Numbers doesn't have a Trace Dependents type feature such as Excel has. But there are ways to tell. One way is to change the numerical value to something very large and see which other cells change. Or you can introduce an error into the cell (by dividing by 0, for example) and see which other cells then show errors.
SG