Filling down a column without dragging over every cell?

Aussie-Mick

New Member
Joined
Aug 1, 2003
Messages
15
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.
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
(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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
10's of thousands of Rows with several cells in each row having a formula :oops: ... Trust me I've been there and it's not pretty :cry: . You will have problems and I agree with the last Poster, think about alternatives to this such as Access, MySQL or MS SQL.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,236
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top