How to Use WPS Row Height on iOS

Use WPS Row Height with 2 how-to topics, including manually dragging row height and setting row height precisely; 2 items are available without membership and 0 items are membership-related.

How-to Index

How-to Guide

1. Manually Drag Row Height

Feature entry: Drag the bottom border of the row number

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

Success Criteria

• Interface result: The selected row becomes taller or shorter, and the visible content area changes with it.
• What you can do next: You can continue editing cells, adjust again, or save the file.

Tips While Using

• Common mistake: If the target row is not selected first, it may be harder to confirm which row you are adjusting.
• Environment note: On a smaller screen, zoom in before dragging the border for more accurate control.

2. Set Row Height Precisely

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

1. Select the row or rows whose height you want to change.
2. Tap the Tools tab at the bottom.
3. Under Home, tap AutoFit Row Height to adjust the row height based on the content.
4. If you want a fixed value, tap Adjust Row Height and Column Width.
5. Enter the specific row height value in the input box.
6. Confirm the change to apply the new row height.

Success Criteria

• Interface result: The row height updates automatically to fit content or changes to the exact value you entered.
• What you can do next: You can continue adjusting other rows or move on to printing, exporting, or further editing.

Tips While Using

• Common mistake: If the value is too small, some content may still not display fully.
• Environment note: If the sheet contains a lot of text, check text wrapping before deciding whether to use a fixed value.