SOLVED
Home

Delete names

%3CLINGO-SUB%20id%3D%22lingo-sub-766626%22%20slang%3D%22en-US%22%3EDelete%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-766626%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Excel%20for%20Mac%202016.%3C%2FP%3E%3CP%3EI%20can%20define%20cell%20names%20and%20use%20them.%3C%2FP%3E%3CP%3EHowever%2C%20the%20option%20%22manage%20names%22%20is%20not%20available.%3C%2FP%3E%3CP%3EHow%20can%20I%20delete%20wrong%2F%20mistyped%20names%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-766626%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-766638%22%20slang%3D%22en-US%22%3ERe%3A%20Delete%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-766638%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F379818%22%20target%3D%22_blank%22%3E%40Ronald_dV%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CDIV%20class%3D%22answercell%20post-layout--right%22%3E%3CDIV%20class%3D%22post-text%22%3E%3CP%3EThere%20is%20no%20special%20button%20for%20the%20Name%20Manager%20in%20any%20version%20of%20Excel%20for%20Mac.%20However%2C%20you%20can%20call%20it%20by%20pressing%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%E2%8C%98%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%2B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Efn%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%2B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3EF3.%3C%2FP%3E%3CP%3EThe%20dialog%20window%20will%20appear%2C%20where%20you%20can%20enter%20name%20for%20a%20data%20range%20and%20a%20range%20of%20cells%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EOn%20standard%20full%20keyboards%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ECommand%2BF3%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E%3CSPAN%3Eis%20sufficient.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EHope%20that%20helps%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ENabil%20Mourad%3C%2FSPAN%3E%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-767030%22%20slang%3D%22en-US%22%3ERe%3A%20Delete%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-767030%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F365248%22%20target%3D%22_blank%22%3E%40nabilmourad%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%20I%20expected%20to%20see%20a%20menu%26nbsp%3Bsomething%20like%20the%20windows%20version.%26nbsp%3B%3C%2FP%3E%3CP%3EDeleting%20a%20name%20is%20simply%20done%20by%20pressing%20the%20'-'%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERonald%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-768001%22%20slang%3D%22en-US%22%3ERe%3A%20Delete%20names%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-768001%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F379818%22%20target%3D%22_blank%22%3E%40Ronald_dV%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Ronald%2C%3C%2FP%3E%3CP%3EI'm%20glad%20i%20was%20able%20to%20help.%3C%2FP%3E%3CP%3EPlease%20mark%20my%20reply%20as%20an%20accepted%20answer%20(%2B%20a%20Like%20will%20be%20nice%20of%20you)%3C%2FP%3E%3CP%3ENabil%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ronald_dV
New Contributor

I am using Excel for Mac 2016.

I can define cell names and use them.

However, the option "manage names" is not available.

How can I delete wrong/ mistyped names?

3 Replies

@Ronald_dV 

Hi

There is no special button for the Name Manager in any version of Excel for Mac. However, you can call it by pressing  + fn + F3.

The dialog window will appear, where you can enter name for a data range and a range of cells: 

On standard full keyboards Command+F3 is sufficient.

Hope that helps

Nabil Mourad

@nabilmourad 

Thanks. I expected to see a menu something like the windows version. 

Deleting a name is simply done by pressing the '-' .

 

Ronald

Solution

@Ronald_dV 

Hi Ronald,

I'm glad i was able to help.

Please mark my reply as an accepted answer (+ a Like will be nice of you)

Nabil

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies