On the Accounts spreadsheet, you enter data in cell ranges based on historical averages or by indicating starting values and increments.
To enter data in cell ranges:
On the Accounts view, highlight a range of cells.
Select Edit then Fill.
Select an option:
Historical Average—Bases data on the historical average.
Linear—Starts the range at one value and adjusts through time:
Start Value—Enter the value for the first highlighted period.
Step Value—Enter the amount (negative or positive) to adjust the value for each successive time period.
Click OK.
To enter data in cell ranges: