Define Constant Values

In both XP/2003 Excel, you can define a Constant Value that can be used over and over again in your formulas. Let's say that you wanted a Constant Tax Rate of 5%. Follow these steps for an example:


Your worksheet will now print with the file path and name in your Header or Footer. This will change if the file's location changes as well.

Tip is by Helen Bradley, from PC Magazine 4 May 2004.
home button   Just click on the button for the Tiproom's Home Page.
Date of last revision: 26 January 2006.