Excel Missing Function

[aasias]

Hi,

I was working on an assignment for one of my classes and I was told to use the Name Manger and Use in Formula functions and for some reason it was not showing up on my excel but when I shared my file with my TA, it showed up on hers. I just updated my excel application on my MAC. Not sure what to do now. Any help is greatly appreciated!

[#2]

@aasias 

I googled "excel use in formula" without quotes, and found the following:

https://support.microsoft.com/en-us/office/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-...

Watch to near the end of the video.

After creating a named cell, range or formula in Name Manager, you can reference that name while typing a formula by clicking Formula on the toolbar, then clicking Use In Formula dropdown and selecting the named function.

PS.... Are you missing the Formula tab or the Defined Name section on the toolbar?