When using Trace Dependent Cells, common questions usually involve no-reference prompts, combined tracing, and whether arrows are saved; this FAQ covers 3 common questions and a short glossary.
FAQ
What message appears if the selected cell is not referenced by any formula?
- Select the target cell first.
- Click Trace Dependent Cells on the Formulas tab.
- If no formula references the current cell, WPS will show a message indicating that no formulas refer to it.
Can I view precedent relationships and dependent relationships at the same time?
- Select the target cell.
- Run Trace Precedent Cells first.
- Then run Trace Dependent Cells to display both kinds of relationships on the same worksheet.
Are trace arrows saved in the file?
- Trace arrows are temporary visual markers.
- After the file is closed, the arrows disappear automatically.
- If you need them again, reopen the file and run the tracing commands again.
Glossary
| Term | Definition |
|---|---|
| Dependent cell | A cell that contains a formula and references the current cell. |
| Trace arrow | A visual arrow marker used in the worksheet to show cell reference relationships. |
| Formula auditing | The process of checking formula logic and dependencies through tools such as precedent and dependent tracing. |