Named Ranges

a very nice feature of Excel is the ability to create named ranges so that cell references or even values can be given a more meaningful definition.
Creating a Named Range

1. To create a named range simply go to the Insert Menu - > Name -> Define
2. This will bring up the Define Name dialog
3. Enter a name in the Names in workbook textbox
4. In the refers to textbox you can enter a the following pieces of information:
• Ranges ($A$1:$A$5)
• Values (10% - could be used for the named range GST)
5. Click the 'Add' button and then 'OK'

Example 1 - create a named range for a range of cells

1. Insert Menu - > Name -> Define





2. This will bring up the Define Name dialog





3. Enter TestRange in the Names in workbook textbox





4. In the refers to textbox, select range A1 to A8 of Sheet 1


5. You can now use this in a formula for example, =Sum(TestRange), will total the values in cells A1:A8 of Sheet1

Example 2 - create a named range for a value

1. Insert Menu - > Name -> Define





2. This will bring up the Define Name dialog





3. Enter GST in the Names in workbook textbox
4. In the refers to textbox, enter =10%





5. You can now use this in a formula for example, =A1*GST, will multiply the value in cell A1 by 10%