search for a particular cell in worksheets

  • Thread starter Thread starter JoviGirl
  • Start date Start date
J

JoviGirl

I have 20 multiple worksheets - if I change a cell in B14 on the 1st
worksheet, how can I tell if it changed everywhere that it was referenced on
each additional worksheet?
Thanks
 
Hi,

If that cell was correctly referenced in other formula/sheets and
calculation is set to automatic then you can trust Excel to have done it, no
need to check.

Mike
 
You can search for the Sheet1 B14 value across all sheets.

Select "Workbook" in the edit>find options.

Or just make sure you have calculation set to automatic and trust Excel to
make the changes where required.


Gord Dibben MS Excel MVP
 
Back
Top