How to Use WPS Row Height and Column Width on Windows

Use Row Height and Column Width with 4 how-to topics in WPS Spreadsheet for Windows; 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 point: Select the target row or column → Insert tab → Row and Column drop-down

1. Select the row or column that you want to adjust in the worksheet.
2. Click the Insert tab and open the Row and Column drop-down.
3. To set an exact row size, select Row Height. To set an exact column size, select Column Width.
4. Enter the value that you want to use.
5. Click the confirm button (√) to apply the change.

Success Criteria

• The selected row height or column width changes immediately.
• Nearby unselected rows or columns keep their original size.
• You can continue entering data, saving the file, or applying other formatting.

Tips While Using

• Row height is measured in points, and column width uses a character-based unit.
• Exact values are useful for templates, reports, and worksheets that need consistent sizing.

2. Use automatic fitting and standard column width

Entry point: Select the target row or column → Insert tab → Row and Column drop-down

1. Select the row or column that you want to fit to content.
2. Open the Row and Column drop-down.
3. Select Auto Fit Row Height or Auto Fit Column Width to adjust size automatically based on content.
4. If you want to restore a default column width, select Standard Column Width.
5. Check whether the content is fully visible and make more adjustments if needed.

Success Criteria

• Long text can be displayed more completely.
• After you select Standard Column Width, the target columns return to a default width.
• The worksheet layout becomes easier to read and edit.

Tips While Using

• Automatic fitting is useful when content length varies across a range.
• The Standard Column Width command is available in the Row and Column menu, not in the right-click menu.

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

Entry point: 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. For rows, select Row Height or Auto Fit Row Height. For columns, select Column Width or Auto Fit Column Width.
4. If you selected a value-based command, enter the target value.
5. Click the confirm button (√) to finish the adjustment.

Success Criteria

• You can complete the adjustment without switching to the ribbon.
• The result matches the same setting from the ribbon menu.
• You can continue copying, filling, or formatting the worksheet.

Tips While Using

• The right-click menu is useful for quick local edits.
• If you need to restore a standard column width, use the Row and Column menu instead.

4. Resize single or multiple rows and columns by dragging borders

Entry point: Drag a row border or column border

1. Select the target row or column. To resize in batch, select multiple rows or columns first.
2. Move the pointer to the row or column border until the resize pointer appears.
3. Drag the border to increase or decrease the row height or column width.
4. Release the mouse to apply the new size.
5. Repeat the same action if you want to standardize more areas.

Success Criteria

• The target row or column changes size immediately after dragging.
• When multiple rows or columns are selected, the selected area can be resized together.
• You can preview the layout change visually and continue editing.

Tips While Using

• Dragging is useful for quick visual adjustment.
• After batch dragging, the selected rows or columns usually use the same size.