Cell names in Excel under Win10 - how can I change or delete the name allocated to a single cell

%3CLINGO-SUB%20id%3D%22lingo-sub-861164%22%20slang%3D%22en-US%22%3ECell%20names%20in%20Excel%20under%20Win10%20-%20how%20can%20I%20change%20or%20delete%20the%20name%20allocated%20to%20a%20single%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861164%22%20slang%3D%22en-US%22%3E%3CP%3ECell%20names%20in%20Excel%20under%20Win10%20-%20how%20can%20I%20change%20or%20delete%20the%20name%20allocated%20to%20a%20single%20cell%3F%26nbsp%3B%20Right%20now%2C%20I%20can%20select%20the%20desired%20cell%2C%20which%20brings%20up%20its%20existing%20name%20at%20at%20top%20left%20of%20the%20screen.%26nbsp%3B%20If%20I%20then%20delete%20or%20overtype%20a%20correction%2C%20it's%20ignored.%26nbsp%3B%20If%20I%20try%20the%20drop-down%20(right%20click)%20%22Define%20Name%22option%2C%20there's%20no%20Delete%20or%20Change%20sub-option%2C%20and%20I'm%20stuck%20with%20a%20name%20I%20don't%20want%20(I%20spelled%20it%20wrong.%20.%20.).%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-861164%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861241%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20names%20in%20Excel%20under%20Win10%20-%20how%20can%20I%20change%20or%20delete%20the%20name%20allocated%20to%20a%20single%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861241%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F411100%22%20target%3D%22_blank%22%3E%40ChrisgrZA%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20go%20to%20the%20%3CSTRONG%3EFormulas%20Tab%3C%2FSTRONG%3E%2C%20under%20%3CSTRONG%3EDefined%20Names%20group%3C%2FSTRONG%3E%2C%20click%20on%20%3CSTRONG%3EName%20Manager%3C%2FSTRONG%3E%20and%20in%20there%20you%20can%20select%20an%20existing%20Named%20Range%20and%20then%20either%20Edit%20it%20or%20Delete%20it%20as%20per%20your%20requirement.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20also%20press%20the%20shortcut%20key%20%3CSTRONG%3ECtrl%2BF3%3C%2FSTRONG%3E%20to%20open%20the%20Name%20Manager.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Cell names in Excel under Win10 - how can I change or delete the name allocated to a single cell?  Right now, I can select the desired cell, which brings up its existing name at at top left of the screen.  If I then delete or overtype a correction, it's ignored.  If I try the drop-down (right click) "Define Name"option, there's no Delete or Change sub-option, and I'm stuck with a name I don't want (I spelled it wrong. . .). 

1 Reply
Highlighted

@ChrisgrZA 

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.