View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
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