View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
 
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?