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 <http://www.planware.org/exldesc.htm> and for trial copy downloads go to <http://www.planware.org/exldown.htm>.
Making Complex Changes
General Procedure for Complex Changes
Inserting an Additional Expense Item
Inserting a New Balance Sheet Item