Wednesday, February 22, 2012

How to Create Sequential Numbers on an Excel Document With Software


1. Type the first number of your sequence into the cell corresponding to the top position of your list. For example, if you wanted to start your numbering sequence in the top left corner of the spreadsheet, you could type '1' into cell 'A1.'
2. Type the second number of your sequence into the cell corresponding to the second position of your list. For example, you could type '2' into cell 'A2.' Add more numbers to your sequence if the numbering pattern isn't recognizable after two numbers.
3. Click on the top cell in your sequence and drag your mouse to select the rest of your starting values.
4. Click the 'fill handle' in the bottom right corner of the bottom cell, then drag the handle down until all of your required cells are included within the selection. For example, if you entered '1' and '2' into cells 'A1' and 'A2' respectively and wanted to create a 20-number sequence, you would drag the handle to cell 'A20.'
5. Release the left mouse button to fill your selected cells with a list of sequential numbers.

Blogger news