Copying formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to copy a formula to the cells below it. However when i use the normal
function to copy it automatically increases all of the cell references that i
have used within the formula. I need to keep some of the cell references
within the formula the same for each copy whereas others are changing.

How can i do this?

Thanks.
 
DaveAsh said:
I need to copy a formula to the cells below it. However when i use the
normal
function to copy it automatically increases all of the cell references
that i
have used within the formula. I need to keep some of the cell references
within the formula the same for each copy whereas others are changing.

How can i do this?

Thanks.
Click to expand...

Where you want to keep the same references, use absolute addressing ($A$1)
rather than relative (A1).
 
Relative row and column..........A1

Absolute column, relative row.........$A1

Absolute row, relative column............A$1

Absolute row and column...........$A$1


Gord Dibben MS Excel MVP
 
Back
Top