Spreading Data with Cell Locking

When spreading data over time periods, you can temporarily lock the values of one or more cells to preserve their values when other values are recalculated.

You can spread data across time periods based on various calculations and visually review the changes before committing them to the database. For examples of spreading with cell locking, see Examples of Spreading Data with Cell Locking in Working with Planning.

To temporarily lock values:

1. Open a form.
2. In the form, select the cell or group of cells that you want to lock.
3. From the provider ribbon, select Adjust, and then select Lock.

   A color change indicates that a cell is locked. You can now spread or manipulate data in the other cells however you want, without affecting the locked cells.

4. To unlock a cell, refresh the sheet.