How to Use WPS Row Height and Column Width on macOS

Use WPS Row Height and Column Width on macOS with 5 how-to topics, all available directly in the spreadsheet editing interface; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Set row height from the Rows & Columns menu

Feature entry: Select the target row → Insert tab → Rows & Columns drop-down → Row Height

1. Select the row you want to adjust.
2. Click the Rows & Columns drop-down under the Insert tab.
3. Select Row Height.
4. Enter the target value.
5. Click the confirm button (√) to apply the setting.

Success Criteria

• Interface result: The selected row updates to the entered height.
• What you can do next: Continue editing cells or adjust other rows.

Tips While Using

• Row height is measured in points.
• The maximum row height is 409 points.

2. Set column width from the Rows & Columns menu

Feature entry: Select the target column → Insert tab → Rows & Columns drop-down → Column Width

1. Select the column you want to adjust.
2. Click the Rows & Columns drop-down under the Insert tab.
3. Select Column Width.
4. Enter the target width in characters.
5. Click the confirm button (√) to apply the setting.

Success Criteria

• Interface result: The selected column updates to the entered width.
• What you can do next: Continue entering data or adjust other columns.

Tips While Using

• Column width is measured in characters.
• The maximum column width is 255 characters.

3. Use AutoFit row height or column width

Feature entry: Select the target row or column → Insert tab → Rows & Columns drop-down

1. Select the row or column you want to fit automatically.
2. Open the Rows & Columns drop-down menu.
3. To adjust height based on content, select AutoFit Row Height.
4. To adjust width based on content, select AutoFit Column Width.
5. Review the updated display result.

Success Criteria

• Interface result: The row height or column width changes automatically based on content.
• What you can do next: Keep entering content and run AutoFit again when needed.

Tips While Using

• This is useful for wrapped text or longer field values.
• If you select multiple rows or columns, you can apply AutoFit in one action.

4. Restore the standard column width

Feature entry: Select the target column → Insert tab → Rows & Columns drop-down → Standard Column Width

1. Select the column you want to restore to the default width.
2. Click the Rows & Columns drop-down under the Insert tab.
3. Select Standard Column Width.
4. Confirm the restored result.

Success Criteria

• Interface result: The selected column returns to the standard default width of 8.18 characters.
• What you can do next: Continue standardizing other columns or enter data.

Tips While Using

• Standard Column Width is available only in the Insert → Rows & Columns menu.
• This option is not included in the right-click menu.

5. Adjust row height or column width from the right-click menu

Feature entry: Right-click the row number or column header

1. Select the target row or column.
2. Right-click the row number or column header to open the context menu.
3. For rows, select Row Height or AutoFit Row Height.
4. For columns, select Column Width or AutoFit Column Width.
5. Enter the target value and click the confirm button (√), or review the AutoFit result directly.

Success Criteria

• Interface result: The selected row or column is adjusted according to the chosen command.
• What you can do next: Continue working on other rows or columns without switching to the top menu bar.

Tips While Using

• The right-click menu is useful for quick local adjustments.
• If you need to restore the standard column width, use the Insert → Rows & Columns menu instead.