How do I locate a cell that provides data to a formula ? A cell reference is
needed.

ToolsAuditingShow Auditing Tool Bar

Once you can see the auditing tool bar click on the cell that contains the
formula and press the "Trace Precendents" button on the new toolbar. This
will show you which cells are providing data. If this isn't what you want to
do then please post more details.

"chrisatminara" wrote:

How do I locate a cell that provides data to a formula ? A cell reference is
needed.

Hi

i'm really not sure what you're after, could you please give us a bit more
information (ie an example of your data and what you'll like to see -
however, please don't attach a workbook).

Alternatively, you might like to check out Tools / Formula Auditing / Trace
Precedents - after you've clicked on the cell with the formula.

Cheers
JulieD

"chrisatminara" wrote in message
...
How do I locate a cell that provides data to a formula ? A cell reference
is
needed.