Javster. you could grab the fill handle, the little black square in the
bottom right hand, right click and drag down and fill series or put = A2 +1
in A3 and copy down

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Javster95" wrote in message
...
Is there a way to automatic number a spreadsheet? For instances... if I
were
to start on column A and row 2 with number 1, would this be possible to
continue numbering going down the spreadsheet? Please assist.