Results 1 to 9 of 9
Like Tree4Likes
  • 3 Post By Swamp Thing
  • 1 Post By Ekim

Filling down a column without dragging over every cell?

This is a discussion on Filling down a column without dragging over every cell? within the Excel Questions forums, part of the Question Forums category; I have a spreadsheet that will eventually consist of tens of thousands of rows. Several columns contain formula's. Rather than ...

  1. #1
    New Member
    Join Date
    Aug 2003
    Posts
    15

    Default Filling down a column without dragging over every cell?

    I have a spreadsheet that will eventually consist of tens of thousands of rows. Several columns contain formula's. Rather than having to "highlight" a cell and then "drag" all the way down the column over thousands of rows before finally using the "fill down" function I am needing a method to short cut this process?

    Is there a function that allows you to, say, nominate a range of cells that you can fill down over? For example, starting from the last row with data entered into it down to say row 12500 i.e. D22:D12500.

    In advance thank you for any help anyone is able to provide.

    Regards Mick.

  2. #2
    Board Regular
    Join Date
    Aug 2002
    Posts
    305

    Default Re: Filling down a column without dragging over every cell?

    (A) If one column has already been filled down to a certain number of rows, then adjacent columns can be filled down to the same height by this prodecure:

    Highlight the first row in the columns you want to fill down.
    Double click the lower right corner of the highlight box.


    (B)To fill down a column for the first time (with no other filled columns available):

    -Enter formula in first cell

    -Select the first cell again

    -Type Ctrl+C to copy (dotted line appears around cell)

    -Click in address box and type in the range (e.g. A1:A1500) followed by Enter. This will select the range to be filled

    -Type Ctrl+V to paste formula into all selected cells

    -Type 'Esc' to edit copypaste mode

    Cheers
    s.t.
    nida, arspi and Tooom like this.

  3. #3
    Board Regular
    Join Date
    May 2003
    Location
    Katy, Texas
    Posts
    3,829

    Default Re: Filling down a column without dragging over every cell?

    Just read your response to the question about filling columns! Amazing, I tried both of your methods, and, they both worked like a charm!!! Thank you for posting such a helpful solution to this so often required job.

    Regards,

    Ralph

  4. #4
    Board Regular
    Join Date
    Jun 2002
    Location
    Perth, Australia
    Posts
    1,416

    Default Re: Filling down a column without dragging over every cell?

    Alternative procedure to copy a formula down for the range D22:D12500:

    1 Select the cell with the formula (D22)
    2 In the Name box, change D22 to D22:D12500
    3 Press Enter to select
    4 Press Ctrl-D (that's the Ctrl key and D together)

    Regards,

    Mike
    nida likes this.

  5. #5
    New Member
    Join Date
    Aug 2003
    Posts
    15

    Default Re: Filling down a column without dragging over every cell?

    Thanks guys for your answers , they have been very helpful and did what I needed to do perfectly.

    Thanks again for your assistance. It is much appreciated.

    Regards

    Mick

  6. #6
    Board Regular
    Join Date
    May 2002
    Posts
    509

    Default Re: Filling down a column without dragging over every cell?

    You say you will have 1,000's of rows.

    Have you considered using a database instead? Microsoft Access can handle 1,000's of rows much better than Excel can.

    Berg

  7. #7
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259

    Default Re: Filling down a column without dragging over every cell?

    10's of thousands of Rows with several cells in each row having a formula ... Trust me I've been there and it's not pretty . You will have problems and I agree with the last Poster, think about alternatives to this such as Access, MySQL or MS SQL.

    <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

  8. #8
    New Member
    Join Date
    Feb 2013
    Posts
    2

    Smile Re: Filling down a column without dragging over every cell?

    Quote Originally Posted by Ekim View Post
    Alternative procedure to copy a formula down for the range D22:D12500:

    1 Select the cell with the formula (D22)
    2 In the Name box, change D22 to D22:D12500
    3 Press Enter to select
    4 Press Ctrl-D (that's the Ctrl key and D together)

    Regards,

    Mike
    amazing thanks for shearing

  9. #9
    New Member
    Join Date
    Feb 2013
    Posts
    2

    Default Re: Filling down a column without dragging over every cell?

    thanks for sharing

    Quote Originally Posted by Swamp Thing View Post
    (A) If one column has already been filled down to a certain number of rows, then adjacent columns can be filled down to the same height by this prodecure:

    Highlight the first row in the columns you want to fill down.
    Double click the lower right corner of the highlight box.


    (B)To fill down a column for the first time (with no other filled columns available):

    -Enter formula in first cell

    -Select the first cell again

    -Type Ctrl+C to copy (dotted line appears around cell)

    -Click in address box and type in the range (e.g. A1:A1500) followed by Enter. This will select the range to be filled

    -Type Ctrl+V to paste formula into all selected cells

    -Type 'Esc' to edit copypaste mode

    Cheers
    s.t.

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