Make a Numbered List in Excel


Make a list of any size easily 


When using Excel it may be necessary to create a series. A series is different than copying the same cell to many other cells. It is very handy when you want to make a numbered list or a list of dates. To make a numbered list: 

1) Open Excel and enter ‘1’ or the starting number for your list in a cell. 

2) Beginning with this cell, highlight all the cells that will be in the list. 

3) Click Edit on the menu bar, select Fill from the drop-down list and select Series from the menu that appears. A dialog box opens. 

4) In the 'Series In' section, select column or row depending on how your selected cells run. 

5) In the Type section, choose Linear. 

6) In the 'Step value', choose how you want the list to count: 

·         If you choose a step value of one, each member of the list is incremented by one and the list becomes 1,2,3, etc. 

·         If you choose two for a step value, the generated list becomes 1,3,5 etc. 

7) Click OK to generate your list.