Tip of the Day – Excel 2007: Create a Linear Series of Values

Create a Linear Series of Values in Excel

Here’s how to use Auto Fill to create a series of values:

  1. Create the initial series. In a Microsoft Office Excel workbook, type 1 in the A1 cell and 2 in the A2 cell.

  2. Select cells A1 and A2.

  3. Click the Auto Fill handle (the little black box in the lower-right corner of the selection) and drag to A15 to fill the cells with the numbers 1 through 15. You can create different series of numbers, odd and even numbers, or even dates.

See the Video Below

Comments (0)

Skip to main content