Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Reference: Clearing Data in Cells

Reference: Clearing Data in Cells

When you clear data, it can result in:
  • Blanks.
  • Zeros.
Zeros and blanks act differently in formulas that reference the cells.
For level drop-down cells and text selectors in modeled sheets, the only way to clear a cell of the current data is to select a different option.
Clearing Method
Result
Refresh
 button
For unsaved data only in white or blue cells.
Reverts to original data.
Right-click >
Clear
For saved or unsaved data in white cells.
  • Replaces data with blanks for most data and drop-down prompts.
  • Replaces data with zero for cumulative accounts that have the
    Plan by Delta
     setting.
Blue cells don't have the
Clear
 option.
Enter zero
For saved or unsaved data in white cells.
Clears calculated data from shared formulas.
Backspace or Delete keys
For saved or unsaved blue cells.
Replaces data with zeros for the rollup cell and all contributing cells.
Delete Row
 button
For modeled sheets only.
Removes the entire row and all data in the row.