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.

Contains preview content for the upcoming 2019.3 release.

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?