Counting list

%3CLINGO-SUB%20id%3D%22lingo-sub-2217943%22%20slang%3D%22en-US%22%3ECounting%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2217943%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20get%20excel%20to%20enter%20increasing%20numbers%20into%20a%20selected%20column's%20cells.%26nbsp%3B%20For%20example%2C%20in%20Cell%20A1%20I%20put%20number%201%2C%20in%20cell%20A2%20I%20put%20number%202%2F%26nbsp%3B%20I%20highlight%20cells%20A1%2C%20A2%2C%20all%20the%20way%20to%20A30.%26nbsp%3B%20I%20want%20excel%20to%20enter%20increasing%20numbers%20from%20A3%20to%20A30.%26nbsp%3B%20So%2C%20the%20numbers%201%2C%202%2C%203%2C%204%2C%205%20to%2030.%26nbsp%3B%20Thus%2C%20cells%20A1%20to%20A30%20would%20have%20number%201%20thru%2030%20entered%20in%20them.%26nbsp%3B%20Instead%20of%20having%20to%20manually%20enter%2C%201%2C%202%2C%203%2C%204%2C%20all%20the%20way%20to%2030.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2217943%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

How do I get excel to enter increasing numbers into a selected column's cells.  For example, in Cell A1 I put number 1, in cell A2 I put number 2/  I highlight cells A1, A2, all the way to A30.  I want excel to enter increasing numbers from A3 to A30.  So, the numbers 1, 2, 3, 4, 5 to 30.  Thus, cells A1 to A30 would have number 1 thru 30 entered in them.  Instead of having to manually enter, 1, 2, 3, 4, all the way to 30.

Thanks

3 Replies

@cp1121 

Enter 1 in A1 and 2 in A2.

Select A1 and A2.

Drag the fill handle (the little black square in the lower right corner of A2) down to A30.

 

Or:

 

Enter 1 in A1.

On the Home tab of the ribbon, select Fill > Series...

Select that you want to fill a series in Columns, specify 30 as Stop Value and click OK.

Oh my, thank you so much. That's incredibly easy. I've been entering numbers manually for years. I guess Excel is more powerful than I thought. I have a lot to learn about its potential.

Untitled.png

 

@cp1121 

 

  • Put 1 in cell A1 and 2 in cell A2.
  • Select cells from A1 to A30.
  • Go to Fill and select Series...
  • In Series box choose AutoFill

Done.

 

See the printsecreen above.

 

Hope this helps.

 

Regards,

IlirU