Hello All
I would like to have sequential Auto Generated Numbers in column A of my Excel 2003 Spreadsheets e.g A1=1, A2=2, A3=3 etc. But I would like Excel to auto generate this number, rather than input?

Enter the value 1 in cell A1

enter the formula =A1+1 in cell A2

Copy cell A2 to A3:A100 and the numbers will populate.

Alternatively, Enter the value "1" in cell A1.

Then select Edit, Fill, Series from the menu. Change "Series In" to "Columns". Enter a stop value, say "100".