Microsoft Excel helps your business organize finances, including bills, taxes and customer invoices. In Excel, named ranges enable you to describe the formulas entered in cells. This makes it easier to keep track of related entries in your worksheet. If you work with named ranges often, you may forget to delete them when you no longer need them. Named ranges can clutter up your worksheet and make it difficult for others to find the information they need. You can delete or change unwanted named ranges using the Excel Name Manager.
Delete a Named Range
Open Microsoft Excel, then click "File" and open the document containing the named range you want to delete.
Click the "Formulas" tab and click "Name Manager" in the Defined Names group. A window opens that contains a list of all the named ranges in the document.
Click the name you want to delete. If you want to delete multiple names in a contiguous group, press the "Shift" key while clicking each name. For names in a non-contiguous group, press "Ctrl" and click each name you want to delete.
Click "Delete," then confirm the deletion by clicking "OK."
Change a Named Range
Launch Microsoft Excel and open the file containing the name you want to replace.
Click the "Formulas" tab. Click "Name in Manager" under the Defined Names heading.
Click the name you want to replace, then click "Edit" in the Name Manager box.
Enter a new name for the range in the Name box. Change the reference for the name in the Refers To box. Click "OK."
Change the formula, constant or cell the name represents in the Refers To field in the Name Manager box. Click "Commit" to accept the changes.