Skip to main content
Adaptive Insights
Knowledge @ Adaptive Insights LLC, a Workday company.

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

Adjust takes the value you enter and distributes it to the current values of the cells:

  • Proportionally: Distributes in proportion to the existing values.
  • Evenly: Distributes evenly within the selection.
  • By Increment: Applies the adjustment to each cell.

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 your 1 adjustment type and 2 enter an integer. See Adjustment Types in the following section.

    Adjustment dialogue with adjustment type and values.
     
  4. Click Apply
  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

Change proportionally by
 

 

 

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

Change evenly by

 

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

Increment by 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

Decrement by 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

Increment by 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

Decrement by 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?