Deleting a Row

Help Home  Previous  Next

Changing Exl-Plan > Making Complex Changes > Deleting a Row

Delete a row only where strictly necessary as this may require adjustments to numerous formulae in several reports. Instead, consider hiding the row or let Exl-Plan suppress its printing (using *Tools/Setup > No Empty Rows Printed).

In most circumstances, it is likely to be much simpler and quicker to create specially tailored reports as described in Changing Report Layouts than to modify Exl-Plan's existing output reports by deleting rows.

The procedure for deleting rows is indicated below.

1.Save the unaltered model.
2.Delete the first row, calculate using the F9 function key and then proceed to search column-wise throughout Exl-Plan for #REF signs.
3.Locate the first formula initiating an error, remove references to the deleted row within this formula and recalculate.
4.Continue this search process until the model is error-free as confirmed by the Check Balances Report in the Check worksheet.
5.Delete the next row and repeat the foregoing procedure for locating and removing any errors.

You may wish to progress to a more powerful version of Exl-Plan for the purpose of generating more detailed monthly and quarterly multi-year projections and to gain access to a range of powerful planning tools for "what-ifs" sensitivity analyses, profitability improvement etc. For detailed descriptions, visit <> and for trial copy downloads go to <>.

See Also:

Changing Exl-Plan

Making Complex Changes

General Procedure for Complex Changes

Inserting an Additional Expense Item

Inserting a New Balance Sheet Item

Extending Exl-Plan

Online:  Support   Free Registration   Purchase Upgrade