Use WPS Form with 4 how-to topics, including 4 free topics and 0 membership-related topics, and jump from the index to the matching steps.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Open Developer Tools | Free |
| 2 | 2. Choose a form control type | Free |
| 3 | 3. Draw a control on the worksheet | Free |
| 4 | 4. Use controls for data entry scenarios | Free |
How-to Guide
1. Open Developer Tools
Feature entry: Tools tab → Developer Tools
- Open WPS Spreadsheets and go to the workbook you want to edit.
- Click Developer Tools on the Tools tab.
- Check whether the developer-related area is now visible.
Success Criteria
- The Developer Tools area is visible.
- You can continue to the Form Controls area.
Tips While Using
- If the workbook is protected or read-only, some editing actions may be limited.
2. Choose a form control type
Feature entry: Developer Tools tab → Form Controls area
- Open the Developer Tools area.
- Find the Form Controls area.
- Select the control type you need, such as a button, checkbox, option button, list box, combo box, or scroll bar.
- Confirm that the selected control is the one you want to place on the worksheet.
Success Criteria
- A form control type is selected.
- The pointer is ready for control placement.
Tips While Using
- Different controls fit different input tasks, so decide whether you need check, single-choice, or list-based input first.
3. Draw a control on the worksheet
Feature entry: After selecting a control, drag directly on the worksheet
- Move to the area where you want to place the control.
- Drag with the mouse to define the control size and position.
- Release the mouse to insert the control.
- Repeat the same action if you need more controls.
Success Criteria
- The selected control appears on the worksheet.
- Its size and position fit the current form layout.
Tips While Using
- It helps to reserve a form area first and then place controls in a consistent layout.
4. Use controls for data entry scenarios
Feature entry: Inserted form controls on the worksheet
- Add more controls based on the form you want to build.
- Place controls near titles, notes, and input areas.
- Use controls together with cells when you need to record selection results.
- Save the workbook for later editing or sharing.
Success Criteria
- The worksheet has a basic form layout for entry or selection.
- The controls support registration, option collection, or interactive display tasks.
Tips While Using
- The feature notes mention that form controls require macros to work normally, so check macro settings when needed.