WPS Form Controls on macOS FAQ

Common questions about WPS Form Controls on macOS usually involve where to find the feature, what controls are available, macro-related behavior, and suitable use cases; this FAQ covers 4 common questions.

FAQ

Why can’t I find Form Controls in WPS Spreadsheets on Mac?

1. Make sure you are using WPS Spreadsheets rather than Writer or Presentation.
2. Click Tools and open Developer Tools.
3. Check whether the Developer Tools tab and Form Controls area are visible.
4. If they still do not appear, update to the latest version of WPS Office for Mac and try again.

What types of controls can I insert?

1. Open the Developer Tools tab.
2. Review the available items in the Form Controls area.
3. Available examples include buttons, check boxes, option buttons, list boxes, combo boxes, scroll bars, and other controls.

Why doesn’t a control work as expected after I insert it?

1. Confirm that the control has been inserted correctly on the worksheet.
2. Check whether its size and position make it easy to click or select.
3. If the form depends on macro-related behavior, enable macros and test again.
4. Save the file and reopen it to confirm the settings are retained.

What scenarios are Form Controls suitable for?

1. They are suitable for worksheets where users need to enter options or status directly in the sheet.
2. They work well for registration sheets, approval checklists, and lightweight interactive panels.
3. If your main goal is online surveys or external data collection, a dedicated form product may be more suitable.

Glossary