How to List All Defined Names in an Excel Workbook Using WPS Office
Question details
The user wants to view every defined name in an Excel workbook, including names scoped to individual worksheets, rather than only workbook-scoped names shown by Excel's Paste Names command.
- Product
- WPS Office Spreadsheets
- Device & OS
- Windows and macOS
- Scenario
- A user working with an Excel workbook that contains both workbook-level and worksheet-level defined names needs a complete list for auditing or navigation.
- Observed behavior
- Excel's Paste Names command only displays workbook-scoped names and omits names scoped to individual worksheets.
Open the Excel workbook in WPS Office Spreadsheets and confirm the Formulas tab is available. Remove workbook or sheet protection if it prevents using Name Manager.
Use the Name Manager in WPS Office Spreadsheets to List All Defined Names
Choose this method when you want a built-in list of every defined name, including names scoped to individual worksheets, without installing an add-in.
WPS Office Spreadsheets includes a Name Manager that shows the name, current value, and scope of each defined name in the workbook. It works with Excel .xlsx files and WPS native workbooks.
In WPS Office Spreadsheets, open the Excel workbook and click the Formulas tab in the ribbon.
Click the Name Manager button to open the Name Manager dialog box.
Look through the list to see all workbook- and worksheet-scoped defined names, including their current values and scope.
Use the New, Edit, or Delete buttons in the Name Manager dialog box to manage selected names after reviewing the list.
Use Excel's Paste Names Command for a Quick Workbook-Scoped List
Use this method only when you need a fast list of workbook-level names and do not require worksheet-scoped names.
Use the Free Name Manager Add-in in Microsoft Excel
Choose this method if you must remain in Microsoft Excel and need the complete list without switching to WPS Office Spreadsheets.
List Every Defined Name in Excel with WPS Office Spreadsheets
Open your Excel workbook in WPS Office Spreadsheets and use the built-in Name Manager under the Formulas tab to see all workbook- and worksheet-scoped defined names in one place, without installing additional add-ins.
- 1. Download and open WPS Office: Download WPS Office from the official website, install it, and open the Excel workbook in WPS Office Spreadsheets.
- 2. Click the Formulas tab: In the ribbon, click the Formulas tab to access workbook formula and name tools.
- 3. Open Name Manager: Click Name Manager to display all defined names in the current workbook.
- 4. Check the scope column: Review the Scope column to distinguish workbook-level names from worksheet-scoped names.
- 5. Manage names as needed: Use New, Edit, or Delete to update the defined name list after reviewing it.
Frequently Asked Questions
Does WPS Office Spreadsheets show worksheet-scoped defined names?
Yes. The Name Manager under Formulas > Name Manager lists all defined names and shows the workbook or worksheet scope in the Scope column.
Why does Excel's Paste Names command not list all names?
Excel's Paste Names command is designed to paste a list of workbook-scoped names only. Worksheet-scoped names are omitted, so use Name Manager or WPS Office Spreadsheets for a complete list.
Can I manage or delete defined names in WPS Office Spreadsheets?
Yes. In the Name Manager dialog box, select a name and use the New, Edit, or Delete buttons to manage it.
Does WPS Office Spreadsheets support Excel .xlsx files with defined names?
Yes. WPS Office Spreadsheets opens and saves Excel .xlsx workbooks and preserves defined names, formulas, and formatting.
Do I need an add-in to list all defined names in WPS Office?
No. The Name Manager built into WPS Office Spreadsheets lists all defined names without requiring an add-in.
