Office Settings & Configuration

How to Hide Named Ranges from Other Open Excel Workbooks

Ayan Masood Oct 12, 2026 870 views

Question details

The user wants to prevent named ranges from one Excel workbook from appearing in the Name Box or menus of other currently open workbooks.

How to Hide Named Ranges from Other Open Excel Workbooks

Product: Microsoft Excel 365
Device & OS: not provided
Scenario: Working with multiple open workbooks simultaneously and trying to manage or select named ranges without clutter from unrelated files.
Observed behavior: Excel automatically displays named ranges from all workbooks open in the same application instance, which causes clutter and cannot be disabled via built-in settings.

Before you start

Verify that you genuinely need all workbooks open at the same time, as simply closing the unrelated workbooks is the quickest way to clear their named ranges from your current view.

Solution 1Recommended

Open Workbooks in Separate Excel Instances

Since named ranges are shared within a single Excel application session, forcing workbooks to open in completely separate instances will isolate their named ranges from one another.

By default, Windows opens all Excel files in the same background application instance to save memory. Because the instance shares a single Name Manager environment, named ranges bleed across files. Opening a strictly separate instance of Excel prevents this behavior.

Open the first workbook

Launch Excel normally from your Start menu or taskbar and open your first workbook.

Launch a separate instance

Hold down the 'Alt' key on your keyboard. While holding it, right-click the Excel icon in your Windows taskbar and click on the 'Excel' application name in the jump list.

Confirm the new instance

Keep holding the 'Alt' key until a prompt appears asking, 'Do you want to start a new instance of Excel?'. Click 'Yes' and release the 'Alt' key.

Open the second workbook

In this newly opened, blank Excel window, go to File > Open and select your second workbook. The named ranges will now be completely isolated.

Open Workbooks in Separate Excel Instances

Environment Isolated: Because these workbooks are running in separate memory spaces, you will not see their named ranges overlap, though you also won't be able to easily copy-paste complex formulas between them without losing external links.

Solution 2

Acknowledge Default Behavior and Submit Feedback

Understand that Excel's default behavior cannot be toggled off within the same session, and use Microsoft's feedback tool to request a feature change.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

Frustrated by rigid settings and cluttered interfaces in Excel? WPS Office provides a lightweight, highly compatible alternative for managing your spreadsheets, formulas, and named ranges efficiently without unnecessary complexity.

1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
2. Open your spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx files. All your data, formatting, and named ranges will be perfectly preserved.
3. Manage your data effortlessly: Utilize the built-in Name Manager and intuitive ribbon interface to comfortably edit and organize your workbook data.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsManage formulas and named ranges with an intuitive, clean interfaceLightweight application with exceptionally fast launch timesFree to use with a familiar, easy-to-navigate tabbed workspace

microsoft office alternative - wps office

Frequently Asked Questions

Can I make a named range specific to a single worksheet instead of the whole workbook?

Yes. When creating a new named range using the 'New Name' dialog box, you can change the 'Scope' dropdown from 'Workbook' to a specific worksheet. This ensures the name is only recognized locally within that specific tab.

Why do named ranges from a completely closed workbook still appear?

If named ranges from a closed workbook still appear, your current workbook likely contains formulas or data validations that reference the external closed workbook. Open the Name Manager (Ctrl + F3) to find and delete any unwanted or broken external links.

Will hiding a worksheet also hide its scoped named ranges?

No, hiding a worksheet does not hide the named ranges scoped to it from the Name Manager. They will still be accessible and visible in formulas or the Name Box unless explicitly deleted.

Office App Problems