How To Make Cells Same Size In Excel

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 calibration.

Type	Min	Max	Default
Cavalcade	0 (hidden)	255	8.43
Row	0 (hidden)	409	fifteen.00

Notes:

If you are working in Folio Layout view (View tab, Workbook Views grouping, Page Layout button), you tin specify a column width or row tiptop in inches, centimeters and millimeters. The measurement unit of measurement is in inches by default. Go to File > Options > Avant-garde > Brandish > select an option from the Ruler Units listing. If you switch to Normal view, and so column widths and row heights volition exist displayed in points.
Individual rows and columns can only have one setting. For example, a unmarried cavalcade tin have a 25 point width, merely it can't be 25 points wide for ane row, and 10 points for another.

Set a column to a specific width

Select the column or columns that you desire to alter.
On the Home tab, in the Cells grouping, click Format.
Under Cell Size, click Column Width.
In the Column width box, type the value that you want.
Click OK.

Tip:To quickly set the width of a unmarried cavalcade, right-click the selected cavalcade, click Cavalcade Width, blazon the value that yous want, and so click OK.

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

Note:To quickly autofit all columns on the worksheet, click the Select All push button, and and then double-click any purlieus between ii column headings.

Select All button

Select a jail cell in the column that has the width that you want to use.
Press Ctrl+C, or on the Home tab, in the Clipboard group, click Re-create.
Correct-click a cell in the target column, betoken to Paste Special, and so click the Go along Source Columns Widths button.

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

Do 1 of the following:
- To change the default column width for a worksheet, click its canvas tab.
- To change the default column width for the unabridged workbook, right-click a sheet tab, and then click Select All Sheets on the shortcut carte.
On the Home tab, in the Cells group, click Format.
Under Cell Size, click Default Width.
In the Standard column width box, type a new measurement, and then click OK.

Do one of the post-obit:

To alter the width of 1 cavalcade, drag the boundary on the right side of the cavalcade heading until the column is the width that you want.
To modify the width of multiple columns, select the columns that yous want to change, and then drag a boundary to the right 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 so double-click the purlieus to the right of a selected column heading.
To change the width of all columns on the worksheet, click the Select All push button, and then drag the boundary of whatever column heading.

Select the row or rows that yous want to change.
On the Home tab, in the Cells grouping, click Format.
Under Cell Size, click Row Height.
In the Row top box, type the value that you lot desire, and then click OK.

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

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

Select All button

Do 1 of the following:

To change the row summit of one row, drag the purlieus below the row heading until the row is the acme that you want.
To modify the row elevation of multiple rows, select the rows that yous desire to change, and then drag the boundary beneath one of the selected row headings.
To alter the row height for all rows on the worksheet, click the Select All button, and and then drag the boundary beneath whatsoever row heading.
To modify the row height to fit the contents, double-click the purlieus beneath the row heading.

Top of Folio

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

In Excel 2007, click the Microsoft Role Push button > Excel Options> Avant-garde.
In Excel 2010, go to File > Options > Avant-garde.

Set a column to a specific width

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

Select the column or columns that you want to change.
On the Home tab, in the Cells group, click Format.
Under Prison cell Size, click AutoFit Cavalcade Width.

Tip To quickly autofit all columns on the worksheet, click the Select All button and then double-click any boundary between 2 column headings.

Select All button

Select a prison cell in the column that has the width that you want to employ.
On the Home tab, in the Clipboard grouping, click Copy, and then select the target column.
On the Home tab, in the Clipboard group, click the arrow below Paste, and and so click Paste Special.
Under Paste, select Cavalcade widths.

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

Do one of the following:
- To change the default cavalcade width for a worksheet, click its sheet tab.
- To modify the default cavalcade width for the unabridged workbook, right-click a sheet tab, and then click Select All Sheets on the shortcut menu.
On the Home tab, in the Cells group, click Format.
Under Prison cell Size, click Default Width.
In the Default column width box, type a new measurement.

Tip If you desire to define the default column width for all new workbooks and worksheets, y'all can create a workbook template or a worksheet template, and so base new workbooks or worksheets on those templates. For more information, come across Salvage a workbook or worksheet as a template.

Do one of the following:

To change the width of one column, drag the purlieus on the right side of the column heading until the cavalcade is the width that y'all desire.
To change the width of multiple columns, select the columns that you lot want to change, and then drag a boundary to the right of a selected cavalcade heading.
To alter the width of columns to fit the contents, select the column or columns that yous desire to alter, and then 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, and and then drag the boundary of any column heading.

Select the row or rows that you want to modify.
On the Home tab, in the Cells group, click Format.
Nether Cell Size, click Row Meridian.
In the Row height box, type the value that you want.

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

Tip To chop-chop autofit all rows on the worksheet, click the Select All button and so double-click the boundary beneath 1 of the row headings.

Select All button

Do one of the following:

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