One way:

Enter 1 in A1, 2 in B1, select A1:B1, and drag the fill handle (lower
right corner of B1) to the right as far as required.

Another;

Enter 1 in A1, and =A1+1 in B1. Copy B1 as far to the right as required.


In article ,
Muddled wrote:

Will an excell worksheet automatically insert from 1 to 2 to 3 & so on in
each next cell? How is this done. If A-1 has 1 in it, I want B-! to have 2,
C-1 to have 3,etc etc.
Help!