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 fill the cells that you want to be included in the series.

  4. If Excel copied the cell instead of creating a series, or didn’t fill the series as you expected, click the AutoFill Options button, and select Fill Series or any other appropriate option.

  5. Make sure the series is correct. If it isn’t, click the Undo button on the Standard toolbar and try again.

    Create a Series

Tip

Tip

If the Fill Series option isn’t listed on the AutoFill Options shortcut menu, Excel doesn’t recognize the data as a series. You can define your own series by choosing Excel Options from the Office menu, and, with the Popular category selected, clicking the Edit Custom Lists button. In the Custom Lists dialog box, define your list, and click OK.

Tip

Tip

To define a numeric or date series that is nonlinear, that doesn’t use a single-step value, or that is very long, click the Fill button on the Home tab, choose Series from the drop-down menu, and use the Series dialog box to set the parameters for your series.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset