Thread: How to trace a cell? Which cells use a special cell in formulas?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SupperDuck SupperDuck is offline
external usenet poster
  
Posts: 44
Default How to trace a cell? Which cells use a special cell in formulas?
Dear all,

Just consider that i have a cell "B1".

And i want to find which cells use this cell as a data in total workbook.

eg.

formula C5 = B1*3
formula D2= B2 + B6 - B1


So i just want to find C5 and D2, becuse they use B1 as data.

Do you know how?

Regards,
Reply With QuoteReply With Quote