How to Use WPS Row Height on Android

Use WPS Row Height with 3 how-to topics, including dragging row borders, setting an exact row height, and using AutoFit Row Height; all 3 are available without membership.

How-to Index

How-to Guide

1. Manually Drag to Adjust Row Height

Feature entry: Select the target row, then drag the bottom border of the row header.

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

Success Criteria

• Interface result: The selected row shows a different height.
• What you can do next: You can continue editing, reviewing, or saving the spreadsheet.

Tips While Using

• Common mistake: If the target row is not selected first, the adjustment may not apply as expected.
• Environment note: On smaller screens, zooming in first can make the drag action easier to control.

2. Set an Exact Row Height Value

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

1. Open the spreadsheet and select the row you want to adjust.
2. Tap Tools at the bottom.
3. Open the Home tab.
4. Tap Adjust Row Height and Column Width.
5. Enter the specific row height value.
6. Confirm the setting to apply the new height.

Success Criteria

• Interface result: The selected row changes to the specified fixed height.
• What you can do next: You can apply the same height to other rows or save the file.

Tips While Using

• Common mistake: If the wrong row is selected, the setting may be applied to the wrong area.
• Environment note: If the value is too small, some content may still not display fully.

3. Use AutoFit Row Height

Feature entry: Tools → Home → AutoFit Row Height.

1. Open the spreadsheet and select the row you want to adjust automatically.
2. Tap Tools at the bottom.
3. Open the Home tab.
4. Tap AutoFit Row Height.
5. Wait for the row height to adjust based on the cell content.

Success Criteria

• Interface result: The row height changes automatically according to the content.
• What you can do next: You can check whether wrapped content is now fully visible.

Tips While Using

• Common mistake: If the cell content does not wrap, the visual change after AutoFit may be limited.
• Environment note: The result depends on content length and how the cell content is displayed.