To Automatically Fill Cells With Incremented Data

Double-click inside a cell.
Enter a numeric value; for example, 1 or 01/01/2000.
On the Text Editor contextual ribbon, click Close.
To change the format of the cell data, right-click the cell. Select Data Format.
Select the cell and Click the grip in the lower right corner.
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.

Was this information helpful?

Yes
No