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

Hey,

I am needing to change a referenced cell on 31 worksheets in one go if 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
Neil

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

yes, you can

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

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

CTRL + h then OptionsWithinWorkbook


Gord Dibben MS Excel MVP


On Tue, 5 Aug 2008 09:17:46 +0100, neilcarden
wrote:


Hey,

I am needing to change a referenced cell on 31 worksheets in one go if
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
Neil

Thanks Guys!!! Save me some time!