WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


How to create a Form in spreadsheet

Uploaded time: December 6, 2021 Difficulty Beginner

How to create a Form in spreadsheet

How to create a Form in spreadsheet

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable.

· 1. Data input

First, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name.

Click New, and enter new data information in the edit box.

Press the Enter key when finished.

· 2. Data lookup

Click the Criteria button to set the searching criteria. In this case, we want to filter out the data of people over 40 years old in the table. Enter > 40at the Age. Click the Enter key, and we will get what we want. Click Find Next to search information downwards in each row, and click Find Prev to search information upwards.

· 3. Data modification

When we locate errors in the table, we can modify them directly in Form. After the modification is completed, press the Enter key to complete the process.

Note: Any data deleted in Form cannot be withdrawn by Ctrl+Z.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.