Data spreading and hold syntax

You can apply most data spreading and hold methods using a syntax that you enter directly in cells.

You must use the user interface to apply the repeat leaves and equal spread across leaves methods. You must use the user interface to spread across a selected range of cells.

Each data spreading syntax expression consists of a method code, a data action (optional), and method parameters.

For example: s+100

The method code is s, the data action is +, and the method parameter is 100.

The method code is a one- or two-character code for a data spreading method. For example, S is the method code for the equal spread method. For more information, see Data spreading and hold syntax reference table.

The data action indicates whether spread values will replace, be added to, or be subtracted from the existing cell values.

Replace: If you do not specify an action, the existing cell values are replaced with the spread values.
Add: Plus sign (+) adds spread values to the existing cell values
Subtract: Tilde (~) subtracts spread values from the existing cell values.

The method parameters supply all parameters required to execute a given spreading method. Most methods require only a parameter indicating the value to be spread. The required method parameters for each spreading method are listed in Data spreading and hold syntax reference table.