Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copying formulas
how do I copy a formula in a column through 52 rows?
I have a column of 52 rows into which I want a sum from about 10 other column's cells to appear. How do I copy this formula to keep the sum from the same 10 columns following down with appropriate row #s throughout the 52 rows? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
copying formulas
Hi,
Show us your formula and an example of the data layout. Because normally you would just choose Copy and Paste or use the Fill Handle. Cheers, Shane Devenshire "spurge" wrote in message ... how do I copy a formula in a column through 52 rows? I have a column of 52 rows into which I want a sum from about 10 other column's cells to appear. How do I copy this formula to keep the sum from the same 10 columns following down with appropriate row #s throughout the 52 rows? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formulas | Excel Worksheet Functions | |||
Copying Formulas | Excel Discussion (Misc queries) | |||
copying formulas in vba | Excel Discussion (Misc queries) | |||
copying formulas | Excel Worksheet Functions | |||
Copying Down Formulas Q | Excel Worksheet Functions |