How to Update Row Height in Excel

Adjusting your row height is a common task that you will have to do when working on your data. It is dependent on the amount and nature of data entry. Microsoft Excel has cells in neatly divided rows and columns. You can use different ways

Changing the Row Height using the Click and Drag method

Follow the following simple steps.

1. Position the cursor at the bottom edge of the row header that you want to adjust the height. The cursor changes into a plus sign.

2. Press the left mouse key.

3. while pressing the left mouse key, drag it down to increase the row height or drag it up to reduce the row height.

4. Release the mouse key once your required height is reached.

It is considered the easiest way to change the height of the rows in Excel, especially when you have to do it for a small number of rows and columns. The only problem is that the above method hardly gives consistent results when changing row height. Some rows may turn out to be bigger or smaller than others.

Using the Mouse Double Click method

Follow the following simple steps.

1. Position the cursor at the bottom edge of the row that you want to adjust the height—the cursor changes to a plus sign.


2. Double click the left mouse key

3. Release the left mouse key once done

It automatically adjusts the row's height and ensures the space fits the data to be entered. The method is considered the fastest method, which adjusts the row height so that data fits within the cell.

Manually Adjusting the Row Height

If you have a data set, you can adjust the row height as shown below.

1. Click and drag the row headers to select them. You can also select the cells in the columns for the rows that you want to adjust the height.

2. Go to the Home Tab and choose the Cells group. Click on the Format option.

3. Click on Row Height Option

4. Enter the height you want for each row you have selected in this box.

5. Click OK

Keyboard Shortcut Method

Follow the following simple steps.

1. Select the cells in the row whose height you want to adjust.

2. Press on Alt +H +O +H

3. Enter the height you want for your row in the box that appears.

4. Press OK

This method does not require you to change the row height of your keyboard.

Autofit Rows Method

Follow the simple steps below to use autofit to increase the height of the rows in Excel.

1. Select the rows in your worksheet that you want to autofit.

2. Go to the Home tab; choose the Cells groups, and Click on the Format Option.

3. Choose the Autofil Row, the Height option.


4. Press OK

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: