Wednesday, October 19, 2011

How to Manage Range Names in Excel


1. Start Microsoft Excel and open an existing spreadsheet that contains range names that you would like to manage, filter, edit, delete or create additional range names.
2. Choose the 'Formulas' tab to display the 'Formulas' ribbon. Click the 'Name Manager' button to open the 'Name Manager' dialog box.
3. Click the 'New' button in the 'Name Manager' dialog box to open the 'New Name' dialog box. In this dialog box, you can provide a name, scope, comment, and cell reference for the new range name that you create.
4. Select a range name you would like to edit from the 'Name Manager' list and click 'Edit' to open the 'Edit Name' dialog box. Here you can rename the range, change the scope, edit the comment or change the cell reference.
5. Identify a range name you would like to delete from the 'Name Manager' list and click the 'Delete' button. A dialog box will come up and ask you to confirm that you want to delete the name range. Click the 'OK' button to delete the name range from the 'Name Manager' dialog box.
6. Highlight and click the 'Filter' button on the top right of the 'Name Manager' dialog box to display the filter options available for the name manager. You can filter to find range names that are located in the current workbook, that are located in the current worksheet, that have errors, that don't have any errors, defined names and table names.
7. Complete the process by clicking on the 'Close' button. This will close the 'Name Manager' dialog box after you have finished managing the range names.

Blogger news