WPS Row Height and Column Width on iOS FAQ

Last updated:July 20, 2026

When using Row Height and Column Width, common questions usually focus on content display, batch resizing, and identifying the correct resize border; this FAQ includes 3 common questions and 3 glossary terms.

FAQ

What should I do if data is truncated after I narrow a column?

  1. Check whether the numbers or text in the cell are not fully visible because the column is too narrow.
  2. Select the target column and touch and hold the right border of the column header.
  3. Drag to the right until the content is fully visible, then release your finger.
  4. If numbers display as ###, continue widening the column as needed.

How do I adjust the width of multiple columns at the same time?

  1. Select the multiple columns that you want to resize together in the spreadsheet.
  2. Touch and hold the right border of one of the selected columns.
  3. Drag the border left or right and watch the selected columns change together.
  4. Release your finger when the width is appropriate.

How do I adjust the height of multiple rows at once?

  1. Select the multiple rows that you want to resize together in the spreadsheet.
  2. Touch and hold the lower border of one of the selected rows.
  3. Drag the border up or down and watch the selected rows change together.
  4. Release your finger when the adjustment is complete.

Glossary

TermDefinition
Row heightThe display height of a single row in a spreadsheet. Changing it affects how much of the row content is visible.
Column widthThe display width of a single column in a spreadsheet. Changing it affects how fully text, numbers, or formulas can be shown.
Row or column borderThe draggable boundary next to a row header or column header that you use to resize spreadsheet dimensions manually.