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:
- Open Excel and enter ‘1’ or the starting number for your list in a cell.
- 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.
- Highlight both cells.
- Move your cursor to the lower right hand corner of the second cell until it becomes a fine plus + sign.
- 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:
- 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.
Contact Information
Computer Help A to Z
88 Windmere Drive
Angier, NC 27501
CompHelpAtoZ@charter.net
Copyright 2000-2018
|
|
Easy Tips