Computer Help A to Z Easy Tips
Computer Help Made Simple
Home Mobile Computing John & Renie Computer Terms DLLs & Drivers Links
Computer Threats Computer Basics Hardware Software Easy Tips Tech Talk


Make a numbered list
by John Anthony


When using Excel it may be necessary to create a series of numbers or dates.
Excel has a way to automatically generate the series for you.


For Excel 2010

To make a numbered list:
  1. Open Excel and enter ‘1’ or the starting number for your list in a cell.

  2. Enter 2 or the next number in the series you want to create.

    The difference (step valve) between these two numbers will be used between all numbers in the series.

  3. Highlight both cells.

  4. Move your cursor to the lower right hand corner of the second cell until it becomes a fine plus + sign.

  5. Click the left mouse button and pull the + sign to expand the series as far as you need.
    When you release the mouse button the series of numbers will fill the expanded selection.


For Excel 2000

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.

rule

Contact Information

Computer Help A to Z
88 Windmere Drive
Angier, NC 27501

ComputerHelpAtoZ@embarqmail.com

Copyright 2000-2015

Home Mobile Computing John & Renie Computer Terms DLLs & Drivers Links
Computer Threats Computer Basics Hardware Software Easy Tips Tech Talk