How to Use WPS Row Height on Android

Use WPS Row Height on Android through 3 how-to topics, all available without membership; choose a topic from the index and follow the steps to complete the adjustment.

How-to Index

How-to Guide

1. Manually Drag to Adjust Row Height

Feature entry: Drag the bottom border of the row number

1. Open your WPS spreadsheet file.
2. Select the row you want to adjust.
3. Long-press the row border next to the row number.
4. Drag up or down to adjust the row height in real time.
5. Release your finger to finish.

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 you do not press the row border accurately, you may only select the row instead of entering drag adjustment.
• Environment note: On a small screen, zooming in first can make the drag area easier to control.

2. Set an Exact Row Height Value

Feature entry: Tools → Home → Adjust Row Height & Column Width

1. Select the row whose height you want to change.
2. Tap Tools at the bottom.
3. Open the Home tab.
4. Tap Adjust Row Height & Column Width.
5. Enter the specific row height value in the input box.
6. Confirm the change to apply the new height.

Success Criteria

• On-screen result: The selected row updates to the entered height.
• What you can do next: You can repeat the same steps for other rows or review the worksheet layout.

Tips While Using

• Common mistake: If the target row is not selected first, the result may not match your expectation.
• Environment note: Confirm the full row range before entering a fixed value for consistent formatting.

3. Use AutoFit Row Height

Feature entry: Tools → Home → AutoFit Row Height

1. 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. WPS adjusts the row height 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 editing content and run AutoFit again if needed.

Tips While Using

• Common mistake: If the content is short, the visual change after AutoFit may be small.
• Environment note: AutoFit is usually more useful after most content has already been entered.