Pasting formulas advances cell reference

  • Thread starter Thread starter Derek M
  • Start date Start date
D

Derek M

Hi

When i paste special from one cell into another, it advances the cell
reference and i just want an exact match i.e.

A1 formula ='Feb 2010'!C18 but when i paste it into another cell it pastes
it as
='Feb 2010'!D18

The C changes to D, how do i stop this happening?

Thanks for any help in advance

Derek
 
Use absolute referencing. Below are the different reference styles.

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.
 
Back
Top