Change Column Width and Row Height

If you find yourself needing to expand or reduce Excel's row widths and column heights, there are several ways to adjust them. The table below shows the minimum, maximum and default sizes for each based on a point scale.

Type	Min	Max	Default
Column	0 (hidden)	255	8.43
Row	0 (hidden)	409	15.00

Notes: 

·         If you are working in Page Layout view (View tab, Workbook Views group, Page Layout button), you can specify a column width or row height in inches, centimeters and millimeters. The measurement unit is in inches by default. Go to File > Options > Advanced > Display > select an option from the Ruler Units list. If you switch to Normal view, then column widths and row heights will be displayed in points.

·         Individual rows and columns can only have one setting. For example, a single column can have a 25 point width, but it can't be 25 points wide for one row, and 10 points for another.

Set a column to a specific width

1.     Select the column or columns that you want to change.

2.     On the Home tab, in the Cells group, click Format.

3.     Under Cell Size, click Column Width.

4.     In the Column width box, type the value that you want.

5.     Click OK.