Skip to main content

logoCorrectSize.png

Workday Adaptive Planning Knowledge Center

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

You have 3 adjust options:

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

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

Adjust Data in Sheets

  1. Open Sheets.
  2. Select a cell or range of cells.
  3. Right-click > Adjust
  4. Select a radio button
    • 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

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 unlocked 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 unlocked 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 unlocked 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 unlocked 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 unlocked 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 unlocked cell's value from the current value.

Cell 1: 900

Cell 2: 1,800

Cell 3: 2,700

  • Was this article helpful?