In Excel 2013, you can change any column widths or row heights in your worksheets to improve the readability and appearance of data. For example, if your worksheet contains many numbers, you can widen the columns to make the worksheet less cluttered. You should always widen columns that contain cells with truncated text entries or numbers that Excel shows as ######.
Based on the default 11-point Calibri font, the default column width is 8.43 and the default row height is 15. If you change the default font type or size, Excel may also change the standard column width or row height. You can manually set a default column width by choosing Format→Standard Width in the Cells group on the Home tab. You cannot manually set a default row height.
Adjusting column widths
Follow these steps to adjust the width of one or more columns:
- Select the columns whose width you want to change. You select an entire column by clicking its column letter. If you want to adjust a single column, click any cell in that column.
- Choose a method to adjust column width:
- To manually change the width of columns, position the mouse pointer on the right boundary of a column heading until it turns into a double-sided arrow. Drag until the column is the width that you want.
- To set a column width to a specific setting, choose Format > Column Width on the Home tab. Type the exact width you want in the Column Width dialog box; then click OK.
- To automatically change the column width so it fits the widest entry, use AutoFit. Double-click the boundary on the right side of the column heading or choose Format > AutoFit Column Width on the Home tab.
Changing row heights
To change the height of one or more rows, follow these steps:
Select the rows whose height you want to adjust.
To select an entire row, click on the row number on the left. If you want to adjust a single row, click any cell in that row.
Choose a method to adjust row height:
- To manually change the row height, position the mouse pointer on the bottom boundary of the row heading until it turns into a double-sided arrow. Drag until the row is the height that you want.
- To set a row height to a specific setting, choose Format > Row Height on the Home tab. Type the exact height you want in the Row Height dialog box; then click OK.
- To automatically change the height of a row so it fits the tallest entry in the row, use AutoFit. Double-click the boundary on the bottom of the row heading or choose Format > AutoFit Row Height on the Home tab.