An easy way to size a column by eye is just to drag the column border.
Tip To size more than one column at a time, drag across the column letters to select the columns you want to size, and then drag the border of one of them.
Use this method of sizing columns when you want to size them to a particular width rather than just sizing them by eye.
When a column is too narrow to display an entire number as formatted, the number appears in as a line of *** (asterisks) or in scientific (exponential) notation, with up to 15 decimal places and an exponent of up to 3 digits; for example, the number displays in Scientific format as 1.23E+002.
To display the number, you must widen the column to the width of the formatted number.
If text in a cell is longer than the cell it occupies and the cells to the right are blank, the text displays across the blank cells. If the cells to the right contain data, only the part of the text that fits in the cell displays where it is entered. To see all the text, you must widen the column.