How to Create a Constant in Microsoft Excel

Are you frequently using the same value in your Microsoft Excel spreadsheet? If so, then it’s time to create a constant. A constant is a name that represents a value that doesn't change--and creating one is simple.

Instructions

Difficulty: Easy

1. Select Name from the Insert Menu.
2. Click Define.
3. When the Define Name dialog box appears, type the name of your constant in the Names in workbook text box.
4. In the "Refers to" text box, delete the entire formula except for the equal sign.
5. Type the numeric value of your constant after the equal sign.
6. Click OK.
7. Test your constant: Create a formula using the name of your constant instead of the actual value.