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 Proportionally and Distribute Adjustment Evenly: Takes the value you enter and distributes it to the current values of the cells either proportionally or evenly.
• Apply Adjustment 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. Example:  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. Example: 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.

Prerequisites

Security:

• Editable Sheet Access permission.
• (Optional) Edit Dimensions on Sheet permission.

1. Open Sheets.
2. Select a cell or range of cells.
• For either 2 of the distribute options, enter a negative or positive integer.
• For the individual option, click Decrease or Increase, enter a positive integer, and click Value or Percent (%).
5. 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 unlocked 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 unlocked 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 unlocked cell's value from the current value.

Cell 1: 900

Cell 2: 1,800

Cell 3: 2,700