Results 1 to 5 of 5

copy formula down column without having to drag the corner

This is a discussion on copy formula down column without having to drag the corner within the Excel Questions forums, part of the Question Forums category; I am working with a file that has 55,000 rows. I often have to insert a column and then write ...

  1. #1
    Board Regular
    Join Date
    Jun 2003
    Posts
    78

    Default copy formula down column without having to drag the corner

    I am working with a file that has 55,000 rows. I often have to insert a column and then write a formula based on the values in the other columns. The only way I know how to copy the formula down the column is to drag the corner of the cell all the way down. I thought there was a way to do this by using ctrl shift end or something like that, but I don't remember how. Thanks.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Brampton
    Posts
    325

    Default Re: copy formula down column without having to drag the corn

    After selecting all range in the column, write the formula in the first cell on the top, and then Ctrl + Enter.

  3. #3
    New Member
    Join Date
    Jun 2002
    Location
    Monterrey, Mexico
    Posts
    35

    Default Re: copy formula down column without having to drag the corn

    Other way is write the formula in the first cell, then select that cell and put the cursor in the right down corner of the cell and double click....

  4. #4
    New Member
    Join Date
    Jun 2003
    Posts
    1

    Default Re: copy formula down column without having to drag the corn

    Type the formula. Then copy to the clipboard. Then press shift ctrl end. Then hit enter.

  5. #5

    Join Date
    Nov 2002
    Posts
    981

    Default Re: copy formula down column without having to drag the corn

    Another way:-

    Copy the cell
    Go to Edit>GoTo, type the destination range ref in the reference box, clickOK
    Paste

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