Entering Values Quickly with AutoFill

AutoFill is a feature that automatically fills in data based on the data in adjacent cells . Using the fill handle , you can enter data in a series, or you can copy values or formulas to adjacent cells. A single cell entry can result in a repeating value or label, or the results can be a more complex series. You can enter your value or label, and then complete entries such as days of the week, weeks of the year, months of the year, or consecutive numbering.

Enter Repeating Data Using AutoFill

Select the first cell in the range you want to fill.

Enter the starting value to be repeated.

Position the pointer on the lower-right corner of the selected cell. The pointer changes to the fill handle (a black plus sign).

Drag the fill handle over the range in which you want the value repeated.

Create a Complex Series Using AutoFill

Enter the starting value for the series, and then press Enter.

Select the first cell in the range you want to fill.

Position the pointer on the lower-right corner of the selected cell. The pointer changes to the fill handle (a black plus sign).

Drag the fill handle over the range in which you want the value repeated.