# Cell State Dialog

The Cell State dialog allows you to enable or disable the execution of cells either explicitly or conditionally, based upon the value of a reference cell. Disabled cells are not executed when Spreadsheet updates, so these cells retain their current values indefinitely unless they are re-enabled.

## Configure the State of One or More Cells

1. Select a cell or a range of cells in Spreadsheet.

2. Click on the Edit Cell State button in the Spreadsheet toolbar, or right-click on the cell and select Cell State.

3. Choose one of the following states for the selected cell or cells:
   - Disabled: Selected cell or cells do not execute upon trigger.
   - Enabled: Selected cell or cells execute upon trigger.
   - Conditionally Enabled: Selected cell or cells are enabled if the value of the reference cell is non-zero.
4. If you chose Conditionally Enabled in the previous step:
   1. Choose either Relative or Absolute for the type of cell reference. For more information, see Cell References.

   2. Enter the cell reference manually in the text box, or click Select Cell to enter cell selection mode.

      Note: If a cell references itself, the reference is ignored.

      The value of the referenced cell determines whether the cell you are editing is enabled or disabled. If the value of the referenced cell is zero, the referencing cell is disabled.

   3. Click OK.

## Copy and Paste Cell States

If you copy and paste a cell with a Conditionally Enabled state, the state of the pasted cell depends on the type of reference that was defined as the conditional reference for the copied cell.

If the cell reference for the copied cell is absolute, the pasted cell retains the absolute cell reference.

If the cell reference for the copied cell is relative, the pasted cell changes the cell reference so that it is relative to the new cell position.

However, if you cut and paste a cell with a relative cell reference in the cell state instead of copying the cell, the cell reference for the pasted cell points to the same cell as in the original cell.