How to Use WPS Row Height and Column Width on Android

Use Row Height and Column Width with 2 how-to topics, including dragging to adjust row height and dragging to adjust column width; choose a topic from the index and follow the entry point and steps.

How-to Index

How-to Guide

1. Adjust row height by dragging

Entry point: Drag the bottom border of the row label

1. Open a smart spreadsheet file and select the row you want to adjust.
2. Touch and hold the row border on the left side of the row label.
3. Drag up or down to adjust the row height in real time.
4. Release your finger to finish.

Success Criteria

• On-screen result: The target row becomes taller or shorter, and the visible cell area changes with it.
• What you can do next: You can continue editing cell content 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 resize mode.
• Environment note: On a smaller screen, zoom in first for more precise control.

2. Adjust column width by dragging

Entry point: Drag the side border of the column label

1. Open a WPS spreadsheet file and select the column you want to adjust.
2. Touch and hold the right border of the column label.
3. Drag left or right to adjust the column width in real time.
4. Release your finger to finish.

Success Criteria

• On-screen result: The target column becomes wider or narrower, and the visible range for text or numbers changes.
• What you can do next: You can continue reviewing full content, editing data, or adjusting other columns.

Tips While Using

• Common mistake: If a column stays too narrow, some numbers may still not display fully, so continue widening it as needed.
• Environment note: If the sheet has many columns, scroll horizontally to the target area first.