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.
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:
- How To Indent Text in Google Sheets
- How To Lock Cells in Google Sheets
- How To Delete Empty Rows in Google Sheets
- How To Wrap Text In Google Sheets
- How To Transpose Data in Google Sheets
- How To Zoom-In and Zoom-Out in Google Sheets
- How To Color Alternate Rows In Google Sheets
- How To Insert Multiple Rows in Google Sheets
- Google Sheets Limitations
- How To Group Rows in Google Sheets
