hi,

if it is continuous, type 1 in a2, 2 in a3, select both cells and click on
the little blac box (right down) and drop dow.

or
=IF(B1<"",COUNTA($B$1:B1)&".","")

This formula, which is copied down to the other cells in column A, displays
the next consecutive item number if the corresponding cell in column B is not
empty. If the cell in column B is empty, the formula displays nothing.

As items are added or deleted from column B, the numbering updates
automatically.
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Birdieguy" escreveu:

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?