WPS Row Height is the row height adjustment feature in WPS Spreadsheet on iOS; it includes 2 core tasks, with 2 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 2 | Matches the number of rows in the How-to Index |
| Available without membership | 2 | 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
Row Height helps you adjust the height of one or more spreadsheet rows so cell content is easier to read and the sheet layout stays organized. In WPS Spreadsheet on iOS, you can adjust row height by dragging the row border for quick changes, or use the tool panel to autofit row height or enter a specific value for more precise control.
Core capabilities include:
- Drag to adjust row height manually for quick visual changes.
- Set row height precisely with autofit or a custom value for cleaner formatting.
Common use cases include class schedules, data lists, and print preparation. It helps when content is cut off or when multiple rows need a more consistent layout. On mobile, this makes it easier to update spreadsheet formatting without switching to a desktop device.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A supported iPhone or iPad environment |
| App version | It is recommended to use the latest version of WPS Office |
| Network | Row height adjustment is a local editing action and does not require a constant network connection |
| Other | You need to open a WPS spreadsheet file and have permission to edit it |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Office, open a spreadsheet, select any row, and confirm that options such as AutoFit Row Height or Adjust Row Height and Column Width are available |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports adjusting spreadsheet row height on iOS by dragging the row border, using AutoFit Row Height, or entering a specific value. | Word lets users specify row height in Table Properties and set rows to expand with content by using an At least height option. | Google Sheets lets users resize rows with a custom height or Fit to data, and also supports dragging row edges. | Notion table views support row reordering, column resizing, and wrapped content, but the help page does not describe traditional spreadsheet-style fixed row height value controls. | Adobe InCopy supports Row Height settings in table options and also allows row resizing by dragging. |
| WPS Advantages | Advantage: WPS combines drag adjustment, autofit, and exact value entry in a mobile spreadsheet workflow that is convenient for quick edits on iPhone or iPad. | Compared with WPS: the official guidance focuses on table row settings in Word documents rather than mobile spreadsheet editing. | Compared with WPS: Google Sheets supports custom row height and Fit to data, but the official instructions are centered on browser-based desktop steps. | Compared with WPS: Notion tables are designed more for database-style organization and wrapped content than spreadsheet row height control. | Compared with WPS: Adobe provides detailed table formatting controls, but the documented workflow is oriented toward publishing and layout editing. |
| Official Source | — | Set table cells to expand with contents in Word | Add or move columns and cells | Table view | Formatting tables |
Overall Conclusion
For spreadsheet editing on iPhone or iPad, WPS Row Height is well suited to quick mobile formatting because it supports drag-based adjustment, autofit, and exact value entry in one workflow. If your work is more focused on document tables, browser-based sheets, or publishing layouts, the other products may fit those specific scenarios better.
Use Cases
| No. | Scenario | Suitable for | Main issue | Solution |
|---|---|---|---|---|
| 1 | Class schedule cleanup | Students and teachers | Wrapped text is not fully visible | Use AutoFit Row Height to match the content |
| 2 | Data list formatting | Office users | Uneven row heights reduce readability | Enter a consistent row height value |
| 3 | Quick mobile edits | Users working away from a desk | It is inconvenient to switch to a computer | Drag the row border directly on iOS |
| 4 | Print preparation | Users preparing exports or printouts | Printed content may be cut off | Adjust row height before previewing or printing |
| 5 | Multi-row cleanup | Spreadsheet maintainers | Several rows need the same layout | Select multiple rows and apply one row height setting |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Row height adjustment | ✅ Available | ✅ Available |
| Basic spreadsheet editing | ✅ Available | ✅ Available |
| Additional advanced office and PDF benefits | Available within the free offering shown on the pricing page | Includes more advanced features and expanded benefits |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Everyday viewing and simple spreadsheet edits | Free | Row height adjustment is available directly and works well for light editing |
| Frequent document work with broader advanced office needs | WPS Premium | In addition to basic editing, it can be paired with more advanced features across document workflows |
How to Subscribe
- WPS membership center: Subscribe to WPS Premium
Source: WPS Office pricing page