Tom’s Tutorials For Excel: Filling Series For Linear and Growth

Tom’s Tutorials For Excel: Filling Series For Linear and Growth
Here is an example of building a table of projected sales and income, using three Fill methods of Series, Linear, and Growth.

TIP:


First Example: Fill Series (add a year number to each filled cell)
• Enter the first year of your data, example 2010 in cell A4.
• Select cell A4 and drag its fill handle down while pressing the right mouse button.
• Release the right mouse button, and from the popup menu, select Fill Series.


Second Example: Series, Growth (project your Unit Sales to double every year)
• Enter your first item of data in the Unit Sales column, example 31 in cell B4.
• Select cell B4 and drag its fill handle down while pressing the right mouse button.
• Release the right mouse button, and from the popup menu, select Series.
• In the Series dialog box, select Growth (as Type).
• I entered 2 for Step value, projecting each year’s Unit Sales to double.
• Click OK.


Third Example: Series, Linear (add a specific static number to its previous number)
• Enter your first item of data in the Unit Price column, example $49 in cell C4.
• Select cell C4 and drag its fill handle down while pressing the right mouse button.
• Release the right mouse button, and from the popup menu, select Series.
• In the Series dialog box, select Linear (as Type).
• I entered 3 for Step value, because I expect to raise my Unit Price by $3 every year.
• Click OK.


Final Result !!