copy function
 

I need to do exact formula copying in my spread sheet. I need to copy this
formula: =average(A5:P5). When I tried to copy the formula to the next cell,
it changed to =average(B5:Q5). I need the formula to stay as =average(A5:P5).

Can somebody show me how to do that?

Thank you,
Linda

copy function
 

Try this
=average($A$5:$P$5)

"Linda" wrote:

I need to do exact formula copying in my spread sheet. I need to copy this
formula: =average(A5:P5). When I tried to copy the formula to the next cell,
it changed to =average(B5:Q5). I need the formula to stay as =average(A5:P5).

Can somebody show me how to do that?

Thank you,
Linda

copy function
 

change the formula to

=average($A$5:$P$5)

then the address should not adjust when you copy it.
--
Regards,
Tom Ogilvy


"Linda" wrote:

I need to do exact formula copying in my spread sheet. I need to copy this
formula: =average(A5:P5). When I tried to copy the formula to the next cell,
it changed to =average(B5:Q5). I need the formula to stay as =average(A5:P5).

Can somebody show me how to do that?

Thank you,
Linda