Thread: How do you auto-number a large list of rows in Excel?
View Single Post
  #21   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do you auto-number a large list of rows in Excel?
Sarah

On Home tab go to far right to "Editing" section.

Click on the downarrow icon to see a list of fill options.


Gord Dibben MS Excel MVP

On Thu, 30 Apr 2009 09:54:01 -0700, sarah
wrote:

im using this new version of Excel which has no 'edit'. it looks like this:



"tim m" wrote:

Hi light the cells you want to number and 'Edit'...'fill'....'series' (step
value is how much the numbers increase by and stop value is the highest
number.)

"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?

Reply With QuoteReply With Quote