Skip to content

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.

Info

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: