Creating worksheet Constants

You can create worksheet constants using names. These constants can be referred to by their name but they won't relate to any cell on a worksheet. To create a constant called Increase, select Insert, Name, Define and type Increase in the Name text box. In the Refers To text box type the value of the constant, for example, =.08 to make the Increase 8%. Select OK to continue. You can then refer to the constant Increase anywhere in your workbook just as you would any other named range.