Place your pointer to the border between two rows. When it turns blue, drag it until you get the desired row height.
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.
Step 3: The Resize row box will appear. Select Specify row height, then enter a specific row height value in pixels. Click OK.
You have now changed the row height:
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.
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:
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.
Enter Your Email Below to Try Lido for FREE!
Experience all of the benefits of the classic spreadsheet with much more powerful features that save users time!
One Click Data Imports From Anywhere
Transform Spreadsheets into Software in Seconds
Pre-built & Custom Templates
Visualize Real-Time Data in Centralized Dashboards
Thanks for Signing Up - Please Check your Email to Verify your Account
Oops! Something went wrong while submitting the form.