In this article:

How to Change Google Sheets Row Height

May 8, 2024

Method 1: Resize with Mouse-click and drag

Place your pointer to the border between two rows. When it turns blue, drag it until you get the desired row height.

Changing row height manually with mouse

Method 2: Use Dialog box

Specifying a specific value

You can specify a specific value for the Google Sheets row height using the Dialogue Box:

Step 1: Hover on the row number corresponding to the row height you want to adjust. 

Step 2: Right click, then select Resize row.

Right click row, then select Resize row option

Step 3: The Resize row box will appear. Select Specify row height, then enter a specific row height value in pixels. Click OK.

Resize row dialogue box

You have now changed the row height:

Adjusted row height
Dialogue Box GIF

Autofit to the content in the cell

Sometimes you do not have a clue for the exact row height that will enable you to see the entire contents of the cell. You can do so through the dialog box: in Step 3, instead of selecting Specify row height, select Fit to data.

Fit the data option selected in dialogue box
Using Fit to data option GIF

Method 3: Autofit with Mouse

There is a shortcut that you can use if you want row height to fit with the data in the selected cell. Here are the steps:

Step 1: Select the row numbers corresponding to the cells you want to adjust. 

Step 2: Hover your cursor to the border between two selected rows.

Step 3: Double click.

You can check the screencap below:

Autofit with mouse GIF

This shortcut, however, only works if the text wrapping of the selected cells are already set to Wrap but are adjusted to hide the next lines. If this shortcut doesn’t work, chances are the text wrapping is not set to Wrap, but you can use the other methods listed in this tutorial.

Other Ways to Change Cell Size

How to Make all Cells the Same Size in Google Sheets

Standardize your spreadsheet by making every cell the exact same size.

How to Make Cells Bigger in Google Sheets

Learn how to widen and/or lengthen cells to accommodate your data.

How to Change Cell Size in Google Sheets

Learn how to edit the cell size, making cells both smaller and bigger depending on your need.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->