Forum Discussion

PrivateUser1066's avatar
PrivateUser1066
Copper Contributor
Nov 09, 2022

Name Manager How to change the scope?

Excel for Mac

 

Name manager has finally been added (many core features are still MIA though).

 

Edit a name.

Scope is disabled as something that cannot be altered!  Not sure why that should be ... 

How do I change the scope of a named range?

 

 

BTW. Apologies for any multiple posts ... I am not sure if there are any but this janky forum software keeps returning me to the editor when I press post. At first I thought that it might be tags are mandatory ... but I am still here in the editor ... uncertain as to whether or not it posted. 

Thanks.

excel
Excel on Mac

2 Replies

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Nov 09, 2022

    PrivateUser1066 If you already have named a range they seem to default to "Workbook" on a Mac. But when you create one from within the name Manager, you can choose Workbook or the relevant sheet name.

    • PrivateUser1066's avatar
      PrivateUser1066
      Copper Contributor
      Nov 17, 2022

      Riny_van_Eekelen 

      hi.

       

      thanks for this.

       

      For me, the scope field is disabled (grey) rather than a list. This is true of all of the names that I have tried (I stopped after the first 25+ !).

       

      I have the latest version of Excel 365 for mac (as of yesterday). 

      When I get a chance, I have just thought to try it with a new workbook (Sometimes I amaze myself with my dimness!). On more than one occasion, inconsistencies seem to follow a particular workbook.

Resources