Managing Range Names in Excel

The new Name Manager provides an easy way to manage all the range names and table names in your workbook from one location. From the Name Manager, you can delete named ranges that you no longer need, edit the name or cell reference of existing names, add new names as well as sort filter your ranges.

The Name Manager command button is found on the Defined Names group of the Formulas Ribbon.

To Manage Named Ranges

1. Click the Formulas tab on the Ribbon.
2. Click the Name Manager button on the Defined Names group.
3. To delete a name, select the name you wish to remove and click the Delete button.
4. To modify a name, select the name you wish to modify and make your changes. Click OK when finished.
5. To create a new name, click the New button, type in the name for your range, and enter the cell reference (or use the collapse dialog box to manually select the range)
6. To sort your name list, click the column header to sort the names in ascending or descending order.
7. To filter names, click the Filter button and select the filter option you want.
8. Click OK when finished.

Similar Posts:

• Using a Named Range in Excel
• Naming a Range in Excel
• Sort Multiple Columns in Excel 2007
• Managing Conditional Formatting in Excel 2007
• Sorting Data in an Excel Table
• Using AutoFilter in Excel 2007
• Creating a Table in Excel

Tagged as: Excel Tips, Microsoft Office Tips