| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
True Absolute Reference
Hi,
When I insert columns I have to redo all my formulas. I understand you can use indirect but I don't think it will work. My formula is a simple =$E$20-$G$20, when I insert two columns it becomes =$G$20-$I$20. How do I force it to keep the original cell addresses? Many thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| absolute reference | Excel Discussion (Misc queries) | |||
| Absolute Reference | Excel Discussion (Misc queries) | |||
| absolute reference | Excel Discussion (Misc queries) | |||
| absolute reference | Excel Discussion (Misc queries) | |||
| absolute reference | Excel Worksheet Functions | |||
Threaded Mode
