Moving cells in excel but retaining formula
Posted by April M on April 12, 2001 9:13 AM
I often insert columns into my sheets and then want to move or copy one of the columns that has been displaced, but retaining the formulas as they are.
However, the formulas are always adjusted and refer to nonsence cells.
I cant use the anchor $ because there are sometimes when I require them to be changed.
I remember supercalc used to cope with this matter admirably.
Does anyone know if this can be done in excel.
Cheers - April M.