Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 857
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying formulas [email protected] Excel Worksheet Functions 1 March 28th 08 08:23 PM
Copying Formulas Vicki Excel Discussion (Misc queries) 1 April 8th 07 05:46 PM
copying formulas in vba Michael Excel Discussion (Misc queries) 1 November 17th 05 08:48 PM
copying formulas Boz Excel Worksheet Functions 1 March 1st 05 06:47 PM
Copying Down Formulas Q John Excel Worksheet Functions 4 November 23rd 04 11:14 PM


All times are GMT +1. The time now is 08:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"