Cell references are acting absolute
 

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!

Cell references are acting absolute
 

Try this:

=OFFSET(B1,,-1)*2
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Spokane" wrote in message
...
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!

Cell references are acting absolute
 

Thanks for this tip. But is this something new in Excel?? I have never had
this problem before.

"RagDyer" wrote:

Try this:

=OFFSET(B1,,-1)*2
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Spokane" wrote in message
...
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!

Cell references are acting absolute
 

It's always been this way!

Perhaps, in the past, you were clicking on Column A when you performed the
"Insert".

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Spokane" wrote in message
...
Thanks for this tip. But is this something new in Excel?? I have never had
this problem before.

"RagDyer" wrote:

Try this:

=OFFSET(B1,,-1)*2
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Spokane" wrote in message
...
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!