Discover how to add and delete range names.
When to use
A range name is used to replace a cell reference with text. In spreadsheets, used appropriately and sparingly, great value can be obtained from using range names, as it can make formulae easier to read.
Adding Range Names
- There are various ways range names may be created in Excel. One way is to use the Name Box:
- Once you have decided upon a name for your range, perhaps the quickest way of all to add a range name such that it is easy to edit it is using the Name Manager (CTRL + F3):
- In Excel 2007 and later versions, if you click on ‘New…’ (above), the following dialog box appears:
- Note the highlighted section (Scope). All names have a scope, either to a specific worksheet (also called the local worksheet level) or to the entire workbook (also called the global workbook level).
- Never duplicate a range name within a workbook. It can cause formulaic errors. Also, try never to have range names on a worksheet that may be copied.
Deleting Range Names
- Use the CTRL + F3 shortcut for the Name Manager box to appear:
- Use the CTRL or SHIFT buttons to make multiple selections before hitting the ‘Delete’ button. In fact, range names may be even filtered to find names with errors, scoped to the workbook, scoped to the worksheet etc.
Lesson notes are only available for subscribers.