How can I change a Name scope from local to Global in Excel 2007?

How can I change a Name scope from local to Global in Excel 2007?

Question: I created a worksheet and duplicated it, along with the Names. I have edited the names but now those are scoped for that sheet only. The Name Manager won’t allow me to change the scope.

Answer: This is so easy that it’s not so obvious:

  1. Select the Named range on your worksheet whose scope you want to change;
  2. Open the Name Manager (Formulas tab) and select the name;
  3. Click Delete and OK;
  4. Click New… and type in the original name back in the Name field;
  5. Make sure Scope is set to Workbook and click Close.

See? That was way too easy!

Francis Hayes (The Excel Addict)

P.S. Click HERE to get more FREE Time-Saving Microsoft Excel tips at TheExcelAddict.com

Leave a Reply