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


On Wed, 14 May 2008 16:40:00 -0700, lea wrote:

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