Skip to main content

How do I delete a Formula?

If the Formula is no longer required

Sandra McCarthy avatar
Written by Sandra McCarthy
Updated over 2 weeks ago

Warning ⚠️ Deleting Formulas is permanent and NOT recoverable

Delete Formula for a whole row in the budget

To delete formulas across an entire row in Calxa:

  1. Navigate to the row where the formula is applied

  2. Enter 0 in the Total column

  3. If the cell value is already zero and the formula icon persists, enter a temporary value like 1, wait for the icon to clear, and then enter 0 to finalize removal.

  4. A prompt will appear asking for confirmation to delete the formula from the whole row.

  5. Review the warning message and then confirm the action by typing DELETE

Delete Formula from a point in time

To delete the Formula from a specific time period forwards:

  1. Begin by highlighting the first cell in the time period where the formula needs to be removed.

  2. Overtype the current value with 0 to eliminate the formula in that cell.

  3. Click the same cell again, access the overflow menu (...), and select Copy to future. This will remove the formula for the rest of the period you have selected.

Delete a Formula for one cell only

To remove a formula from a single cell in Calxa:

  1. Click into the cell containing the formula.

  2. Simply press the 'delete' key on your keyboard to clear the formula. This method works for quick changes to individual cells and is ideal for minor edits.

If the value of the cell is already 0, but you wish to remove the Formula, type a 1, and then when the Formula is removed, return the value to 0.

Update or Change a Formula

If you need to update a Formula, click the cell or cells you wish to change, select Formula from the overflow (...) and make the changes you require. Then click

APPLY FORMULA to confirm the change.

For full details of the Formula settings, see Budgets & Scenarios: Formulas

Did this answer your question?