Skip to main content

logoCorrectSize.png

Adaptive Insights LLC.

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. 

Use adjust for:

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

How Adjust Works

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

The adjustment ignores:

  • Read-only cells (gray) in your selection. 
  • 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.

Before You Begin

How You Get There

Compass.png 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.

See Open Sheets and Get to Editable Cells.

Adjust Data in Sheets

  1. Select a cell or range of cells.
  2. Right-click and select Adjust
  3. Choose a radio button
    • 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
  5. Save your sheet.

Adjustment Types

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

Distribute adjustment proportionally 
 

 

 

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

Example: 1000

The adjustment spreads across the editable cells of your selection in proportion to the existing values. 

Cell 1: 1,166

Cell 2: 2,333

Cell 3: 3,500

Distribute adjustment evenly 

 

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

Example: 1000

The adjustment spreads evenly across the editable cells of your selection.

Cell 1: 1,333

Cell 2: 2,333

Cell 3: 3,333

Apply adjustment individually

With Increase and Value

Enter a positive integer.

Example: 100

Adds the adjustment  to each editable cell.

Cell 1: 1,100

Cell 2: 2,100

Cell 3: 3,100

Apply adjustment individually

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

Apply adjustment individually

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

Apply adjustment individually

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

  • Was this article helpful?