Common questions about Row Height and Column Width usually involve measurement units, batch adjustment results, and restoring default column width; this section includes 3 FAQs and a glossary.
FAQ
Why does the visible row height look different from what I expected after I set it?
- Check whether the value you entered is in points.
- If you need to estimate another length unit, convert it before entering the value.
- If the cell contains more content, try AutoFit Row Height to see whether it matches the display you need.
Why do multiple rows or columns become the same size after a batch adjustment?
- When you select multiple rows or columns and apply one setting, the selected area uses the same size.
- If you want each row or column to fit its own content, use AutoFit Row Height or AutoFit Column Width.
- If you need finer control, select one row or one column at a time and adjust it again.
How can I quickly restore all columns to the default width?
- Select all columns that you want to restore.
- Click the Rows and Columns drop-down button on the Insert tab.
- Select Standard Column Width to restore the default width of 8.18 characters.
Glossary
| Term | Definition |
|---|---|
| Row Height | The display height of a worksheet row. In WPS Spreadsheet, it is set in points. |
| Column Width | The display width of a worksheet column. In WPS Spreadsheet, it can be set by character width. |
| AutoFit Column Width | A command that adjusts column width automatically based on cell content. It is useful for long text or wide fields. |
| Standard Column Width | A command that restores a column to the default width, which is 8.18 characters. |