How To Make Columns The Same Size In Excel

If you find yourself needing to expand or reduce Excel's row widths and column heights, at that place 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	fifteen.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 > Avant-garde > Brandish > select an choice from the Ruler Units list. If you lot switch to Normal view, so column widths and row heights will be displayed in points.
Individual rows and columns can but have one setting. For example, a unmarried column can have a 25 point width, but it tin't exist 25 points wide for one row, and 10 points for another.

Set a column to a specific width

Select the column or columns that yous want to change.
On the Home tab, in the Cells group, click Format.
Under Prison cell Size, click Column Width.
In the Column width box, type the value that you desire.
Click OK.

Tip:To chop-chop ready the width of a unmarried column, right-click the selected cavalcade, click Column Width, blazon the value that y'all want, then click OK.

Select the column or columns that you want to change.
On the Domicile tab, in the Cells group, click Format.
Under Cell Size, click AutoFit Column Width.

Annotation:To apace autofit all columns on the worksheet, click the Select All push button, so double-click whatsoever boundary between two cavalcade headings.

Select All button

Select a cell in the column that has the width that you desire to apply.
Press Ctrl+C, or on the Dwelling house tab, in the Clipboard group, click Copy.
Correct-click a cell in the target column, point to Paste Special, so click the Keep Source Columns Widths push button.

The value for the default column width indicates the average number of characters of the standard font that fit in a cell. Yous can specify a different number for the default column width for a worksheet or workbook.

Do ane of the following:
- To change the default column width for a worksheet, click its sail tab.
- To change the default column width for the entire workbook, correct-click a sheet tab, and so click Select All Sheets on the shortcut menu.
On the Dwelling tab, in the Cells group, click Format.
Under Jail cell Size, click Default Width.
In the Standard column width box, type a new measurement, and then click OK.

Do 1 of the following:

To change the width of one column, drag the boundary on the correct side of the column heading until the cavalcade is the width that you want.
To modify the width of multiple columns, select the columns that you want to change, and then drag a boundary to the correct of a selected column heading.
To modify the width of columns to fit the contents, select the column or columns that you want to change, and and so double-click the boundary to the correct of a selected column heading.
To change the width of all columns on the worksheet, click the Select All button, then drag the purlieus of any cavalcade heading.

Select the row or rows that you lot want to alter.
On the Home tab, in the Cells group, click Format.
Nether Cell Size, click Row Height.
In the Row height box, type the value that you want, and then click OK.

Select the row or rows that you want to modify.
On the Home tab, in the Cells group, click Format.
Under Cell Size, click AutoFit Row Acme.

Tip:To quickly autofit all rows on the worksheet, click the Select All push button, then double-click the boundary below one of the row headings.

Select All button

Do ane of the following:

To change the row top of one row, drag the boundary below the row heading until the row is the superlative that you lot want.
To change the row pinnacle of multiple rows, select the rows that yous want to change, and so drag the boundary beneath one of the selected row headings.
To change the row pinnacle for all rows on the worksheet, click the Select All push, and then drag the boundary below any row heading.
To change the row height to fit the contents, double-click the boundary below the row heading.

Acme of Page

If you adopt to work with column widths and row heights in inches, you should work in Page Layout view (View tab, Workbook Views group, Folio Layout push button). In Page Layout view, you tin specify a column width or row height in inches. In this view, inches are the measurement unit past default, but you lot can change the measurement unit to centimeters or millimeters.

In Excel 2007, click the Microsoft Office Push > Excel Options> Advanced.
In Excel 2010, go to File > Options > Advanced.

Prepare a column to a specific width

Select the column or columns that you want to change.
On the Domicile tab, in the Cells group, click Format.
Under Prison cell Size, click Column Width.
In the Cavalcade width box, type the value that you want.

Select the column or columns that yous want to change.
On the Home tab, in the Cells group, click Format.
Nether Cell Size, click AutoFit Column Width.

Tip To quickly autofit all columns on the worksheet, click the Select All button and so double-click any purlieus betwixt two column headings.

Select All button

Select a cell in the cavalcade that has the width that you lot desire to utilize.
On the Home tab, in the Clipboard group, click Copy, then select the target column.
On the Home tab, in the Clipboard group, click the arrow below Paste, so click Paste Special.
Under Paste, select Cavalcade widths.

The value for the default column width indicates the boilerplate number of characters of the standard font that fit in a jail cell. You tin can specify a different number for the default column width for a worksheet or workbook.

Do ane of the following:
- To change the default column width for a worksheet, click its sheet tab.
- To change the default column width for the entire workbook, correct-click a sheet tab, and and then click Select All Sheets on the shortcut menu.
On the Home tab, in the Cells group, click Format.
Under Cell Size, click Default Width.
In the Default cavalcade width box, blazon a new measurement.

Tip If y'all desire to define the default column width for all new workbooks and worksheets, you lot can create a workbook template or a worksheet template, and then base new workbooks or worksheets on those templates. For more data, see Save a workbook or worksheet equally a template.

Practise one of the following:

To change the width of 1 column, drag the boundary on the right side of the column heading until the column is the width that you want.
To change the width of multiple columns, select the columns that yous want to modify, and then elevate a boundary to the correct of a selected column heading.
To change the width of columns to fit the contents, select the column or columns that you want to alter, and and then double-click the boundary to the right of a selected column heading.
To change the width of all columns on the worksheet, click the Select All button, and then drag the boundary of any column heading.

Select the row or rows that yous want to change.
On the Habitation tab, in the Cells group, click Format.
Nether Jail cell Size, click Row Height.
In the Row height box, blazon the value that you want.

Select the row or rows that you want to change.
On the Home tab, in the Cells group, click Format.
Under Cell Size, click AutoFit Row Height.

Tip To quickly autofit all rows on the worksheet, click the Select All button and then double-click the purlieus below one of the row headings.

Select All button

Do one of the following:

To change the row peak of ane row, drag the boundary below the row heading until the row is the height that you want.
To change the row top of multiple rows, select the rows that you lot want to change, and then drag the boundary below one of the selected row headings.
To alter the row peak for all rows on the worksheet, click the Select All push button, and so drag the boundary beneath any row heading.
To change the row height to fit the contents, double-click the boundary below the row heading.