This FAQ covers 3 common questions about WPS Column Width on iOS, including truncated content, multi-column adjustment, and the difference between AutoFit and fixed values.
FAQ
What should I do if data is truncated after I narrow a column?
- Check whether numbers or text are no longer fully visible because the column is too narrow.
- Drag the column border to the right to increase the width.
- If you want a faster adjustment, use AutoFit Column Width so the content can match the available width automatically.
How do I adjust the width of multiple columns at the same time?
- Select the multiple columns that you want to standardize.
- Open the row height and column width setting entry.
- Enter the same width value and confirm so the selected columns use a consistent width.
What is the difference between AutoFit Column Width and entering a fixed value?
- AutoFit Column Width adjusts the width automatically based on the current content.
- Entering a fixed value is better when you want a consistent layout or a specific formatting standard.
- If you want both readability and a neat layout, start with AutoFit and then fine-tune manually if needed.
Glossary
| Term | Definition |
|---|---|
| Column width | The visible width of a column in a worksheet, which affects how much cell content can be shown. |
| AutoFit Column Width | A method that adjusts column width automatically based on the current cell content. |
| Row Height and Column Width | A settings entry used to enter a specific row height or column width value. |