WPS Features
Resources
Free AI Tools
Docs Center

How to Use WPS Calculation Options on macOS

Last updated:July 14, 2026

This how-to guide includes 3 topics for WPS Calculation Options on macOS, with 3 free topics and 0 membership-related topics; use the index below to jump to each task.

How-to Index

#TopicMembership
11. Set Automatic CalculationFree
22. Set Manual CalculationFree
33. Set Automatic Except for Data TablesFree

How-to Guide

1. Set Automatic Calculation

Entry point: Formulas → Calculation Options → Automatic

  1. Open the WPS spreadsheet file you want to edit.
  2. Click the Formulas tab.
  3. Open the Calculation Options drop-down menu.
  4. Select Automatic.
  5. Edit cell data and check whether related formulas update automatically.

Success Criteria

  • UI state: Calculation Options shows Automatic.
  • Next actions: After data changes, related formula results refresh automatically.

Tips While Using

  • Common mistakes: If you only change cell formatting instead of values, you may not see the expected result change.
  • Environment limits: Open a worksheet that contains formulas so the recalculation effect is visible.

2. Set Manual Calculation

Entry point: Formulas → Calculation Options → Manual

  1. Open a WPS spreadsheet file and go to the Formulas tab.
  2. Click the Calculation Options drop-down menu.
  3. Select Manual.
  4. Edit data in the sheet.
  5. To recalculate all formulas, press Fn+F9.
  6. To recalculate only the active worksheet, press Shift+Fn+F9.

Success Criteria

  • UI state: Calculation Options shows Manual.
  • Next actions: After data changes, formulas do not update immediately; results refresh after you use the shortcut.

Tips While Using

  • Common mistakes: After switching to Manual, it is easy to forget to recalculate and assume the formula is wrong.
  • Environment limits: Depending on your keyboard settings, you may need to hold Fn to trigger function keys.

3. Set Automatic Except for Data Tables

Entry point: Formulas → Calculation Options → Automatic Except for Data Tables

  1. Open the target spreadsheet file.
  2. Click Calculation Options on the Formulas tab.
  3. Select Automatic Except for Data Tables.
  4. Edit data in a regular worksheet and observe whether formulas update automatically.
  5. Check whether formulas in data tables remain outside automatic recalculation.

Success Criteria

  • UI state: Calculation Options switches to Automatic Except for Data Tables.
  • Next actions: Regular formulas update automatically, while data tables do not recalculate automatically.

Tips While Using

  • Common mistakes: This mode can be misunderstood as automatic recalculation for every worksheet.
  • Environment limits: This mode is mainly useful in workbooks that include data tables.