How To Change the Google Sheets Row Height (Easy 2023 Guide)

Sumit

Last updated September 15, 2023

There are many reasons why you need to adjust the Google Sheets row height, such as making the cells bigger to accommodate more data.

Whether you want to increase or decrease the Google Sheets row height, the steps will remain the same.

In this tutorial, I will show you several easy methods to do this. They are all super quick and easy to grasp, allowing you to choose how you want your data to be laid out.

All the methods will change the Google Sheets row height and also work if you need to change the width of the columns.

So let’s get started.

Table of Contents

How To Change Google Sheets 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.

Below are the steps to do this:

Place the cursor below the rows that you want to change the height of (as shown in the image below)
Click the left button on your mouse
Hold the left mouse button and drag it down
Release the button when you have the required row height

In this example, I have selected just one row, but you can also use the same method for 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 reasons you may want to resize the Google Sheets row height is when you have more text in the cell. Therefore, you cannot fully see all the content.

By increasing the row height, you will make the entire text visible. But how do you know how much you should increase the row size to?

If there are only a couple of rows, you can consider doing this manually. But if there are hundreds, you can use the two methods shown below.

Autofit Using Double-Click (Shortcut)

If you have the data set below and you want to autofit the Google Sheets row height — this will increase it just enough to accommodate the text in all of the rows.

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

Select the rows that you want to auto-fit the row height
Bring your cursor to the bottom edge of the selected rows (Note: The cursor will change to a double-pointed arrow).
Double-click your mouse (left mouse button)

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

Note: This doesn’t make all the rows the same size. Rather, it will change the row height to fit the content in it, so that nothing is hidden and you can see the complete text in the cell.

Additionally, this method will also reduce the Google Sheets row height if there is an excess of space due to less content in the cell.

Fit to Size Using the Dialog Box

You can also use auto-fit to adjust the Google Sheets row height using the built-in dialog box functionality in Google Sheets.

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

Select the rows that you want to adjust the row height
Right-click on the selected rows
Click the “Resize rows” option
In the “Resize rows” dialog box, select the “Fit to data” option
Click “OK” to confirm your changes

The above steps will resize the Google Sheets row height based on the content in the cell. This may increase or decrease the Google Sheets row height according to the content in the cells.

Related reading: 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 them 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 Google Sheets row height is 21 pixels.

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

Select the rows that you want to adjust the row height to
Right-click on the selected rows
Click the “Resize rows” option
In the “Resize rows” dialog box, select the “Specify row height” option
Enter the row height you want
Click “OK” to confirm

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

Wrapping Up

And there you have it! We have just walked you through four easy methods to adjust your Google Sheets row height, making your cells bigger so they can accommodate more data.

If you want to learn more about Google Sheets formatting, then check out our related articles below. Alternatively, you can sign up for this Google Sheets Masterclass to hone your skills and discover some expert secrets!

I hope you found this Google Sheets tutorial useful!

Related Google Sheets tutorials: