Copy and paste absolute reference

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
 
G

Gord Dibben

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
 
L

lea

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top