How to Use WPS Track Referenced Cells on macOS

This how-to guide includes 2 topics, with 2 free topics and 0 membership-related topics, so you can jump from the index to the exact task you need.

How-to Index

How-to Guide

1. Track Referenced Cells

Entry: Formulas → Track Referenced Cells

1. Select a cell that contains a formula in the worksheet.
2. Click Track Referenced Cells on the Formulas tab.
3. Review the arrows that appear to show the reference relationship.
4. Identify the arrow types: a blue solid arrow shows a reference in the current worksheet, and a black dashed arrow shows a cross-worksheet reference.
5. Click Track Referenced Cells again if you want to reveal a deeper level of references.
6. If a black dashed arrow appears, click it to jump to the related reference location.

Success Criteria

• Interface result: Tracer arrows appear around the selected formula cell.
• Next action available: You can continue tracing deeper levels or switch to removing arrows.

Tips While Using

• Common mistake: If the selected cell does not contain a formula, the command may not work as expected.
• Environment note: This feature works for cells that contain formulas.

2. Remove Trace Arrows

Entry: Formulas → Remove Arrows drop-down menu

1. Click the drop-down arrow next to Remove Arrows on the Formulas tab.
2. Select Remove Referenced Cell Trace Arrows to remove precedent tracing.
3. Select Remove Dependent Cell Trace Arrows to remove dependent tracing.
4. Select Remove All Arrows to clear all tracing marks in the current worksheet at once.

Success Criteria

• Interface result: The selected tracing arrows disappear from the worksheet.
• Next action available: You can run Track Referenced Cells again to generate a new set of arrows.

Tips While Using

• Common mistake: If too many arrows are displayed, clear all arrows first and then trace again for a cleaner review.