WPS Sheets Record Form Feature Guide

Feature Summary

The record form provides a form-based way to view and manage data, making it ideal for quickly browsing, reviewing, adding, or deleting data in large spreadsheets row by row.

Feature Description

Steps

Opening the Record Form

Feature Entry
"Tools" tab → "Record Form" button

1. Open the spreadsheet you want to work with
2. Select any cell within the data range (generally, selecting a header cell is sufficient)
3. Click the "Record Form" button in the Data tab

Record Form Operation Instructions

1. In the record form window, click "Previous"/"Next" to browse data
2. Click "New" to add a new record, fill in the content for each field, and press Enter to confirm
3. Click "Delete" to remove the current record
4. Click "Criteria" to enter filter conditions and quickly locate target data

FAQ

Q1: What should I do if I cannot find the Record Form button?

• Solution: Ensure that a cell range containing data is selected. If the data range is not recognized as a list, you may need to format the data range as a table first.

Q2: What is the maximum number of columns supported by the record form?

• Solution: The record form displays all columns in the data range by default. If there are too many columns, you may need to scroll within the window to view the full content.

Q3: Can the record form delete data in batches?

• Solution: The record form only supports operations on a record-by-record basis. For batch deletion of data, it is recommended to use the spreadsheet's filter and delete functions.

Notes

• Ensure that the data has a header row before using the record form
• Changes made in the record form are directly reflected in the spreadsheet; it is recommended to back up data before making changes