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:

  • Open Excel and enter ‘1’ or the starting number for your list in a cell.
  • Beginning with this cell, highlight all the cells that will be in the list.
  • 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.
  • In the ‘Series In’ section, select column or row depending on how your selected cells run.
  • In the Type section, choose Linear.
  • 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.
  • Click OK to generate your list.

Leave a Reply.