Excel2007:Naming spreadsheet regions

Overview
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.

A simple named cell
This short video explains how a named cell can be used in an Excel spreadsheet instead of an absolute reference.




 * 1) Create the spreadsheet as shown
 * 2) Click on the cell containing the discount (G4)
 * 3) Click on the Name Box top left below ribbon bar(should contain G4).
 * 4) type in disc then press [Enter] (Note: forgetting to press enter may result in the range not being entered into the spreadsheet)
 * 5) Enter the formula for the first Hard Disc Discount by..
 * 6) in G7 enter =
 * 7) click on F7
 * 8) click on * (times)
 * 9) Press [F3] to bring up the named range dialog box
 * 10) Select disc (it will now be placed into the formula)
 * 11) press [Enter] to accept the formula
 * 12) Copy the formula down
 * 13) With G7 selected, float the mouse over the plus in the bottom right corner of the cell
 * 14) click and drag downwards
 * 15) Finally, check that the results look right !!