Wednesday, May 15, 2013

How to Create Sequences in Excel

1. Click the first cell in the row or column that you want to contain the sequence and type the first item. For example, to create the sequence of 'Red,' 'Green' and 'Blue,' type the word 'Red.' Press 'Enter' to move to the next row or press the right arrow key to move to the next column.
2. Type the next item in the sequence, such as 'Green.' Press 'Enter' or the right arrow key.
3. Type the next item in the sequence, such as 'Blue.' Repeat this process until you have typed every item in the sequence.
4. Click and drag with the mouse pointer to highlight the cells containing the complete sequence plus the additional first item. You should see a large black square in the lower-right corner of the box outlining the highlighted cells.
5. Click and drag the black square to auto-populate the blank cells below or to the right with the sequence that you have entered. As you drag the square, Excel displays a small pop-up message showing the data that it will put in each cell.
6. Release the mouse button to stop auto-populating the sequence.

Blogger news