KevinMcCauley.com

Mainframes, LANs, Bare Metal, Virtual, Linux, DevOps, Open Source, Containers, Serverless, ?

Excel 2016 for Mac, still lacking features in Windows version

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

Windows Keyboard for Mac — Windows Keyboard

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.

Need a Simple Form in Excel? SOL!

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.

“Relevant” Microsoft Articles:

Customize the Quick Access Toolbar – Note how there’s no distinction about lack of this ability in the Mac 2016 version.
Add commands to the Quick Access Toolbar – ditto, see above.

The answer:

From a non-Microsoft blog – it can’t be done.