|
| 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
August 5th, 2008, 09:17 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
August 5th, 2008, 10:53 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing cell reference on multiple sheets in one go....
yes, you can
right-click on any tab, Select all sheets, then Ctrl+H
|
|
#3
August 5th, 2008, 04:37 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
August 6th, 2008, 11:20 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing cell reference on multiple sheets in one go....
Thanks Guys!!! Save me some time! -- neilcarden
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
