Microsoft Office Tutorials and References
In Depth Information
Tip 54: Automatically Filling a Range with a Series
the Auto Fill Options when working with a date series. You can quickly create a series of weekdays,
months, or years.
Figure 54-2: Use the Auto Fill Options drop-down list to change the type of fill.
Here’s another AutoFill trick: If the data you start with is irregular, Excel completes the AutoFill action
by doing a linear regression and fills in the predicted values. Figure 54-3 shows a worksheet with
monthly sales values for January through July. If you use AutoFill after selecting C2:C8, Excel extends
the best-fit linear sales trend and fills in the missing values. Figure 54-4 shows the predicted values,
along with a chart.
Figure 54-3: Use AutoFill to perform a linear regression and predict sales values for August through December.