Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    London, Gtr London, England
    Posts
    299
    Thanks
    0
    Thanked 0 Times in 0 Posts

    copy formula down more quickly (WinXP Excel 2002)

    I needed to create a formulae in one cell of a colunm and copy in down to the other 23160 rows. I did this by draging the mouse from the bottom right hand corner down the rows, which took ages with a large sheet like this. There must be a quicker, easier way to copy formulae (or anything else) across large ranges?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: copy formula down more quickly (WinXP Excel 2002)

    If all 23160 rows in the column to the left or to the right of the cell are filled, you can double click the fill handle (the black square in the lower right hand corner of the cell).
    Otherwise, select the range (for example: click in the first cell then Shift+click in the last cell, or press Ctrl+G for Edit | Go To, type the address, for example B2:B23161, click OK) then press Ctrl+D to fill down the formula.

  3. #3
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: copy formula down more quickly (WinXP Excel 20

    You can copy the cell (ctrl+c) go to a column that reaches as far down as you want to fill, press Ctrl + down arrow, move back to the column you want to paste your data, press ctrl + shift + up arrow to select the cells, press ctrl+v to paste the data in those cells.

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: copy formula down more quickly (WinXP Excel 2002)

    Just to add a third method....

    Select the range into which the formula must go, using the CTRL + Down Arrows or Typing the range into the name box at the left of the formula bar and press enter!
    Once the range is selected, type the formula into the first active cell and press CTRL + ENTER!

    This method is great for non-contiguous ranges too!
    Regards,
    Rudi

Posting Permissions

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