Home |
Search |
Today's Posts |
#1
|
|||
|
|||
changing cell references
Hi all
A colleague of mine has a large, complicated worksheet which contains several large formulas. Several of the formulas are referencing a particular cell, B4 for instance, and he wants to change all the formulas to look at C3 instead. I don't know if I can use a simple find/replace for this, as it's the formulas themselves i want to change. Is there a quicker way, rathr than changing them all manually??? Any urgent help is appreciated. Thank you. Louise |
#2
|
|||
|
|||
changing cell references
Yes, you can use find & replace, just in find and replace dialog be sure
that in "Look in:" field selection is "Formulas". "Louise" wrote in message ... Hi all A colleague of mine has a large, complicated worksheet which contains several large formulas. Several of the formulas are referencing a particular cell, B4 for instance, and he wants to change all the formulas to look at C3 instead. I don't know if I can use a simple find/replace for this, as it's the formulas themselves i want to change. Is there a quicker way, rathr than changing them all manually??? Any urgent help is appreciated. Thank you. Louise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell color index comparison | New Users to Excel | |||
More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
Cell References and External Data | Excel Worksheet Functions | |||
Finding Cell References | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |