Enter a numeric value; for example, 1 or 01/01/2000.
Press the down arrow and enter the next desired numeric
value.
On the Text Formatting toolbar, click OK.
To change the format of the cell data, right-click the cell.
Choose Data Format.
Select the cell or cells from which you want to increment data
from.
Click the grip in the lower right corner of the cell or cells.
To change AutoFill options, right-click the AutoFill grip in the
bottom right-hand corner of the selected cell range and select one
of the following options:
Fill Series. Finds a pattern in the
range of selected cells and fills the selected cells with the
subsequent cell format and value. If only 1 cell is selected from
which to increment data, then the data will increment at a rate of
1 unit.
Fill Series Without Formatting. Follows
the above guidelines without cell formatting.
Copy Cells. Copies the format and
values for the selected cells.
Copy Cells Without Formatting. Follows
the above guidelines without cell formatting.
Fill Formatting Only. Fills only cell
formatting for the selected cells. Cell values are ignored.
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.