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? |
Answer: Excel - how to autofill thousands of cells quickly
Yes, there is an easy way to autofill a formula for all 35000 rows in Excel. Here are the steps:
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. |
Excel - how to autofill thousands of cells quickly
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? |
Excel - how to autofill thousands of cells quickly
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? |
Excel - how to autofill thousands of cells quickly
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 |
Excel - how to autofill thousands of cells quickly
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? |
All times are GMT +1. The time now is 03:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com