Microsoft Office Tutorials and References
In Depth Information
Automatically Filling a Range with a Series
Excel extends the best fit linear sales trend and fills in the missing values. Figure 35-3 shows the
predicted values, along with a chart.
Figure 35-2: Use Autofill to perform a linear regression and predict sales values for August through December.
Figure 35-3: The sales figures, after using Autofill to predict the last five months.
Autofill also works with dates and even a few text items — day names and month names. The
following table lists a few examples of the types of data that can be Autofilled.
Monday, Tuesday, Wednesday, and so on
Quarter-2, Quarter-3, Quarter-4, Quarter-1, and so on
Feb, Mar, Apr, and so on
February, March, April, and so on
Month 2, Month 3, Month 4, and so on
You can also create your own lists of items to be Autofilled. To do so, open the Excel Options
dialog box and click the Advanced tab. Then scroll down and click the Edit Custom Lists button
to display the Custom Lists dialog box. Enter your items in the List Entries box (each on a new