| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert selected formula references from relative to absolute
Hi, I have a reasonable, but limited knowledge of the advanced areas of
Excel. I want to do exactly as you have explained in these comments, but I don't understand what the response from Gord means, or what I do with it. I have multiple spreadsheets that I have linked and need to make a lot of relevant cells turn into absolute cells. Can anyway explain this to me in layman's terms? -- Thanks "M" wrote: Gord/ Warren and group - THANKS!!! I sometimes spend 'hours' trying to figure 'it' out and finally give it up and ask - -Minutes- and you folks have the answer!! Thanks, M |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
| Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
| Relative (vs. Absolute) Cell References with macros | Excel Discussion (Misc queries) | |||
| how to switch between relative and absolute references | New Users to Excel | |||
| F4 key does not toggle relative/absolute cell references. | Excel Worksheet Functions | |||
Hybrid Mode
