With Smart Edit, you can quickly make changes to multiple values in a numerical column. Rather than change each value individually, you select all of the values you want to change, and then use Smart Edit to add, subtract, multiply or divide the existing cell values with a number you specify.
To apply a Smart Edit follow these steps:
Select all of the cells that you want to edit in one action.
Make sure you only select cells in one column - Smart Edit can only be used on one (numeric) column at a time.
You might find it easier to select the values you want to change if you filter the grid first (see Column Filters).
In the Smart Edit popup, use the combo-box to choose the type of mathematical change you want to make
In the field next to the combo-box, enter the value for the change. For example, if you want to multiply the existing cell value by 4, enter 4 in the field.
In the Preview panel, you can see what effect the value change will have on the cell values. You can also see if the change will break a Cell Validation rule.
If the change will not break a cell validation rule, the Apply to Grid button is green.
If the change will break a cell validation rule, but the rule can be overridden, the Apply to Grid button is orange and has a warning icon.
If the change will break a cell validation rule and the rule cannot be overridden, the Apply to Grid button is unavailable.
Click Apply to Grid.
If your changes are valid, the selected cell values will update.
If your changes are invalid, but can be overridden, you are given a choice. Click OK to apply the changes and ignore the cell validation rules or click Cancel to abort.