Erasing Existing Values

Using Exl-Plan > Starting to Use Exl-Plan > Erasing Existing Values

Rows not needed in assumption reports MUST NOT be deleted.  Instead, they should be left empty or with zero values. Depending on Excel's set-up, zeros may appear as empty spaces.

Note that Exl-Plan offers the option to suppress the printing of unused rows in output reports (*Tools/Setup > No Empty Rows Printed).

To simultaneously erase all assumptions, use the *Tools/Setup > Clear All Assumption Reports or *Tools/Setup > Clear Current Assumption Report menu commands.  Note that these commands ignore:

As this approach could lead to a failure to clear all assumptions, Exl-Plan automatically tests whether all assumptions have been successfully removed. A warning message will be issued if it finds that any assumption values have not been removed.

To erase assumption values within an unlocked range (i.e. the blue numbers within the rectangular, cream, boxed-in areas), use the DEL key, or select the range of assumptions to be deleted and use either *Assumptions > Clear Assumptions or its corresponding toolbar button.

To ensure that formulae etc. are not accidentally erased, regularly check that *Protection > Protect All Worksheets is enabled.

See Also:

Gathering & Entering Assumptions

Structuring a Model

Summary of Procedure for Generating Projections

Setting Up Exl-Plan

Entering Assumptions

Entering Prior-Year Income Statement & Opening Balance Sheet

Completing Projections

Avoiding Calculation Errors

Doing Sensitivity Analyses

Guidance on Entering Assumptions

Changing Exl-Plan