How to Use WPS Row Height and Column Width on macOS

Use Row Height and Column Width with 4 how-to topics in WPS Spreadsheet; all 4 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Set row height or column width from the Row and Column menu

Entry: Insert → Row and Column drop-down

1. Select the row or column that you want to adjust.
2. Click the Insert tab and open the Row and Column drop-down.
3. Select Row Height or Column Width.
4. Enter the target value in the input box.
5. Confirm the change.

Success Criteria

• Interface result: The selected row height or column width updates to the value that you entered.
• What you can do next: Continue editing cells, save the file, or make more formatting changes.

Tips While Using

• Row height is measured in points, and the default value is 13.5 points.
• Column width is measured in characters, and the default value is 8.18 characters.

2. Resize row height or column width from the right-click shortcut menu

Entry: Right-click a row number or column label

1. Select the target row or column.
2. Right-click the row number or column label to open the shortcut menu.
3. Select Row Height to change row height, or select Column Width to change column width.
4. Enter the target value and confirm it.

Success Criteria

• Interface result: The target row or column changes size immediately.
• What you can do next: Repeat the same action for other rows or columns.

Tips While Using

• The shortcut menu is useful for quickly adjusting the current row, column, or a continuous selection.
• If you want to restore the default column width, use Standard Column Width from the Row and Column menu instead.

3. Use auto-fit row height or column width to match content automatically

Entry: Insert → Row and Column, or the right-click shortcut menu

1. Select the rows or columns that need to fit their content.
2. Open the Row and Column menu or the right-click shortcut menu.
3. Select Auto Fit Row Height or Auto Fit Column Width.
4. Review the result and repeat the action for other areas if needed.

Success Criteria

• Interface result: Row height or column width changes automatically based on cell content.
• What you can do next: Long text, wide values, or multi-line content becomes easier to view.

Tips While Using

• This method is useful for worksheets with very different text lengths.
• Standard Column Width is available only in the Row and Column menu, not in the right-click shortcut menu.

4. Drag borders to resize a single row, multiple rows, a single column, or multiple columns

Entry: Drag a row border or column border

1. Select the target row or column, or select multiple rows or columns first.
2. Move the pointer to the row border or column border until the resize pointer appears.
3. Click and drag the border to increase or decrease the row height or column width.
4. Release the mouse to apply the change.

Success Criteria

• Interface result: The selected area updates to the new size after dragging.
• What you can do next: Continue resizing other areas or save the worksheet.

Tips While Using

• When multiple selected rows or columns are dragged, the related area is resized to the same dimension.
• If you need more exact control, use menu-based value entry instead.