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.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Swamp Thing

Active Member
Joined
Aug 16, 2002
Messages
313
(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

Well-known Member
Joined
May 14, 2003
Messages
3,829
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

Well-known Member
Joined
Jun 30, 2002
Messages
1,416
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

New Member
Joined
Aug 1, 2003
Messages
15

ADVERTISEMENT

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

Well-known Member
Joined
May 2, 2002
Messages
509
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

MrExcel MVP
Joined
Apr 29, 2002
Messages
6,259

ADVERTISEMENT

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.
 

nida

New Member
Joined
Feb 13, 2013
Messages
2
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

New Member
Joined
Feb 13, 2013
Messages
2
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,719
Members
414,401
Latest member
grenona2020

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
Top