| Home |
| Search |
| Today's Posts |
|
#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 |
|
#2
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
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
|
|||
|
|||
|
Thanks Guys!!! Save me some time!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing across multiple sheets using a changeable reference cell | Excel Worksheet Functions | |||
| Replacing a Table-array with a cell reference in vlookup | Excel Worksheet Functions | |||
| Replacing sheet reference in multiple cells... | Excel Worksheet Functions | |||
| Cell Reference, Multiple Sheets | Excel Worksheet Functions | |||
| INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
Linear Mode
