Filling down a column without dragging over every cell?

[Aussie-Mick]

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.

 

[Swamp Thing]

(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.

 

[RalphA]

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

 

[Ekim]

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

 

[Aussie-Mick]

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

 

[berg891832]

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

 

[Nimrod]

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.

 

[nida]

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

 

[nida]

thanks for sharing

(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.