"Use in formula" tab missing in my Excel formula ribbon (HELP)

%3CLINGO-SUB%20id%3D%22lingo-sub-1559835%22%20slang%3D%22en-US%22%3E%22Use%20in%20formula%22%20tab%20missing%20in%20my%20Excel%20formula%20ribbon%20(HELP)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1559835%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20Office%20professional%20Plus%202019.%3C%2FP%3E%3CP%3EIn%20my%20Excel%2C%20if%20you%20open%20the%20formula%20ribbon%2C%20normally%20I%20believe%20there%20should%20be%20a%20section%20where%20there%20is%20(from%20top%20to%20bottom)%20%22Define%20Name%22%2C%20%22Use%20in%20Formula%22%2C%20and%20then%20%22Create%20from%20Selection%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20as%20shown%20in%20the%20picture%2C%20my%20%22Use%20if%20Formula%22%20is%20missing.%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20else%20have%20this%20problem%20with%20the%26nbsp%3BOffice%20professional%20Plus%202019%20Excel%20version%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20love%20to%20know%20what's%20wrong.%3C%2FP%3E%3CP%3EThank%20you!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1559835%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1564069%22%20slang%3D%22en-US%22%3ERe%3A%20%22Use%20in%20formula%22%20tab%20missing%20in%20my%20Excel%20formula%20ribbon%20(HELP)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1564069%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F745967%22%20target%3D%22_blank%22%3E%40Chloe623%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDon't%20have%202019%2C%20but%20ribbon%20looks%20like%20one%20for%20Mac%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fwhere-is-name-manager-in-excel-for-mac-the-excel%2Fbb07e680-3947-4697-8b08-50525c7bed3c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fanswers.microsoft.com%2Fen-us%2Fmsoffice%2Fforum%2Fall%2Fwhere-is-name-manager-in-excel-for-mac-the-excel%2Fbb07e680-3947-4697-8b08-50525c7bed3c%3C%2FA%3E.%20In%20any%20case%2C%20Use%20in%20formula%20is%20not%20available%20if%20you%20have%20no%20names%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have the Office professional Plus 2019.

In my Excel, if you open the formula ribbon, normally I believe there should be a section where there is (from top to bottom) "Define Name", "Use in Formula", and then "Create from Selection". 

 

However, as shown in the picture, my "Use if Formula" is missing. 

Does anyone else have this problem with the Office professional Plus 2019 Excel version? 

I'd love to know what's wrong.

Thank you! 

 

1 Reply

@Chloe623 

Don't have 2019, but ribbon looks like one for Mac https://answers.microsoft.com/en-us/msoffice/forum/all/where-is-name-manager-in-excel-for-mac-the-ex.... In any case, Use in formula is not available if you have no names