When using WPS Row Height and Column Width on macOS, common questions usually involve measurement units, batch adjustment results, and restoring default width; this FAQ covers 4 common questions.
FAQ
What should I do if the row height value looks inaccurate after I set it?
- Make sure you are entering a value in points, not centimeters or pixels.
- If you need a centimeter-based height, convert the value before entering it.
- Open the Row Height dialog again and enter the corrected value.
Why do all selected rows or columns become the same size after a batch adjustment?
- When you apply one setting to multiple selected rows or columns, 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 instead.
- If you need finer control, select rows or columns one at a time and adjust them separately.
How do I quickly restore all columns to the default width?
- Select all columns that you want to restore.
- Click the Rows & Columns drop-down under the Insert tab.
- Select Standard Column Width to restore the default width of 8.18 characters.
Why is Standard Column Width missing from the right-click menu?
- The right-click menu provides common commands such as row height, column width, and AutoFit.
- Standard Column Width is available only in the Insert → Rows & Columns menu.
- If you need to restore the default width, open that command from the top menu bar.
Glossary
| Term | Definition |
|---|---|
| Row Height | The display height of a worksheet row. In this feature, it is set in points. |
| Column Width | The display width of a worksheet column. In this feature, it is set in characters. |
| AutoFit Row Height | A command that adjusts row height automatically based on cell content height. |
| AutoFit Column Width | A command that adjusts column width automatically based on cell content width. |
| Standard Column Width | A command that restores column width to the default value of 8.18 characters. |