Copying formulas
 

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.

Copying formulas
 

"DaveAsh" wrote in message
...
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.

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

Copying formulas
 

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

On Tue, 13 Nov 2007 03:53:00 -0800, DaveAsh
wrote:

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.