How to create a Form in spreadsheet

Uploaded time: December 6, 2021 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

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.