Skip to content

Tricks to Set Row Height and Column Width in Excel

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 is 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

To Autofit content in a column width or all the columns width 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 rows 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 Width in Excel, click the Select All Button as shown in the Picture below

And then drag left or right using the boundary (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 Width

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.

Share