Microsoft Office Tutorials and References
In Depth Information
Taking the Drudgery out of Data Entry
As you drag your finger or stylus through blank cells, the Name box
on the Formula bar keeps informed of the next entry in the data series.
When you release your finger or stylus from the touchscreen after
selecting the last blank cell to be filled, Excel fills out the data series in
the selected range.
Doing AutoFill with the Fill button on the Home tab
If you’re using Excel 2013 on a touchscreen tablet without the benefit of a
mouse or touchpad, you can do AutoFill from the Ribbon (you may also want
to use this method if you find that using the fill handle to create a series of
data entries with AutoFill is too taxing even with a physical mouse).
You simply use the Fill button on the Home tab of the Ribbon to accomplish
your AutoFill operations as follows:
1. Enter the first entry (or entries) upon which the series is to be based
in the first cell(s) to hold the new data series in your worksheet.
2. Select the cell range where the series is to be created, across a row or
down a column, being sure to include the cell with the initial entry or
entries in this range.
3. Click the Fill button on the Home tab followed by Series on its
dropdown menu or press Alt+HFIS.
The Fill button is located in the Editing group right below the AutoSum
button (the one with the Greek sigma). When you select the Series
option, Excel opens the Series dialog box.
4. Click the AutoFill option button in the Type column followed by the
OK button in the Series dialog box.
Excel enters a series of data based on the initial value(s) in your
selected cell range just as though you’d selected the range with the
Note that the Series dialog box contains a bunch of options that you can use
to further refine and control the data series that Excel creates. In a linear
data series, if you want the series to increment more than one step value at
a time, you can increase it in the Step Value text box. Likewise, if you want
your linear or AutoFill series to stop when it reaches a particular value, you
enter that into the Stop Value text box.
When you’re entering a series of dates with AutoFill that increment on
anything other than the day, remember the Date Unit options in the Series dialog
box enable you to specify other parts of the initial date to increment in the
series. Your choices include Weekday, Month, or Year.