Forum Discussion
Named Ranges Excel for Mac
Hi. In previous versions of Excel for Mac, in the Formulas ribbon the Named Ranges section had a menu called Use in Formula. The menu included a Past Names item. That menu has disappeared. How do I d...
The Paste Name option is available on the Insert > Name menu (not the ribbon). I don't remember seeing the "Use in Formula" ribbon button on Mac, but Paste Name is very similar. The other option is to just start typing the name where you want to use it in a formula and then choose it from the suggestion list that pops up.
You can also press F3 on both Mac and Windows to bring up the Paste Name dialog.
fernlopez