Entering Ranges of Data with Linear Values or Historical Averages

On the Accounts spreadsheet, enter data in cell ranges based on historical averages or by indicating starting values and increments.

  To enter data in cell ranges:

  1. In the Accounts view, highlight a range of cells.

  2. Select Edit, and then Fill.

  3. 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.

  4. Click OK.