Changing the default column width

You can change the default column width for the worksheet you are currently working in.

  1. In the action bar, click Worksheet.

  2. In the pop-up menu, click Properties.

  3. At the top of the pop-up panel, click Column/Row.

  4. Click the arrows or enter a number in the box for Set default column width to.

    Your change takes effect immediately.

  5. To close the pop-up panel, click Pop-up panel close button.



Details



Effect of column width on numbers and text

When a column is too narrow to display an entire number value as it is formatted, *** (asterisks) appear in the cell, or the number is displayed in Scientific format. To display the number, widen the column to one character wider than the length of the number as formatted.

If a text entry is longer than the cell where it is entered and the cells to the right are blank, the text displays across the blank cells. If the cells to the right contain data, your spreadsheet displays only the part of the text that fits in the cell where it is entered. To see the complete text entry you must widen the column. You can override the default column width by sizing the column. For more information, see Sizing columns.



See also
Changing the default alignment
Changing the default number format
Changing the default background and text color
Changing the default row height
Changing the default font
Why do I need number formats?