The value for the default column width indicates the average number of characters of the standard font that fit in a cell. You can specify a different number for the default column width for a worksheet or workbook.
Do one of the following:
Do one of the following:
Top of Page
If you prefer to work with column widths and row heights in inches, you should work in Page Layout view (View tab, Workbook Views group, Page Layout button). In Page Layout view, you can specify a column width or row height in inches. In this view, inches are the measurement unit by default, but you can change the measurement unit to centimeters or millimeters.
Tip To quickly autofit all columns on the worksheet, click the Select All button and then double-click any boundary between two column headings.
The value for the default column width indicates the average number of characters of the standard font that fit in a cell. You can specify a different number for the default column width for a worksheet or workbook.
Tip If you want to define the default column width for all new workbooks and worksheets, you can create a workbook template or a worksheet template, and then base new workbooks or worksheets on those templates. For more information, see Save a workbook or worksheet as a template.
Do one of the following:
Tip To quickly autofit all rows on the worksheet, click the Select All button and then double-click the boundary below one of the row headings.
Do one of the following:
Top of Page |