copy function

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to show copy process when I use System.IO.File.Copy function	Michael	Microsoft VB .NET	6	25th Sep 2007 01:31 PM
copy of excel file not showing formulal/function in the function b	=?Utf-8?B?b2FhbGxhbQ==?=	Microsoft Excel Misc	4	6th Sep 2007 01:20 PM
Copy function does not copy data in subforms	=?Utf-8?B?Q1c=?=	Microsoft Access Forms	2	17th Nov 2006 02:25 PM
Range COPY function - how to copy VALUES and not formulas	James Cooke	Microsoft Excel Programming	1	21st Aug 2003 07:04 PM
Range COPY function - how to copy VALUES and not formulas	James Cooke	Microsoft Excel Worksheet Functions	1	21st Aug 2003 07:04 PM