Adjust the Values of Multiple Cells

Explains how to edit existing values in one or more cells with Adjust.

Audience: Planners who enter data in sheets.

Adjust is a right-click action in all sheets that lets you increase or decrease the overall value of a range of cells.

• Cells with numerical data.
• Multiple cells in a row, column, or across a range.

• Distribute Adjustment: Takes the value you enter and distributes it to the current values of the cells either proportionally or evenly.
• Apply Individually: Decreases or increases the adjustment to each cell by percent or value.

• Rollup cells (blue) if your selection also contains the rollup's contributing cells.

You replace formulas in cells when you use Adjust.

When to Use

• Correct Overages or Deficits: Your estimated quarterly budget is over by 1,000. Select all the cells in the account row for the quarter and adjust by -1,000. If you're managing multiple accounts, select all the cells in all the accounts for the quarter and adjust them.
• Adjust Copied Data: You copied the data from last year's actuals into this year's budget. Increase or decrease all the values in a sheet, column, or row by 10% and then review and adjust as needed for your budget.

How You Get There

From the nav menu select Sheets, Assumptions, or Processes. Once you open a sheet, select a version and choose a level. You must choose a leaf level to edit cells.

1. Select a cell or range of cells.
• For distribute options, enter a negative or positive integer.
• For the individual option, select Decrease or Increase, enter a positive integer, and select Value or Percent (%).
4. Click OK

The table illustrates different adjustment methods. The starting values are:

Cell 1:1000

Cell 2: 2000

Cell 3: 3000

Method Adjustment Value What Happens Resulting Cell Values

Enter a positive integer to increase and a negative integer to decrease.

Example: 1000

Cell 1: 1,166

Cell 2: 2,333

Cell 3: 3,500

Enter a positive integer to increase and a negative integer to decrease.

Example: 1000

Cell 1: 1,333

Cell 2: 2,333

Cell 3: 3,333

With Increase and Value

Enter a positive integer.

Example: 100

Cell 1: 1,100

Cell 2: 2,100

Cell 3: 3,100

With  Decrease and Value

Enter a positive integer.

Example: 100

Subtracts the adjustment from each editable cell.

Cell 1: 900

Cell 2: 1,900

Cell 3: 2,900

With Increase and Percent (%)

Enter a positive integer. Do not include the percent symbol.

Example: 10

Adds the percentage of each editable cell's value to the current value.

Cell 1: 1,100

Cell 2: 2,200

Cell 3: 3,300

With Decrease and Percent (%)

Enter a positive integer. Do not include the percent symbol.

Example: 10

Subtracts the percentage of each editable cell's value from the current value.

Cell 1: 900

Cell 2: 1,800

Cell 3: 2,700