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.