Use Show Formulas with 2 how-to topics, both available without membership; choose a topic from the index and follow the matching entry path to switch the display mode.
How-to Index
| No. | Topic | Membership |
|---|---|---|
| 1 | 1. Switch Show Formulas from the tab | Free |
| 2 | 2. Switch Show Formulas with the shortcut | Free |
How-to Guide
1. Switch Show Formulas from the tab
Entry path: Formulas tab → Show Formulas
- Open a WPS spreadsheet on your Mac that contains formulas.
- Click the Formulas tab at the top of the window.
- Click Show Formulas.
- Check the worksheet and confirm that cells with formulas now display formula expressions instead of results.
- Click Show Formulas again when you want to return to the normal result view.
Success Criteria
- Interface result: Cells with formulas display formula expressions instead of calculated values.
- What you can do next: You can continue checking references, reviewing formula syntax, or switch back to result view.
Tips While Using
- Common mistake: If the worksheet does not contain formula cells, the visual change may be minimal.
- Environment note: Make sure the active window is a spreadsheet editing window.
2. Switch Show Formulas with the shortcut
Entry path: Keyboard shortcut
- Open a WPS worksheet that contains formulas.
- Press
Ctrl+~. - Check whether the worksheet has switched between formula display and result display.
- Press
Ctrl+~again to restore the previous display state.
Success Criteria
- Interface result: After you press the shortcut, formula cells switch between showing formulas and showing results.
- What you can do next: You can keep using the shortcut for quick formula review.
Tips While Using
- Common mistake: If the shortcut does not work, first confirm that the input focus is inside the current worksheet window.
- Environment note: The tilde key position may vary with different keyboard layouts.