Replacing cell reference on multiple sheets in one go....

[neilcarden]

Hey,

I am needing to change a referenced cell on 31 worksheets in one go i
possible.

On each sheet cell D19 equals C89, I want them all to equal C91 now?

I don't think I can do a Ctrl+H over multiple sheets....

Thanks
Nei

 

[Jarek Kujawa]

yes, you can

right-click on any tab, Select all sheets, then Ctrl+H

 

[Gord Dibben]

CTRL + h then Options>Within>Workbook


Gord Dibben MS Excel MVP

 

[neilcarden]

Thanks Guys!!! Save me some time