Copy and paste absolute reference

  • Thread starter Thread starter lea
  • Start date Start date
L

lea

I have cells with absolute reference formulas within a table, referring to
cells in that table, how do I copy the table further down the worksheet, or
to a new worksheet with the absolute references referring to the new table
and not referring to the cells at the top of the worksheet
 
Un-absolute part of the reference.

i.e. $A$1 will remain that as you copy down.

$A1 will increment to $A2 $A3 $A4 etc.

A$1 will become B$1 as you copy across.


Gord Dibben MS Excel MVP
 
Thanks Gord, works wonderfull

Gord Dibben said:
Un-absolute part of the reference.

i.e. $A$1 will remain that as you copy down.

$A1 will increment to $A2 $A3 $A4 etc.

A$1 will become B$1 as you copy across.


Gord Dibben MS Excel MVP
Click to expand...
 
Back
Top