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 <http://www.planware.org/exldesc.htm> and for trial copy downloads go to <http://www.planware.org/exldown.htm>.