Home

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
ChrisgrZA
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

@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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies