assuming you want the numbers to increment in column 'A' do

1) In cell A1 type 1

2) In cell A2 put the formula =A1+1

3) Copy the formula down as far as you need to

4) If you need the cells to contain text values not formulas copy the entire column and then paste special values over the top.

Hope this helps

Frazer