Excel - how to autofill thousands of cells quickly

I have a spreadsheet with 35000 rows. Is there an easy way to autofill a
formula for all of the rows instead of dragging down all 35000 rows?

Sub fillemfast()
Range("c2:c35000").Formula = "=a2"
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dennis H" <Dennis > wrote in message
...
>I have a spreadsheet with 35000 rows. Is there an easy way to autofill a
> formula for all of the rows instead of dragging down all 35000 rows?

Say you have data in Column A all the way down to 35000 rows. In cell B1,
enter your formula. Move the mouse cursor until it is over the fill handle
of that cell. Double-click the left mouse button. Done. Otto
"Dennis H" <Dennis > wrote in message
...
>I have a spreadsheet with 35000 rows. Is there an easy way to autofill a
> formula for all of the rows instead of dragging down all 35000 rows?

Edit|goto
Type:
A1:A35000
(or whatever the address of that range is)

This will select that range

Then type your formula for the top cell, but hit ctrl-enter to fill all the
cells in the selection.

Dennis H wrote:
>
> I have a spreadsheet with 35000 rows. Is there an easy way to autofill a
> formula for all of the rows instead of dragging down all 35000 rows?

--

Dave Peterson

If you have the formula already entered in A1, follow Dave's advice except hit
Ctrl + d not Ctrl + Enter


Gord Dibben MS Excel MVP


On Sat, 10 May 2008 10:08:01 -0700, Dennis H <Dennis
> wrote:

>I have a spreadsheet with 35000 rows. Is there an easy way to autofill a
>formula for all of the rows instead of dragging down all 35000 rows?