1. Automatically Add, Multiply, Divide or Subtract Values
Select a cell containing a numeric value — or any range of such cells — and use Edit > Increment or Edit > Decrement.
By default, these commands add or subtract 1.
You can override this behavior using Edit > Operations to define more complex value‑changing rules.
2. Defining Custom Increment/Decrement Operations
Use Edit > Operations to specify how Increment and Decrement should behave. Operations may include:
- adding a fixed value,
- subtracting a fixed value,
- multiplying,
- dividing,
- or applying a formula that refers to the selected cell(s).
There are five independent increment/decrement settings. The active one is determined by the selected tab in the Operations dialog.
3. Example
1. Define a formula‑based increment (and/or decrement) on the Settings1 tab and activate it:
2. Use the Increment command (Ctrl+Alt+"+") or Decrement (Ctrl+Alt+"-"). Values in selected cells will be modified according to the defined formula:
