How to Change Row Height in Google Sheets (Quick & Easy)

There are many cases when you may want to change the row height in Google Sheets (in order to make cells bigger and accommodate more data).

Whether you want to increase or decrease the row height, the steps would remain the same.

In this tutorial, I will show you various ways to do this. All these are super quick and easy ways, and the method you choose will depend on how your data is laid out.

All the method mentioned here to change the height of rows will also work when you want to change the width of the columns.

So let’s get started.

Change Row Height with a Mouse Click and Drag

If you want to change the height of one row or a few adjacent rows, this is a quick way of doing this.

Suppose you have a data set as shown below and you want to increase the height of the second row.

Increase row height of the second row

 

Below are the steps to do this:

  1. Place the cursor in below the rows for which you want to change the height (as shown in the image below).Place the cursor in between rows for which you want to change the height
  2. Click the left button on the mouse
  3. Hold the left mouse button and drag it down
  4. Leave the button when you have achieved the required height

Changing row height using a mouse

In this example, I have selected just one row, but you can also do the same with multiple rows. when you select multiple rows, no matter what their current height is, they all will have the same height once you’re done.

Auto-fit Row Height

One of the major reason you may want to resize the row height is when you have more text in the cell (which is on the second or third line in the same cell) and it’s not visible.

By increasing the row height, you will make the entire text visible.

But how do you know how much to increase the row size? If there only a couple of rows, you can consider doing this manually. But if there are hundreds, you can use the two methods shown in this section.

Autofit using Double-Click (Shortcut)

Suppose you have the data set below and you want to autofit the row height – which is to increase it just enough to accommodate text in all rows.

Below are the steps to auto-fit row height with a simple double click:

  1. Select the rows for which you want to auto-fit the row height
  2. Bring your cursor to the bottom edge of any of the selected rows (note that the cursor will change to a double-pointed arrow)
  3. Double-click (left mouse button).

Change row height with double-click in Google Sheets

The above steps would auto-fit the height of all the selected rows.

Note that this doesn’t make all the rows of the same size. It changes the row height to fit the content in it (so that nothing is hidden).

Also, this would reduce the row height in case there is more space and the content needs less.

Fit to Size Using Dialog Box

You can also auto-fit the row height using the inbuilt dialog box functionality in Google Sheets.

Below are the steps to autofit row size in Google Sheets:

  1. Select all the rows for which you want to adjust the row height
  2. Right-click on any of the selected rows
  3. Click the ‘Resize rows’ optionResize Rows Option in Google Sheets
  4. In the Resize rows dialog box, select the ‘Fit to data’ optionSelect the Fit to Data Option in Google Sheets
  5. Click OK

The above steps would resize the row height based on the content in it. This may lead to Google Sheets increasing/decreasing the row height based on the content in the cells.

Also read: How to Autofit Column Width in Google Sheets

Resize the Row by Specifying the Height (in Pixels)

In some cases, you may want to make the row height consistent.

This is often the case when you have more content in the cells but you don’t want to make it all visible. Instead, you want to have some of it visible and make the row height consistent.

This can be done by specifying the row height in pixels (the default row height on my system is 21 pixels)

Below are the steps to set the height of the rows in Google Sheets:

  1. Select all the rows for which you want to adjust the row height
  2. Right-click on any of the selected rows
  3. Click the ‘Resize rows’ optionResize Rows Option in Google Sheets
  4. In the Resize rows dialog box, select the ‘Specify row height’ option
  5. Enter the row height you wantSpecify row Height Manually
  6. Click OK.

This will make all the selected rows of the same height.

So these are the ways you can change the row height in Google Sheets (which will make cells bigger and accommodate more data).

I hope you found this Google Sheets tutorial useful!

You may also like the following Google Sheets tutorials:

Most Popular Posts

Sumit

Sumit

Sumit is a Google Sheets and Microsoft Excel Expert. He provides spreadsheet training to corporates and has been awarded the prestigious Excel MVP award by Microsoft for his contributions in sharing his Excel knowledge and helping people.