WPS Locate Referenced Cell on macOS FAQ

When using WPS Locate Referenced Cell, the most common issues fall into 3 groups: finding the command, seeing the reference result, and understanding the reference relationship; this section answers 3 common questions.

FAQ

Why can't I find the Locate Referenced Cell command?

1. Make sure the current file is a spreadsheet rather than a Writer or Presentation file.
2. Select a cell in the spreadsheet and open the Formulas tab at the top of the window.
3. Look for Locate Referenced Cell in the formula tools area.

What should I do if I don't see the reference result I expected?

1. Check whether the selected cell actually contains a formula with references.
2. Select the target cell again and click Locate Referenced Cell one more time.
3. Review the result in the dialog box and click Locate to continue tracing the source.

When is this feature useful?

1. Use it when you need to check where a formula gets its values.
2. Use it when you take over a spreadsheet created by someone else and need to understand the data relationship.
3. Use it when a calculation result looks incorrect and you need help tracing the reference path.

Glossary