How to Use WPS Form Controls on macOS

Use WPS Form Controls on macOS through 4 indexed topics; all 4 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Open the Developer Tools tab

Feature entry: Tools → Developer Tools

1. Open WPS Spreadsheets and go to the worksheet you want to edit.
2. Click Tools and open Developer Tools.
3. Check whether the Developer Tools tab is now visible.

Success Criteria

• Interface result: Developer-related options are visible near the top of the window.
• Next step available: You can continue to the Form Controls area.

Tips While Using

• Common mistake: If you are not in a spreadsheet editing view, the related entry may not appear.

2. Choose the form control you need

Feature entry: Developer Tools → Form Controls

1. Open the Developer Tools tab.
2. Review the available controls in the Form Controls area.
3. Select a control such as a button, check box, option button, list box, combo box, scroll bar, or another control based on your input needs.

Success Criteria

• Interface result: The control type you want to insert is selected.
• Next step available: You can start drawing the control on the worksheet.

Tips While Using

• Common mistake: Inserting a control before deciding the input method may lead to extra adjustments later.

3. Draw a control on the worksheet

Feature entry: Developer Tools → Form Controls → select a control, then drag on the worksheet

1. Select a control in the Form Controls area.
2. Move the pointer to the target area of the worksheet.
3. Click and drag to define the control size and position.
4. Release the mouse to finish inserting the control.

Success Criteria

• Interface result: The selected control appears on the worksheet.
• Next step available: You can insert more controls or continue adjusting the layout.

Tips While Using

• Common mistake: Drawing the control too small can make it harder to click or review later.

4. Use controls in a data entry form

Feature entry: The worksheet area where controls have been inserted

1. Insert multiple controls based on your form layout.
2. Place each control next to the related field or option.
3. Use worksheet cells for titles, instructions, and entry areas.
4. Enable macros as needed if your workflow depends on macro-related control behavior.

Success Criteria

• Interface result: The worksheet becomes an interactive entry area.
• Next step available: You can save it as a template or continue refining the form.

Tips While Using

• Common mistake: If macros are not enabled, some control-related behavior may not work as expected.
• Environment note: For macro-related behavior, make sure the file is editable and enable macros when needed.