WPS Name Manager on Windows FAQ

Last updated:July 20, 2026

Common questions about WPS Name Manager usually focus on naming rules, formula references, and cross-sheet use; this FAQ includes 3 common questions and a glossary.

FAQ

What naming rules should I follow?

  1. Use clear, readable business names whenever possible.
  2. Avoid names that look like cell references.
  3. Do not reuse confusing or duplicate names in the same workbook.

Why should I define a name?

  1. A name can replace a cell address and make a formula easier to read.
  2. In complex spreadsheets, names help you maintain references more consistently.
  3. In collaboration, other users can understand formulas more quickly.

Can I define a name that refers to another worksheet?

  1. Yes. When you create the name, you can point it to a range on another worksheet.
  2. After that, you can use the name directly in formulas for cross-sheet references.
  3. If you change the reference later, review related formula results again.

Glossary

TermDefinition
Name ManagerThe window used to view, create, edit, and delete defined names in one place.
Defined nameA custom name assigned to a cell, range, constant, or formula.
Reference rangeThe actual cell range, constant value, or formula content that a name points to.