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>.

See Also:

Changing Exl-Plan

Making Simple Changes

Plugging New Variables into an Existing Variable

Extending the Power of Plugging In

Using Formulae Instead of Values

Changing Report Layouts

Changing Column Widths

Combining Simple Changes

Making Complex Changes

Extending Exl-Plan



Online:  Support   Purchase