Make a Numerical Constant in MS Excel 2007

Dennis Faas's picture

In my spreadsheet I have some figures that have be keyed in many, many times. It got to be a drag until I discovered I could make a numerical constant!

Follow the steps below to learn how!

  1. Click on the Formula Tab.
     
  2. Click Define Name.
     
  3. Give the cell a name that is intuitive for you.
     
  4. Put a number in that cell.

You can now use the name in a formula instead of referring to the coordinates.

You can set up as many named cells as you like!

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

Rate this article: 
No votes yet