| Mode | Enter | Arrows |
|---|---|---|
| Cursor | F2 on a formula; or F4 while pointing | Move the text caret. Autocomplete may use ↑↓ only here. |
| Point | Arrows while editing a formula (not in cursor mode); or F4 | Move the reference pointer. |
Pointing rules
- Home is the formula cell. Every new point session starts there — never at the previous reference.
- Space dives under the pointer; Shift+Space surfaces.
- Typing ends the point session. The next arrow starts a new session at home again.
Function autocomplete
- Hidden while pointing. Arrows never drive the menu in point mode.
- An exact local field or defined name beats a same-named function (column
SUMwins overSUM()). - Tab accepts the function. Enter always commits the formula as written.