How to create a Form in spreadsheet

Uploaded time: December 6, 2021 Difficulty: Primary

How to create a Form in spreadsheet

How to create a Form in spreadsheet

Tips: you can turn on the volume by clicking

Want to know more about

Feel free to discuss in our WPS forum

Graphic skills

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.

_1.gif


· 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 > 40 at 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.

_2.gif


· 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.

_3.gif


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