Table View Add/Delete Records in WPS on Windows helps you add new entries and remove unnecessary rows in a multidimensional table; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 3 | Matches the number of rows in the How-to Index |
| Available without membership | 3 | Matches the number of Free rows in the index |
| Membership-related items | 0 | Matches the number of membership-related rows in the index |
About This Feature
Overview
Table View Add/Delete Records is a basic data-maintenance feature in WPS Office for Windows. It helps you add new records, continue entering multiple records, and remove rows that are no longer needed in a multidimensional table.
Core capabilities include:
- Open the Add Record panel from the top toolbar and fill in fields one by one.
- Use the + button at the bottom of the table to add a blank row for faster entry.
- Right-click a target row to delete a record and keep the table organized.
This feature is useful for project trackers, customer lists, task logs, inventory sheets, and other structured data scenarios.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device in a currently supported system environment |
| App version | The latest version of WPS Office is recommended |
| Network | No mandatory network connection for local editing; keep a connection available for collaboration or cloud sync |
| Other | You need access to a file or workspace that contains a multidimensional table and permission to edit the table |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation | Download the Windows installer and complete setup with the installation wizard |
| Post-install check | Open WPS Office, enter the table view, and confirm that you can see the Add Record entry point or the row right-click menu |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In table view, WPS lets you add records from a top Add Record panel, add blank rows from the bottom of the table, and delete records from a row context menu. | Excel tables let you add rows by typing, pasting, or using insert commands, and delete table rows or columns. | Google Sheets lets you insert or delete rows, columns, and cells from the context menu, and add more rows at the bottom of a sheet. | Notion Table view lets you add database entries, edit multiple rows, and manage each row as a database page. | Adobe public help content mainly covers layout tables or PDF-related workflows and does not provide a direct Acrobat equivalent for spreadsheet-style record add/delete tasks. |
| WPS Advantages | Advantage: WPS provides both a panel-based entry flow and an in-table quick-entry flow, which works well for detailed input and fast follow-up entry. | Compared with WPS: Excel documentation focuses on expanding and deleting table rows and columns, rather than a record-details side panel workflow. | Compared with WPS: Google Sheets focuses on row, column, and cell insertion or deletion in a worksheet, while WPS is closer to a form-style record entry flow. | Compared with WPS: Notion is more database-page oriented and less like a traditional spreadsheet cell-entry experience. | Compared with WPS: Adobe does not show a direct same-component workflow for this scenario in its public Acrobat help content. |
| Official Source | — | Resize a table in Excel | Add or move columns and cells in Google Sheets | Table view in Notion | Acrobat Help Center |
Overall Conclusion
For ongoing record entry and cleanup in a multidimensional table, WPS offers two practical entry paths in the same view. Excel and Google Sheets are more worksheet-oriented, Notion is more database-page oriented, and Adobe does not present a direct same-component public workflow for this use case.
Use Cases
| No. | Scenario | Suitable For | Main Challenge | Recommended Approach |
|---|---|---|---|---|
| 1 | Customer data entry | Sales teams, operations teams | Many fields must be filled without missing details | Use the top Add Record panel for field-by-field entry |
| 2 | Task list backfill | Project members | Multiple tasks need to be added quickly | Use the bottom + button to add blank rows and type directly |
| 3 | Inventory log maintenance | Warehouse teams, procurement teams | Outdated or incorrect rows need to be removed quickly | Right-click the target row and delete the record |
| 4 | Shared data cleanup | Collaborative teams | Invalid rows need to be cleaned up consistently | Delete rows directly in table view and use undo when needed |
| 5 | Form-style information collection | Admin teams, HR teams | Entering many fields cell by cell is inefficient | Open the Add Record panel and complete all fields in one place |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Add records in table view | ✅ Available | ✅ Available |
| Delete records in table view | ✅ Available | ✅ Available |
| Core Office features | ✅ Available | ✅ Available |
| More advanced PDF, templates, AI, and larger cloud storage | Available within the free plan scope | Includes broader extended capabilities |
Source: WPS Office pricing page
Recommendations
| Usage Scenario | Recommended Plan | Why |
|---|---|---|
| Daily record entry, deletion, and basic collaboration | Free | This feature itself has no membership restriction for routine data maintenance |
| Record maintenance plus broader PDF, template, AI, or cloud needs | WPS Premium | Suitable if you also need more extended productivity features beyond record management |
How to Subscribe
- WPS membership center: Subscribe to WPS Premium
Source: WPS Office pricing page