Make a Numerical Constant in MS Excel 2007
by Carol Bratt on November, 17 2008 at 08:11AM EST
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!
- Click on the Formula Tab.
- Click Define Name.
- Give the cell a name that is intuitive for you.
- 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!
Filed under:
Rate this article:
Need Help? Ask!
My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).
My name is Dennis Faas and I am a senior systems administrator and IT technical analyst specializing in cyber crimes (sextortion / blackmail / tech support scams) with over 30 years experience; I also run this website! If you need technical assistance , I can help. Click here to email me now; optionally, you can review my resume here. You can also read how I can fix your computer over the Internet (also includes user reviews).
We are BBB Accredited
We are BBB accredited (A+ rating), celebrating 21 years of excellence! Click to view our rating on the BBB.