Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 10th 08, 06:08 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 1
Default 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?

  #2   Report Post  
Old May 10th 08, 06:19 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,124
Default 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?


  #3   Report Post  
Old May 10th 08, 06:36 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 1,071
Default 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?



  #4   Report Post  
Old May 10th 08, 06:42 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default 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
  #5   Report Post  
Old May 10th 08, 08:03 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I quickly enter the same number into different cells? Cheers100 New Users to Excel 2 February 18th 06 02:26 PM
need to add/remove characters over thousands of cells Nadia Excel Discussion (Misc queries) 3 June 19th 05 11:38 PM
Autofill: Need to autofill one week block, (5) weekday only into cells. dstock Excel Discussion (Misc queries) 1 June 17th 05 08:21 PM
Quickly typing dates into cells olasa Excel Discussion (Misc queries) 0 May 24th 05 11:33 PM
How do I format cells to round to the nearest thousands without .. excel user Excel Discussion (Misc queries) 1 March 16th 05 08:10 PM


All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright ©2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017