How To Make All Cells The Same Size In Excel

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

Type	Min	Max	Default
Cavalcade	0 (subconscious)	255	viii.43
Row	0 (hidden)	409	15.00

Notes:

If you are working in Page Layout view (View tab, Workbook Views group, Folio Layout button), you lot can specify a cavalcade width or row superlative 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, and so cavalcade widths and row heights will be displayed in points.
Individual rows and columns tin only have one setting. For example, a unmarried column tin have a 25 signal width, but it can't be 25 points wide for one row, and x points for another.

Gear up a column to a specific width

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

Tip:To chop-chop fix the width of a single column, right-click the selected column, click Column Width, type the value that you want, and and then click OK.

Select the column or columns that yous desire to alter.
On the Abode tab, in the Cells group, click Format.
Under Jail cell Size, click AutoFit Column Width.

Note:To quickly autofit all columns on the worksheet, click the Select All button, then double-click whatever boundary betwixt ii column headings.

Select All button

Select a cell in the cavalcade that has the width that you lot want to apply.
Press Ctrl+C, or on the Domicile tab, in the Clipboard group, click Re-create.
Correct-click a cell in the target column, point to Paste Special, and and so click the Proceed 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 can specify a different number for the default column width for a worksheet or workbook.

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

Practice one of the following:

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

Select the row or rows that you want to change.
On the Home tab, in the Cells group, click Format.
Nether Prison cell Size, click Row Height.
In the Row height box, blazon the value that you lot want, then click OK.

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

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

Select All button

Do one of the following:

To alter the row top of one row, drag the boundary below the row heading until the row is the pinnacle that you lot want.
To alter the row height of multiple rows, select the rows that you want to alter, and then elevate the boundary below ane of the selected row headings.
To alter the row summit 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 purlieus beneath the row heading.

Top of Page

If you prefer to piece of 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 tin specify a column width or row height in inches. In this view, inches are the measurement unit by default, only you can change the measurement unit to centimeters or millimeters.

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

Set a column to a specific width

Select the cavalcade or columns that you desire to change.
On the Dwelling tab, in the Cells group, click Format.
Under Cell Size, click Cavalcade Width.
In the Column width box, type the value that you lot want.

Select the cavalcade or columns that you want to modify.
On the Dwelling house tab, in the Cells group, click Format.
Under Cell Size, click AutoFit Column Width.

Tip To quickly autofit all columns on the worksheet, click the Select All button and so double-click whatsoever boundary between two column headings.

Select All button

Select a jail cell in the column that has the width that yous want to use.
On the Dwelling tab, in the Clipboard group, click Copy, and then select the target column.
On the Domicile tab, in the Clipboard group, click the pointer below Paste, and then click Paste Special.
Under Paste, select Column widths.

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

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

Tip If you desire to define the default cavalcade width for all new workbooks and worksheets, you tin 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 i of the following:

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

Select the row or rows that you lot want to alter.
On the Habitation tab, in the Cells grouping, click Format.
Under 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 rapidly autofit all rows on the worksheet, click the Select All button and then double-click the boundary below one of the row headings.

Select All button

Exercise i of the following:

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

Superlative of Page

Run into Also

Modify the column width and row elevation in Excel for Mac

Change the column width and row height in Excel Online

Overview of formulas in Excel

How to avoid broken formulas

Discover and right errors in formulas

Excel keyboard shortcuts and function keys

Excel functions (alphabetical)

Excel functions (by category)