Series & AutoFill

A series is a sequence of cells that forms a logical progression. Excel's AutoFill feature can generate a series of numbers, months, days, dates, and quarters.

To create a series with the fill handle

1.
Enter the first item of the series in a cell (Figure 36). Be sure to complete the entry by pressing or or clicking the Enter button on the formula bar.
Figure 36. To create an AutoFill series, start by entering the first value in a cell.
2.
Position your mouse pointer on the fill handle and drag. All the cells that will be part ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.