Office Settings & Configuration

How to Create Worksheet-Scoped Names When Excel Labs Advanced Formula Editor Cannot

Bushra ParveenBushra Parveen Nov 13, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open Name Manager

In Excel, click the Formulas tab on the ribbon and select Name Manager.

2
Create a new name

Click New, enter the name in the Name box, then open the Scope drop-down and choose the target worksheet.

3
Save the name

Enter the formula or cell reference in the Refers to box and click OK to create the worksheet-scoped name.

Scope is set: The name now appears under the selected worksheet in Name Manager and is not visible from other sheets.
Free Microsoft Office alternative

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. 1. Download WPS Office: Download WPS Office for Windows, macOS, Android, or iOS from the official WPS site and install it.
  2. 2. Open the Excel workbook: Launch WPS Spreadsheets and open the .xlsx file that needs worksheet-scoped names.
  3. 3. Open Name Manager: Click the Formulas tab and choose Name Manager.
  4. 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.
Create worksheet-scoped names natively with a built-in Name ManagerOpen, edit, and save Microsoft Excel .xlsx files without losing name scopeFree, lightweight Office suite with a familiar ribbon interfaceNo separate add-in or Microsoft Garage project required
microsoft office alternative - wps office

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.