Guide to Using Row Height and Column Width Features in WPS Sheets Collaboration Mode

Feature Summary

The Row Height and Column Width feature supports adjusting the table layout through menu settings, right-click operations, and manual dragging, helping users flexibly control row and column dimensions to enhance data presentation.

Feature Description

Operation Steps

Adjust via the "Rows & Columns" Menu

Feature Entry
"Insert" tab → "Rows & Columns" dropdown button

1. Select the row or column you want to adjust
2. Click the "Rows & Columns" dropdown button in the "Insert" tab
3. In the dropdown menu, you can perform the following row height and column width settings:

• "Row Height": Enter a value to set the row height precisely (unit: points), default is 13.5 points
• "AutoFit Row Height": The system automatically adjusts the row height based on the content height
• "Column Width": Enter a value to set the column width precisely (unit: characters), default is 8.18 characters
• "AutoFit Column Width": The system automatically adjusts the column width based on the content width
• "Standard Column Width": Resets the column width to the standard default width (8.18 characters)

4. After entering the target value in the corresponding value box, click the confirm button (√) to apply

Adjust via the Right-Click Shortcut Menu

Feature Entry
Right-click the row number/column header

1. Select the target row or column, right-click to open the context menu
2. Available operations:

• Right-click the row number: Select "Row Height" to enter a value and adjust the row height, or select "AutoFit Row Height" for automatic adjustment
• Right-click the column header: Select "Column Width" to enter a value and adjust the column width, or select "AutoFit Column Width" for automatic adjustment

3. After entering the target value, click the confirm button (√) to apply

Notes

• "Standard Column Width" is only available in the "Insert" → "Rows & Columns" menu, not in the right-click context menu
• Using "AutoFit Row Height/Column Width" can automatically adapt to multi-line or wide text content.
• The settings in the "Rows & Columns" menu are consistent with those in the right-click menu. The difference is that the "Rows & Columns" menu additionally includes adding/deleting rows and columns and the standard column width.