Excel2007:Naming spreadsheet regions
|Table of contents|
Using names for cells and ranges can greatly simplify formulas. In this example a cell is given a name and used to calculate the discount on a list of computer hardware products.
Objective Named ranges
By the end of this page you will be able to:
A simple named cell
This short video explains how a named cell can be used in an Excel spreadsheet instead of an absolute reference.
| Sniplet:Excel2007:Named Reference|
- Create the spreadsheet as shown
- Click on the cell containing the discount (G4)
- Click on the Name Box top left below ribbon bar(should contain G4).
- type in disc then press [Enter] (Note: forgetting to press enter may result in the range not being entered into the spreadsheet)
- Enter the formula for the first Hard Disc Discount by..
- in G7 enter =
- click on F7
- click on * (times)
- Press [F3] to bring up the named range dialog box
- Select disc (it will now be placed into the formula)
- press [Enter] to accept the formula
- Copy the formula down
- With G7 selected, float the mouse over the plus in the bottom right corner of the cell
- click and drag downwards
- Finally, check that the results look right !!
- If you want to remove a named cell use the Formulas tab, and in the Defined Names Group, select Name Manager