copy function

[Guest]

I need to do exact formula copying in my spread sheet. I need to copy this
formula: =average(A55). 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(A55).

Can somebody show me how to do that?

Thank you,
Linda

 

[Guest]

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

 

[Guest]

change the formula to

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

then the address should not adjust when you copy it.