Locating Name Manager in Excel for Mac With named ranges it is more convenient to operate formulas. For instance, instead of typing =SUM(C20:C30) you can enter =SUM(FirstQuarterSales)

Where is Name Manager located in Excel 2016? I don't see any button in the Formulas Ribbon:
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:


Another way is to click Insert>Name>Define and modify,add,or delete data ranges names.