How to Autofit Column Width and Row Height

  • Post author:
  • Post category:Uncategorized

We can autofit column width in Excel and autofit row height by following simple steps. This tutorial will walk all levels of excel users on the procedure to autofit column width and row height.

Figure 1 – How to autofit in Excel

How to Autofit Column Width

We can autofit column width in several ways.

Setting a Column to a precise Width

  • To set a column to a specific width, we will highlight any cell in the column whose width we want to change. We will highlight Cell B3

Figure 2 – Excel autofit

  • We will click Format in the Cell group

Figure 3 – Click Format

  • We will click Column Width and set the width we want

Figure 4 – Excel autofit

  • We will click OK

Figure 5 – Autofit columns in Excel

Setting a Column to fit the cell content (Autofit)

We will follow the previous procedure. When we click Format, we will select Autofit Column Width.

Figure 6 – Click Format

Autofit Column Width with the Mouse

We can use our mouse to autofit column width. We will take our cursor to the line separating one column from the other, e.g., the line separating Column B and Column C.

Figure 7 – Excel auto adjust column width

  • We will double click on the line

Figure 8 – Autofit in Excel

How to Autofit Row Height

We can autofit row height in different ways.

Setting a Row to a specific Height

  • To set a row to a specific height, we will highlight any cell in the row whose height we want to change. We will highlight Cell A3

Figure 9 – How to autofit rows in Excel

  • We will click Format in the Cell group

Figure 10 – Click Format

  • We will click Row Height and set the height we want

Figure 11 – How to autosize rows in Excel

  • We will click OK

Figure 12 – Excel autofit row height

Note

We can autofit the row height and the column width of the entire sheet by pressing Ctrl A to select the whole sheet. We will then go to the line demarcating any row or column and double click on it. This will cause all the content to autofit the rows and columns.