MrExcel Publishing
Your One Stop for Excel Tips & Solutions

inserting rows, without losing formulas??

Posted by Helena C on October 16, 2000 4:00 PM

I'm a beginner and I need help.
I have an enormous spreadsheet that I have to update.
I have to keep all existing formulas in the spreadsheet.
I have to insert 500 rows. I have existing formulas
that link to another part of the spreadsheet.
But everytime I insert the rows. It loses the information.
For example, =May!D245
After inserting the rows, =May!Ref#.
Is there a way I can insert rows without losing the information.
I can't use a paste special, value.
I need to keep where it is orginally pointing to.

Posted by Thomas on October 16, 2000 4:29 PM

Look up "absolute" cell references - if you put a $ before the row and/or column, excel will not "slide" the formula value when you copy & paste the cell, or insert rows/columns etc. I don't know how to automatically change a whole bunch of formulas from relative to absolute style reference though. Anyone?