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.
 

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

Similar Threads

Embedding the value of a cell in a formula 2
A formula referencing another 9
Dynamic CONCATENATE and LOOKUP 1
Date + relative number reference 3
Formulas 2
push result from one cell to another 2
populate month-yyyy when compare 2 cells 3
Copying formula vertically, to pick up horizontal cell values 3

Back
Top