Formula Errors

Why Excel Shows a Named Range Instead of a Cell Address & How to Fix It

Maira Mehtab Sep 22, 2026 868 views

Question details

The user needs to understand why formulas are displaying alphabetical strings or text (like LCMZ) instead of standard cell coordinates (like K338) when clicking on a cell.

Product: Excel
Device & OS: not provided
Scenario: Referencing a cell in another workbook or sheet while constructing a formula.
Observed behavior: The formula bar populates with a named range text rather than the default row and column cell address.

Before you start

Verify that the text appearing in your formula bar corresponds to the cell you clicked, as it may be a custom name previously assigned by another user.

Solution 1Recommended

Manage or Delete the Defined Name via Name Manager

Identify if the cell has a defined name and edit or remove it using the Name Manager tool to restore standard cell addresses.

When a cell or a range of cells is assigned a custom name, spreadsheet applications will default to displaying that defined name instead of the standard alphanumeric address to make formulas easier to read. You can easily revert this by managing the defined names.

Navigate to the Formulas Tab

Open your workbook and click on the 'Formulas' tab located in the top ribbon.

Open the Name Manager

Click on 'Name Manager'. This will open a dialog box displaying all the named ranges currently defined in your workbook.

Locate the Specific Name

Scroll through the list to find the specific name (e.g., LCMZ) that is appearing in your formula. You can verify it is the correct one by checking the 'Refers To' column.

Edit or Delete the Name

Select the named range and click 'Delete' to remove it entirely, which will revert future references to the standard cell address. Alternatively, click 'Edit' to change the name or its scope.

Formula Update Warning: Deleting a named range that is actively being used in other existing formulas will cause those formulas to return a #NAME? error. You will need to manually update them with the correct cell address.

Easily Manage Named Ranges with WPS Spreadsheet

WPS Office offers a fully compatible spreadsheet tool where you can effortlessly manage, edit, or delete defined names. Its intuitive Name Manager makes formula tracking and auditing simple for both beginners and advanced users.

1. Open Your File in WPS Spreadsheet: Launch WPS Office and open the workbook containing the named range.
2. Access the Formulas Menu: Click on the 'Formulas' tab situated on the top navigation ribbon.
3. Launch Name Manager: Click the 'Name Manager' button to view a complete list of defined names and their cell references.
4. Modify the Cell References: Select the problematic named range to edit its reference or delete it to restore standard cell addresses.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Built-in Name Manager for seamless formula editing and auditingFree and lightweight office suite for Windows, Mac, and LinuxFamiliar user interface ensuring zero learning curve during migration

microsoft office alternative - wps office

Frequently Asked Questions

How do I stop Excel from automatically creating named ranges?

Spreadsheet software sometimes creates names automatically if you use the 'Create from Selection' tool. To prevent this, avoid checking the options to create names from top row or left column values when selecting data ranges.

What happens to my formulas if I delete a named range?

Any formula that previously referenced the deleted named range will display a #NAME? error. You will need to locate those formulas and update them with the correct standard cell address.

Can I rename a named range without breaking existing formulas?

Yes. If you rename a defined name directly through the Name Manager, the software will automatically update all formulas that use that specific name to reflect the new text.

Why does the named range only appear when referencing a different workbook?

The named range might have workbook-level scope. If you point to a cell that has a defined name in an external workbook, the formula will fetch that specific name to maintain the exact data reference.

Excel & Data Problems