How to Use WPS Row Height on iOS

Use WPS Row Height on iOS through 3 how-to topics, including manual drag adjustment, AutoFit Row Height, and exact row height setting; choose a topic from the index below.

How-to Index

How-to Guide

1. Manually drag to adjust row height

Feature entry: Drag the bottom border of the row header

1. Open a WPS spreadsheet file.
2. Select the row you want to adjust.
3. Press and hold the row boundary next to the row number.
4. Drag up or down to change the row height in real time.
5. Release your finger to finish the adjustment.

Success Criteria

• On-screen result: The selected row becomes taller or shorter.
• What you can do next: You can continue editing cells or adjust other rows.

Tips While Using

• Common mistake: If the target row is not selected first, it may be harder to drag the correct boundary accurately.
• Environment note: On a smaller screen, zooming in first can make fine adjustments easier.

2. Use AutoFit Row Height

Feature entry: Tools tab → Home → AutoFit Row Height

1. Select the row you want to adjust.
2. Tap the Tools tab at the bottom.
3. Under Home, tap AutoFit Row Height.
4. Wait for the row height to adjust based on the current content.

Success Criteria

• On-screen result: The row height changes automatically to fit the cell content.
• What you can do next: You can keep typing or continue with an exact row height setting.

Tips While Using

• Common mistake: If text wrapping is not enabled, the final display may still need additional adjustment.
• Environment note: Select the target row before running the command.

3. Set an exact row height value

Feature entry: Tools tab → Home → Adjust Row Height and Column Width

1. Select the row whose height you want to change.
2. Tap the Tools tab at the bottom.
3. Under Home, tap Adjust Row Height and Column Width.
4. Enter a specific row height value in the pop-up box.
5. Confirm to apply the setting.

Success Criteria

• On-screen result: The selected row changes to the value you entered.
• What you can do next: You can reuse the same value on other rows for a more consistent layout.

Tips While Using

• Common mistake: A value that is too small may leave content partially hidden.
• Environment note: Choose the value based on content length and print needs.