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
If you’re an Excel 2016 for Mac user, and you want to create a simple form, you’re out of luck. Microsoft’s official response: there is none.
If fact, if you read through the myriad of Microsoft Office articles on the subject, you’ll find no differentiation about Mac’s inability to use the customize the Quick Access Toolbar feature. I guess the workaround is is to buy a Windows computer.
Unfortunately this is yet another example of how Office for Mac 2016 is still the red-headed stepchild to the Windows version.