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.

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

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   Free Registration   Purchase Upgrade