At the beginning of this process, select the range of cells B5:D16.The procedure of this process is explained below: In addition, this option will also supply us with a chart for understanding the data trend. This command provides us a maximum and minimum range of their possible values. Using the Forecast Sheet command located in the Data tab, we can fill a series based on extrapolation. Fill Series Through Forecast Sheet Command Thus, we can say that our methods worked perfectly, and we were able to fill a series based on extrapolation in Excel.Ħ. You will see that the rest of the six cells get their value, and the series extrapolation is completed.Change the Types option from Linear to Autofill.As a result, a small dialog box entitled Series will appear.Again, click on the drop-down arrow of the Fill drop-down and choose the Series option.Now, click on the drop-down arrow of the Editing group.At the beginning of this process, select the range of cells D5:D16.The procedure of this method is given below step by step: As a result, we don’t need to memorize any function and mechanism. In this case, we are going to use the Series command from the drop-down of the Fill dropdown. So, we can say that our methods worked perfectly, and we are able to fill a series based on extrapolation in Excel.ĥ. If the same 6 values are copied in the rest of the 6 cells, then click on the Auto Fill Options icon.Then, drag the Fill Handle icon to fill the series up to cell D16.At first, select the range of cells D5:D10.The procedure to complete this approach is given below: It is the easiest process to fill a series based on extrapolation. In this approach, we will use the Fill Series command from the Fill Handle icon. Using Fill Series from Fill Handle Options

You will get all the extrapolated values of this series.Īt last, we can say that our function worked precisely, and we are able to fill a series based on extrapolation in Excel.Ĥ.After that, double-click on the Fill Handle icon to copy the formula up to cell D16.

How to extrapolate in excel for mac