Show Formulas

Show Formulas helps you display formula content instead of calculated results for all cells that contain formulas, so you can quickly check and review formula logic in WPS Sheets. It provides the tools you need to switch between formula view and result view without affecting calculation, making your work more efficient and helping you accomplish tasks with ease. With Show Formulas, you can turn the display on or off, use the Ctrl+~ shortcut to toggle instantly, adjust column width when formulas are too long to view fully, and wrap text to show formulas across multiple lines. Whether you're auditing formulas, checking why some cells show values instead of formulas, or confirming that calculations continue normally while reviewing, Show Formulas helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.

Windows

Mac