Holding Cells Whilst Spreading¶
With all of the spread types you can also ‘Hold Cells’ so that the spread only occurs for the cells not held. For example, the salaries below will be increased by 8% excluding the Inventory Planner.
To hold a cell, you select the cell and then either press the Hold button on the toolbar or press the shortcut key “H” and to un-hold a cell you can select it and press the “H” key again or use the “Un-Hold All” toolbar button
Hold the select cell
Clear all “Held” cells
This then turns the cell orange:
The spread can then be applied excluding the Inventory Planner: