How to use the Spreadsheet Named Range Planner.
Named ranges should express stable business meaning and avoid ambiguity. Keep scope and maintenance requirements visible.
Make the workflow fit your task.
Identify repeated constants or ranges, propose meaningful names and state workbook or sheet scope. Map every name to an explicit reference and check whether its size should grow. Review existing names for collisions before updating formulas.
- What you provide
- Workbook structure and formula patterns.
- What you get
- Naming scheme and proposed range definitions.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
Workbook repeatedly uses the approved hourly rate at Settings!B2. Propose a workbook-scoped name; no existing-name conflicts supplied.
Completed example
Proposed name: HourlyRate Scope: workbook Refers to: =Settings!$B$2 Meaning: approved hourly rate used by this workbook. Before applying: check for existing names and confirm formulas should reference this one setting. Verify a known calculation after replacement.
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
Should a named range point to one cell or an expanding table column?
Use a single cell for a stable setting and a suitable dynamic structure for growing records. Document the intended behavior.
Why does the same range name resolve differently on another sheet?
A sheet-scoped name may override a workbook name. Inspect scope and use unambiguous references where necessary.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑