finding whether cell is referred to elsewhere

  • Thread starter Thread starter smp
  • Start date Start date
S

smp

Does anyone know how to "follow" a particular cell to see
whether its contents are referred to by a formula in a
different part of the workbook? i.e., whether or not it's
safe to delete?

Thanks.
 
SMP,

On your menus:
View -> Toolbars -> Customize...
Under the Toolbars tab check off "Auditing"

This toolbar will provide you with what you need. Search
excel help for "Auditing" for a more detailed explanation
of the fuctionality of the tools. Post back if you need any
help.

Dan E
 
use tools, auditing to find out

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Back
Top