Applying Leaf Holds

You can apply a Leaf Hold to a single cell or to a range of cells.

Procedure

  1. Select the cell or range.
  2. Right-click the cell or range.
  3. Click Holds, Hold Leaves.

    When you apply a Leaf Hold to a consolidated cell, a hold applies to all leaves of the consolidation that contain non-zero values. The following figure illustrates the effect of applying a leaf hold to the selected consolidated cell. All populated leaves of the consolidation are held. The leaves without values (Argentina and Uruguay) are not held.

    A view with values in the Brazil and Chile January cells showing the red triangle that indicates the cells have a hold on them.

    For details on holding consolidation values constant while adjusting underlying leaf values, see Holding Consolidation Values Constant.

Parent topic: Excluding Cells from Data Spreading