How do you reset the name of a cell in Excel?

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.

Table of Contents Show

Delete a Named Range
Change a Named Range
How do I change my cell name back to original?
How do I Undefine a cell name?
How do I correct a name in Excel?

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.

How do I change my cell name back to original?

If you go to the Formulas Tab, under Defined Names group, click on Name Manager and in there you can select an existing Named Range and then either Edit it or Delete it as per your requirement. You may also press the shortcut key Ctrl+F3 to open the Name Manager.

How do I Undefine a cell name?

Define a name for a cell or cell range on a worksheet.

Select the cell, range of cells, or nonadjacent selections that you want to name..

Click the Name box at the left end of the formula bar. Name box..

Type the name you want to use to refer to your selection. Names can be up to 255 characters in length..

Press ENTER..

How do I correct a name in Excel?

Follow these steps to do that:.

If you already have the data in the spreadsheet, and want to assign a name to specific cells or a cell range, first select the cells in the spreadsheet. ... .

On the Formulas tab, in the Defined Names group, click Define Name, and then click Define Name..

Enter a unique name..