You can change the default column width for the worksheet you are currently working in.
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.