View Single Post
  #1   Report Post  
Monique
 
Posts: n/a
Default Sequential numbering

All I do is go to next blank cell and add:
=A1+1 and use the pull handle down the column.

"jazz" wrote:

I have a list of items, numbered, say 1 to 10. When I want to enter the
next item, is there a way that I can automatically have the next number as
11? I know I can use the fill handle to create the numbered list, but I was
hoping to avoid that, and had hoped that when I tab into the particular cell,
and then tab to the next cell, it would automatically provide the next
number. Too much to ask? I am using Excel 2000. Many thanks. Jazz.