2007 Microsoft® Office System Plain & Simple

Creating a Series

When you’re working with a series—that is, a particular set of data such as a series of dates or a list of consecutive numbers—numbering or labeling all the items in the series can be quite time consuming. Why not put your time to better use by letting Excel do the work for you? All you need to do is make sure that Excel recognizes the data as a series.

Create a Series

1. Type the first item in the series.

2. Point to the bottom-right corner of the cell until the mouse pointer turns into a cross (the Fill handle).

3. Drag the Fill handle to ...