View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
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?