Forum Discussion

fernlopez's avatar
fernlopez
Copper Contributor
Jun 14, 2020

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 do that now? Thank you.

Excel on Mac

7 Replies

  • Steve_K_Excel's avatar
    Steve_K_Excel
    Iron Contributor
    Jun 17, 2020

    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 

    • fernlopez's avatar
      fernlopez
      Copper Contributor
      Jun 15, 2020

      JKPieterse Hi. Yes, it's there under Windows, but disappeared on Mac. I suspect it was moved but can't find it or any other way to do this.

      • fastexcel's avatar
        fastexcel
        Brass Contributor
        Jun 17, 2020

        fernlopez 

        I checked on my Insider Fast Mac XL and I confirm that it is not there.

        And Mac XL does not have a Name Manager.

         

        (although you can buy my Manager Pro for Mac XL from here) http://www.decisionmodels.com/fxl_MgrProMac.htm

         

Resources