Ten Minute Guide to Excel 97

Entering a Series with AutoFill

Entering a series (such as January, February, and March or 1994, 1995, 1996, and 1997) is similar to copying a cell's contents. As you drag the fill handle of the original cell, AutoFill does all the work for you, interpreting the first entry and creating a series of entries based on it. For example, if you type Monday in a cell, and then drag the cell's fill handle over some adjacent cells, you'll create the series Monday, Tuesday, Wednesday…. As you drag, the bubble lets you know exactly what you're copying so that you can stop at the appropriate cell to create exactly the series you want.