What is the default row height in Excel

In many cases, we need to change the default row height in Excel. Again, we may need to recover the previous default row height. In this article, Ill discuss the basics of default

What is the default row height in Excel

In many cases, we need to change the default row height in Excel. Again, we may need to recover the previous default row height. In this article, Ill discuss the basics of default row height in Excel as well as the way of changing and recovering it with proper explanation.


Table of Contents hideDownload Practice WorkbookWhat is Default Row Height in Excel?Methods of Changing & Restoring Excel Default Row Height1. Changing Default Row Height1.1. Changing Default Row Height by Altering the Font Size1.2. Changing Default Row Height Using the Row Height Option2. Making the Default Row Height Locked3. What If the Default Row Height is Zero4. Recovering Default Height of Row4.1. Using the Row Height Option4.2. Recovering Default Row Height Using VBAConclusion

Download Practice Workbook

Methods of Default Row Height.xlsm


What is Default Row Height in Excel?

While using Excel 365, I found the default row height is 15 when the font is Calibri and the font size is 11. Though it may vary because it largely depends on DPI (dots per inch) scaling.

In fact, the row height is dependent on the font size. So, the row height will change on the basis of enlarging or shrinking the font size.

Look closely at the following screenshot which depicts the default row height if the font size is 11.

Excel Default Row Height

Methods of Changing & Restoring Excel Default Row Height

Lets see how you can change the default row height and also recover that efficiently.


1. Changing Default Row Height

You may have a dataset where wrapping text and expanding the row height is necessary for every worksheet. In such a situation, changing the row height for all worksheets will be a tedious task.

How would you feel if you could change the default row height?

Unfortunately, there is no specific tool for changing the default size within a second.

However, we can utilize two certain methods to change the default row height.


1.1. Changing Default Row Height by Altering the Font Size

Surely, we can assign a particular row height for the whole workbook. Before doing that lets have a look at the following table.FontFont SizeDefault Row HeightPixelsCalibri1012.7517Calibri1115.0020Calibri1519.5026

Now, lets change the default row height. The row height starts at 0 and ends at 409. Moreover, the value of the row height is not an integer value. Because every pixel increases 0.75 to the row height.

Go to File > Options.

Then change the font size based on your required row height. You may go through the above table again to determine the font size. As I want to get the row height is 20 (actually 19.50), I fix the size 15 as shown in the below figure.

Changing Excel Default Row Height

If you do that, you will see the following command from Excel. That means you need to restart Excel.

Changing Excel Default Row Height

When you open a new worksheet, youll find that the row height is 19.50.

Changing Excel Default Row Height

From now, the changed default row height of Excel will work whatever the number of worksheets or workbooks.


1.2. Changing Default Row Height Using the Row Height Option

If you want to change the default row height quickly, you may use the following simple method.

Firstly select the entire worksheet or dataset (the keyboard shortcut is CTRL + A). When you select any cell of your dataset and press the shortcut, the whole dataset will be selected. Likewise, you can select the entire worksheet by selecting a blank cell within the worksheet.

Next, click on the Format option from the Cells ribbon in the Home tab.

Then choose the Row Height option from the Format option.

Changing Excel Default Row Height

Alternatively, after selecting the worksheet or dataset, right-click and choose the Row Height option.

Changing Excel Default Row Height

Now fix the row height as 20.

Changing Excel Default Row Height

Immediately, youll get the following output where the row height is 19.50 because the value of row height will be either 20.25 or 19.50.

Now, you may save the worksheet as an Excel template and use them frequently with the default row height.

Changing Excel Default Row Height

More importantly, if you want to explore further methods to change the row height, you may visit the How to Change the Row Height article.


2. Making the Default Row Height Locked

Furthermore, if you want to lock the default row height so that anyone ever you yourself cannot resize the row height before unlocking the worksheet. Lets see the process.

In the first place, select the whole dataset and right-click and choose the Format Cells option.

Lock the Height

Go to the Protection tab and check the box before the Locked option.

Lock the Height

Subsequently, click on the Protect Sheet from the Review tab.

Protect Sheet

Meanwhile, youll see the following dialog box and check the box before the Format Cells, and press OK.

Protect Sheet

Now, the row height of your worksheet is protected and you cannot change the row height.

For example, if you right-click on the row number, youll see the Row Height option is not working.

Protect Sheet

3. What If the Default Row Height is Zero

Lets explore an interesting thing.

Sometimes, you might see the following worksheet, especially if you download any workbook, where no data is seen.

It is because the default row height of the sheet is 0.

If the Row Height is Zero

Whatever, you can solve the problem using the Row Height option in the following way.

Firstly, pick the Row Height option from the Format option

If the Row Height is Zero

Secondly, input the desired value of row height in the blank space after the Row Height:

If the Row Height is Zero

Then the dataset will be seen as illustrated in the following picture.

If the Row Height is Zero

4. Recovering Default Height of Row

Assuming that you have a dataset where the row height is different and you need to restore the default row height. So, we can restore the default row height in two ways.

Recovering Height of Row

4.1. Using the Row Height Option

Though the usage of the Row Height option is discussed earlier. For your convenience, I am showing the usage again.

Just select the dataset.

Click on the Row Height option from the Format option.

Recovering Height of Row

Now, input the row height as 15 and press OK. This way, you can recover the default row height.

Recovering Height of Row

4.2. Recovering Default Row Height Using VBA

More importantly, you may use the VBA code to recover the default row height.

Firstly, open a module by clicking Developer > Visual Basic.

How to Insert VBA Code

Secondly, go to Insert > Module.

How to Insert VBA Code

Then copy the following code into the newly created module.Sub Recovering_Default_Row_Height() Dim hRow As Worksheet Set hRow = Worksheets("Recovering_VBA") With hRow .Cells.UseStandardHeight = True End With End Sub

Recovering Excel Default Row Height Using VBA

In the above code, I declared hRow as Worksheet and assigned the Worksheets function to indicate the working sheet (the name of the sheet is Recovering_VBA) where I want to recover the default row height. Later, I used Cells.UseStandardHeight to restore the default row height as the UseStandardHeight returns True when the row height becomes equal to the default row height.

Next, run the code (the keyboard shortcut is F5 or Fn + F5), youll get the following output.

Recovering Excel Default Row Height Using VBA

Conclusion

In short, you may change the default row height and also restore the height easily using the above methods. Hence, I hope that the article might be highly beneficial for you. However, if you have any queries and suggestions, share them below in the comments section.

Video liên quan