Make a Numerical Constant in MS Excel 2007
- by Carol Bratt on 20081117 @ 06:11PM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: formula, cell)
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!
