automatically add numbers

kimchi_o · Apr 26th, 2002, 10:28 AM

does anyone know how i would automatically add numbers to a column? the numbers need to be in numerical order. i am a beginner, so detailed help would be greatly appreciated!

Mark W. · Apr 26th, 2002, 10:33 AM

You could use the Edit | Fill | Series... menu command. Or, enter your starting value in a cell, right click on that cell's fill handle (the little black square in the lower right-hand corner of the cell), drag down to the intended last cell, and choose Fill Series from the popup menu.

[ This Message was edited by: Mark W. on 2002-04-26 09:36 ]

kimchi_o · Apr 26th, 2002, 01:22 PM

thank you mark w!

Tom Schreiner · Apr 26th, 2002, 04:57 PM

Thanks Mark!
I did not know you could do that...
Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 10:28 AM	#1
kimchi_o New Member Join Date: Apr 2002 Posts: 2	does anyone know how i would automatically add numbers to a column? the numbers need to be in numerical order. i am a beginner, so detailed help would be greatly appreciated!

Apr 26th, 2002, 10:33 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	You could use the Edit \| Fill \| Series... menu command. Or, enter your starting value in a cell, right click on that cell's fill handle (the little black square in the lower right-hand corner of the cell), drag down to the intended last cell, and choose Fill Series from the popup menu. [ This Message was edited by: Mark W. on 2002-04-26 09:36 ]

Apr 26th, 2002, 01:22 PM	#3
kimchi_o New Member Join Date: Apr 2002 Posts: 2	thank you mark w!

Apr 26th, 2002, 04:57 PM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Thanks Mark! I did not know you could do that... Tom