Need to edit your defined names in Excel 2016 for Mac? No need to search the Office help site, you won’t find Mac instructions. The short answer is that there isn’t a name manager button on the formula ribbon. The work around is to hold CMD+FN+F3

Problems Locating Name Manager in Excel 2016
Dear community members, Does anybody know where the name manager is located in Excel 2016? I don’t see any option in the Formulas Ribbon:
Reply to Jim Gordon Mac MVP’s post on August 2, 2015
Thank for letting me know. Hopefully, the name management functionality will be incorporated in the near future.