How to Create Worksheet-Scoped Names When Excel Labs Advanced Formula Editor Cannot
Question details
The user wants to create a defined name that is scoped to a single worksheet, but Excel Labs Advanced Formula Environment does not have a scope option when creating or editing names.
- Product
- Microsoft Excel Labs Advanced Formula Environment
- Device & OS
- not provided
- Scenario
- The user is editing long or named formulas in Excel Labs and needs the name to be available only on a specific worksheet.
- Observed behavior
- The Advanced Formula Environment does not provide an option to set the worksheet scope for new or existing names.
Open the workbook where you need the worksheet-scoped name and identify the worksheet that should own it. If you plan to use WPS Spreadsheets, save the workbook in .xlsx format so named ranges and their scope are preserved.
Create the Worksheet-Scoped Name in Excel Name Manager
Use this method when Excel Labs Advanced Formula Environment cannot set the scope, because the built-in Excel Name Manager gives you full control over workbook and worksheet scope.
Although the Advanced Formula Environment is useful for editing complex formulas, defined-name scope must be set in the native Excel Name Manager. This method works for both new names and existing names that need to be recreated.
In Excel, click the Formulas tab on the ribbon and select Name Manager.
Click New, enter the name in the Name box, then open the Scope drop-down and choose the target worksheet.
Enter the formula or cell reference in the Refers to box and click OK to create the worksheet-scoped name.
Use the Define Name Dialog in Excel
Use this method when you already have the worksheet cell or range selected and want a faster way to create a worksheet-scoped name.
Create the Same Name in WPS Office Spreadsheets
Use this method if you want a free Office alternative that includes a native Name Manager for worksheet-scoped names without installing an add-in.
Use WPS Office Spreadsheets for Worksheet-Scoped Names Without Excel Add-ins
WPS Office Spreadsheets is a free, lightweight Microsoft Excel alternative that opens and saves .xlsx files with full defined-name support. It has a familiar Formulas > Name Manager workflow, so you can create worksheet-scoped names directly without relying on Excel Labs Advanced Formula Environment.
- 1. Download WPS Office: Download WPS Office for Windows, macOS, Android, or iOS from the official WPS site and install it.
- 2. Open the Excel workbook: Launch WPS Spreadsheets and open the .xlsx file that needs worksheet-scoped names.
- 3. Open Name Manager: Click the Formulas tab and choose Name Manager.
- 4. Create the name with scope: Click New, enter the defined name, set Scope to the target worksheet, enter the Refers to value, and click OK.

Frequently Asked Questions
Can Excel Labs Advanced Formula Environment create worksheet-scoped names?
No, the current version does not expose a Name Scope option. Create the name in Excel through Formulas > Name Manager or Define Name and set the Scope field there.
How do I change an existing name to worksheet scope in Excel?
Open Formulas > Name Manager, select the name, and check its Scope column. If needed, delete and recreate it with the correct worksheet selected, because you cannot directly change the scope of an existing name.
Does WPS Office Spreadsheets support worksheet-scoped names?
Yes. In WPS Spreadsheets, open Formulas > Name Manager, click New, and set Scope to the desired worksheet before saving the name.
Will worksheet-scoped names created in Excel still work in WPS Office?
Yes, WPS Office is compatible with Excel .xlsx files and preserves workbook-defined and worksheet-defined names when the file is opened and saved.
Where can I report the missing scope option in Excel Labs Advanced Formula Environment?
You can check the Microsoft Advanced Formula Environment GitHub repository, specifically the issue about changing the scope of a range, and add your feedback for the Excel Labs team.




