If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 -- neilcarden |
#2
|
|||
|
|||
Replacing cell reference on multiple sheets in one go....
yes, you can
right-click on any tab, Select all sheets, then Ctrl+H |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Replacing cell reference on multiple sheets in one go....
Thanks Guys!!! Save me some time! -- neilcarden |
Thread Tools | |
Display Modes | |
|
|