PDA

View Full Version : Auto Generating Sequential Numbers in Excel 2003


AJKT
Apr 27, 2008, 01:50 PM
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?

JBeaucaire
Apr 27, 2008, 11:08 PM
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.

mdosh01
Apr 28, 2008, 04:21 PM
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".