Skip to content

Tricks to Set Row Height and Column Width in Excel

Autofit Contents in a Column Width

There are several ways to set the row height and the column width in Excel. By default, the size of a Row Height is 15.00 points, whereas the Column Width is 8.43 points.

However, we can expand the maximum height of a row to 409 points, whereas the maximum width of the column is 255 Points.

Set Row Height and Column Width in Excel

1. Autofit Contents in a Row and a Column:

Enter the content you want to fit in the Row Height or Column width fields.

To Autofit content in a column width or all the column widths in Excel, select the column(s) or click the Select All Button.

Then double-click using the boundary (Any Vertical Gridline of the Column Heading) of any Column heading, as shown in the picture below.

Autofit Contents in a Column Width
Autofit Contents in a Column Width
Autofit Contents in a Column Width124
Autofit Contents in a Column Width

To Autofit content in a row height or all the row Heights in Excel, select the column(s) or click the Select All Button.

Then double-click using the boundary (Any Vertical Gridline of the Row Heading) of any Row heading, as shown in the picture below.

Changing the Row Height and Column Width​
Change Row Height and Column Width in Excel​
Changing the Row Height and Column Width​ in excel
Autofit Contents in a Row Height in MS-Word

2. Change Row Height or Column Width:

To change all the Column widths in Excel, click the Select All Button as shown in the Picture below

And then drag left or right using the boundary (the vertical gridline of any Column Heading) of any Column heading, as shown in the picture below.

Change All the Column Width (1)
Change All the Column widths.

To change all the Row Height in Excel, click the Select All Button as shown in the Picture below

And then drag up or down using the boundary (Horizontal Gridline of any Row Heading) of any Row Heading as shown in the picture below.

Set the default width of the columns in excel
Change All the Row Width

3. Set the Exact Row Height:

Make sure the cell or Row/s selection that you want to increase or decrease

On the Home tab, in the Cells group, Click on the Format

Select the “Row Height” under the “Cell Size” to get a dialogue box to enter the exact value to increase or decrease the Row Height.

Then click Ok.

If you want to autofit the Row Height to the default size, click “Autofit Row Height”.

Set the Exact Row Height in Excel​
Set the Exact Row Height in Excel​

4. Set the Exact Column Width:

Make sure the cell/s or Column/s selection that you want to increase or decrease

On the Home tab, in the Cells group, Click on the Format

Select the “Column Width” under the “Cell Size” to get a dialogue box to enter the exact value to increase or decrease the Column Width.

Then click Ok.

If you want to autofit the Column Width to the default size, click the “Autofit Column Width”.

Set the Exact Column Width in excel
Set the Exact Column Width

5. Set the Default Column Width:

Make sure the cell/s or Column/s selection that you want to increase or decrease

On the Home tab, in the Cells group, Click on the Format

Select the “Default Width” under the “Cell Size” to get a dialogue box to enter the exact value that you want to set as a default Column Width.

Set the default width of the columns in excel
Set the default width of the columns in Excel

What are the row height and column width points in Excel?

By default, the size of a Row Height is 15.00 points whereas the column Width is 8.43 points. However, we can expand the maximum height of a row is 409 Points whereas the maximum width of the column is 255 Points.

How can I adjust the row height in Excel?

To adjust row height, select the row(s), right-click, choose “Row Height,” and enter the desired value.

What’s the quickest way to change column width in Excel?

Double-click the right edge of the column header or use the Format Cells dialog (Ctrl+1) > “Alignment” tab > “Column Width.

How can I set the same row height or column width for multiple rows/columns?

Select the rows/columns, right-click, choose “Row Height” or “Column Width,” set values, and click “OK.

What’s the purpose of hiding rows or columns in Excel?

Hiding is useful for focusing on specific data and can be done by right-clicking and selecting “Hide” or using the “Format” > “Hide & Unhide” menu.