View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default How do you REALLY get Excel to Autonumber consecutively?

put in 1, Enter, 2, enter, Select both cells and then drag the corner of
the border down to fill.

Otto wrote:

I have followed both sets of the instructions to the letter but can only get
repetitive numbering.. i.e. 1,1,1,1,1,. I want consecutive just like the
instructions say I am going to get 1,2,3,4,5,... thanx