formula in column

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

Thread: formula in column

  1. #1
    New Member
    Join Date
    Sep 2003
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default formula in column

     
    Hello,
    Is ther a way I can get a formula to run all down a column? At the moment I just drag the handle in the corner of the cell down - is there an easier way to put the formula down through the whole column ?
    Thanks

  2. #2
    Board Regular
    Join Date
    Jun 2002
    Location
    England
    Posts
    116
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula in column

    Write the formula into the top cell. Do Edit->Copy. Select the whole column by clicking on the column name. Do Edit->Paste.

    Regards,
    Chris
    Excel games and utilities! Check them out at http://www.lazyslug.com

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Phoenix, Arizona
    Posts
    1,711
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula in column

    If you have data in the adjacent column, you can double click the handle and it will fill down.

    If not, higlight the column and on your edit menu select "Fill / Down"

  4. #4
    New Member
    Join Date
    Sep 2003
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: formula in column

      
    Excellent. thanks very much for your speedy replies.
    Cheers.

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