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?

Yes, there is an easy way to autofill a formula for all 35000 rows in Excel. Here are the steps:

1. Enter the formula in the first cell of the column where you want to apply it.
2. Double-click on the small square at the bottom right corner of the cell. This will autofill the formula down to the last row of the adjacent column.
3. If you want to autofill the formula across multiple columns, select the range of cells where you want to apply the formula.
4. Hover your mouse over the bottom right corner of the last cell in the range until it turns into a small crosshair.
5. Double-click on the crosshair and the formula will be autofilled across all the selected cells.

This method is much faster than dragging the formula down manually for all 35000 rows. It's a great time-saver when working with large datasets in Excel.

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?