I have a spreadsheet with formulae referring to the next cell to the left,
for example B1=A1*2. When I insert a column to the left of B, B becomes C.
I want the formulae to continue to refer to the next cell at left, so that
B1=A1*2 and C1=B1*2. But when I insert this new column, the references in new
C/old B remain the same - C1=A1*2. New B is never included in the calcs, even
when I copy the formula. The formulae have only relative references, no
absolutes. Any help appreciated!