Home |
Search |
Today's Posts |
#1
|
|||
|
|||
replace absolute references
can I quickly find/replace all non existent absolute references (for
different column letters), and replace them with absolute versions of that letter? Each different column reference, however, is matched with the same absolute reference to row (if that helps). In other words, I don't want to replace with the same thing, but rather I want the sheet to go through the logic of "when I find the references of f$16 and g$16, I should replace them with $f$16 and $g$16". Thanks. -- Boris |
#2
|
|||
|
|||
Yes. You will have to do two separate find & replace.
"BorisS" wrote: can I quickly find/replace all non existent absolute references (for different column letters), and replace them with absolute versions of that letter? Each different column reference, however, is matched with the same absolute reference to row (if that helps). In other words, I don't want to replace with the same thing, but rather I want the sheet to go through the logic of "when I find the references of f$16 and g$16, I should replace them with $f$16 and $g$16". Thanks. -- Boris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making multiple cells absolute at once | Excel Discussion (Misc queries) | |||
replace absolute references | Excel Worksheet Functions | |||
Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
Quick method to add absolute references in Excel using keyboard | Excel Discussion (Misc queries) | |||
Pivot tables Excel 2003 absolute references | Excel Discussion (Misc queries) |