ExcelBanter - track use of cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - track use of cell (https://www.excelbanter.com/excel-discussion-misc-queries/229101-track-use-cell.html)

willemeulen

track use of cell

When standing on a cell with formula you can see which cells it uses by
clicking the command line. Is it also possible the other way around. Can I
track if or where a cell is used in formulas elswhere in the sheet?

Jacob Skaria

track use of cell

From the Formula Auditing Toolbar (under View|Toolbars|) click Trace
Dependents to see whether a cell is being referenced by any formula.

If this post helps click Yes
---------------
Jacob Skaria

"willemeulen" wrote:

When standing on a cell with formula you can see which cells it uses by
clicking the command line. Is it also possible the other way around. Can I
track if or where a cell is used in formulas elswhere in the sheet?

All times are GMT +1. The time now is 08:02 AM.