Changing the Name of an Existing Variable

Help Home Previous Next

Changing Exl-Plan > Making Simple Changes > Changing the Name of an Existing Variable

To change the name (but not the underlying context) of a locked variable description in column A, e.g. to alter the description of an expense item in the Assumptions Report No.3 - Overhead Expenses, follow the procedure below.

1.	Get into the Ohead worksheet.

2.	Go to the cell in question; unlock it using *Protection > Unlock Range or "unlock" toolbar button.

3.	Make the desired change.

4.	Lock the cell again using *Protection > Lock Range or "lock" toolbar button.

Repeat this procedure if the original description appears in any of the output reports and is not updated automatically using built-in formulae.

We offer generous terms to users seeking to trade up from a "paid-for" copy of Basic to a more powerful version 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 details, visit this special page at <http://www.planware.org/exltradeup.htm>.