When using Locate Cell, the most common questions are about the feature entry, reference format, and jump results; this FAQ includes 3 common questions and 3 glossary terms.
FAQ
Why can’t I find the Locate Cell entry?
- Make sure you opened a spreadsheet file instead of a document, presentation, or PDF.
- Make sure the file is already in editing mode.
- Tap the Tools tab at the bottom, then look for Locate Cell.
What should I do if the sheet does not jump after I enter a reference?
- Check whether the reference format is correct. For example,
B7means row 7, column 2. - Make sure you entered a single-cell reference instead of a range.
- Enter the reference again, tap the locate icon, and check whether the sheet moves to the target position.
Can I enter a cell range instead of a single cell?
- This guide covers single-cell references only.
- If you need to review multiple positions, enter each reference one by one.
- It is helpful to record key references first and then jump through them in order.
Glossary
| Term | Definition |
|---|---|
| Cell reference | The address used to identify a position in a spreadsheet, such as B7 or AA1. |
| Editing mode | The state in which you can modify spreadsheet content. Some tools appear only in this mode. |
| Locate icon | The button that runs the jump action after you enter a reference. |