To Automatically Fill Cells With Incremented Data

  1. Double-click inside a cell.
  2. Enter a numeric value; for example, 1 or 01/01/2000.
  3. On the Text Editor contextual ribbon, click Close.

    To change the format of the cell data, right-click the cell. Select Data Format.

  4. Select the cell and Click the grip in the lower right corner.
  5. Drag the grip through the cells you would like to automatically increment.

    A preview of the value for each cell will display to the right of the selected grip.