How to Copy formula To Entire Column

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: How to Copy formula To Entire Column

  1. #1
    New Member
    Join Date
    Feb 2010
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to Copy formula To Entire Column

     
    I'd like to learn how to copy a formula to an entire row without having to drag the formula down.



    Thanks,

    Noob Paul

  2. #2
    Board Regular
    Join Date
    Mar 2008
    Posts
    2,638
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to Copy formula To Entire Column

    Your title and text conflict. Do you want to fill a formula down a column (many rows) or across a row (many columns)?

    Also, it is very inefficient to copy a formula down an entire column (65,000+ rows). If you are trying to copy the formula down a column, and if there is data going all the way down in the column to the left or right of the formula column, simply hover your mouse over the lower right corner of the first formula cell until it turns to a cross (plus-sign) then double-click.

    Same cannot be done with going across columns in a single row, though.

  3. #3
    New Member
    Join Date
    Feb 2010
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to Copy formula To Entire Column

      
    Sorry meant column only. I'm creating a spreadsheet that after it's finished I don't want to have to help with other operator errors. I'm using excel 2003

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com