Adjusting Values

  To increase or decrease data values:

  1. Select the cells to adjust.

    You can adjust data for multiple cells simultaneously, if the writable cells are at the same level. For example, you can adjust the data for February and March simultaneously, but not for March and Q1. See Selecting Cell Ranges.

  2. Select Edit, and then Adjust.

  3. Perform an action:

    • To increase or decrease values by a specified amount, from Adjust Data, select By Value, select Increase by or Decrease by, and then enter the value to spread.

    • To increase or decrease values by a percentage, from Adjust Data, select By Percentage, select Increase by or Decrease by, and then enter the percent value.

  4. Click Adjust Data.

    The values are displayed, with the number of decimal places that was set for the form.

  5. Click Save.

You cannot adjust a data value if a member is read-only or is missing information.

Tip:

For information on how adjusting data may affect other cells, see How Spreading Data Works.