Make a list of any sizeeasily
When using Excel it may be necessary to create a series. A seriesis different than copying the same cell to many other cells. It is very handywhen you want to make a numbered list or a list of dates. To make a numberedlist:
1) Open Excel and enter ‘1’ or the starting number for your list in acell.
2) Beginning with this cell, highlight all the cells that will be in thelist.
3) Click Edit on the menu bar, select Fill from the drop-down list and selectSeries from the menu that appears. A dialog box opens.
4) In the 'Series In' section, select column or row depending on how yourselected 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 stepvalue of one, each member of the list is incremented by one and the listbecomes 1,2,3, etc.
· If you choose two fora step value, the generated list becomes 1,3,5 etc.
7) Click OK to generate your list.