View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default How do you auto-number a large list of rows in Excel?

Put 1 in first cell , hold CTRL and drag down.

"Birdieguy" wrote:

Without having to type each number from 1 to, say, 300, and hit the down
arrow or enter in between each, isn't there a command in Excel that will
automatically do this for you?