Auto Generating Sequential Numbers in Excel 2003

AJKT · #1 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?

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".



At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to: Get free answers from experts in any of our 300+ topics. Accept money for answers that you provide. Communicate privately with other members (PM). See fewer ads. Sign Up!