Modify Selected Items

The Modify Selected Items form displays when you click Modify Selected Items on the Budget New Worksheet Form (Posted Adjustment).

Use this form to modify selected (highlighted) items on the budget worksheet.

Note: This form is a convenient way to edit a group of budget items; sometimes, however, it is easier to just perform budget item edits by typing in the new information on the budget worksheet.

Method:Select one of the following methods:

  • Increase selected items by an amount: Use this method to add the amount entered in the Value box to every selected cell in a budget entry column.
  • Decrease selected items by an amount: Use this method to subtract the amount entered in the Value box from every selected cell in a budget entry column.
  • Increase selected items by %: Use this method to increase every selected cell in a budget entry column by the percentage entered in the Value box.
  • Decrease selected items by %: Use this method to decrease every selected cell in a budget entry column by the percentage entered in the Value box.
  • Allocate fixed increase among selected items: Use this method to evenly distribute the amount entered in the Value box among the selected cells in a budget entry column.
  • Allocate fixed decrease among selected items: Use this method to evenly reduce the amounts selected in a budget entry column by the amount entered in the Value box.
  • Set each selected item to an amount: Use this method to replace the amounts selected in a budget entry column with the amount entered in the Value box.
  • Set each selected item to zero: Use this method to replace the amounts selected in a budget entry column with zero.

Value: Enter the monetary amount or percentage to modify the selected cells. "Set each selected item to zero" does not need an amount entered.

When entering percentages in the system, do not include a decimal point. For fractional percentages, the leading zeros must be entered. For example, enter the following numbers to indicate the percentages.

0005 = .5%

005, 05, or 5 = 5%

50 = 50%

Budget Lines Only: Check the box to apply the criteria only to budget lines. Leave unchecked to apply to both budget and comment lines.

 

Click OK to save the modifications or Cancel to discard the modifications.