What Must You Do To Change The Row Height Of A Table?

sIf y'all find yourself needing to aggrandize or reduce Excel's row widths and column heights, at that place are several ways to conform them. The table below shows the minimum, maximum and default sizes for each based on a point scale.

Blazon	Min	Max	Default
Cavalcade	0 (subconscious)	255	8.43
Row	0 (hidden)	409	15.00

Notes:

If yous are working in Page Layout view (View tab, Workbook Views group, Page Layout push), y'all can specify a column width or row height in inches, centimeters and millimeters. The measurement unit is in inches by default. Become to File > Options > Advanced > Brandish > select an option from the Ruler Units listing. If y'all switch to Normal view, and so column widths and row heights volition be displayed in points.
Individual rows and columns can simply accept one setting. For case, a single column can have a 25 bespeak width, only it tin can't be 25 points wide for one row, and 10 points for some other.

Set a cavalcade to a specific width

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

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

Select the column or columns that y'all want to change.
On the Dwelling house tab, in the Cells group, click Format.
Nether Cell Size, click AutoFit Column Width.

Note:To rapidly autofit all columns on the worksheet, click the Select All button, and then double-click any boundary between two column headings.

Select All button

Select a 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.
Right-click a cell in the target cavalcade, bespeak to Paste Special, and then click the Keep 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 prison cell. Y'all tin specify a unlike number for the default column width for a worksheet or workbook.

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

Practise 1 of the following:

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

Select the row or rows that you lot want to modify.
On the Dwelling tab, in the Cells group, click Format.
Under Cell Size, click Row Acme.
In the Row height box, blazon the value that you want, and so click OK.

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

Tip:To quickly 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

Exercise one of the following:

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

Top of Page

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

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

Set a cavalcade to a specific width

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

Select the column or columns that you want to change.
On the Dwelling tab, in the Cells group, click Format.
Under 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 betwixt two column headings.

Select All button

Select a cell in the cavalcade that has the width that yous want to use.
On the Abode tab, in the Clipboard grouping, click Copy, and and then select the target column.
On the Home tab, in the Clipboard group, click the arrow beneath Paste, 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 cell. You lot tin can specify a different number for the default cavalcade width for a worksheet or workbook.

Exercise i of the following:
- To alter the default cavalcade width for a worksheet, click its sheet tab.
- To change the default column width for the entire workbook, right-click a sheet tab, and and then click Select All Sheets on the shortcut menu.
On the Domicile tab, in the Cells group, click Format.
Under Jail cell Size, click Default Width.
In the Default cavalcade width box, type a new measurement.

Tip If you lot want to define the default column width for all new workbooks and worksheets, y'all can create a workbook template or a worksheet template, and then base new workbooks or worksheets on those templates. For more information, meet Salve a workbook or worksheet as a template.

Do one of the following:

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

Select the row or rows that you want to change.
On the Habitation tab, in the Cells group, click Format.
Under Jail cell Size, click Row Height.
In the Row top box, type the value that you lot want.

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

Tip To quickly autofit all rows on the worksheet, click the Select All push and and then double-click the boundary beneath ane of the row headings.

Select All button

Do one of the following:

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