| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy function. | Excel Discussion (Misc queries) | |||
| Copy Excel Function from a Cell Through a Function | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| Hyperlink function and copy the cells without the function | Excel Programming | |||
| Range COPY function - how to copy VALUES and not formulas | Excel Programming | |||
Linear Mode
