How To Change Row Height In Google Sheets
Google Sheets automatically selects heights for each row based on the data in that row, but sometimes the automatically assigned height isn’t right for a given spreadsheet.
For example, you might want to create a spreadsheet with blank cells but ensure that the layout of the spreadsheet doesn’t change when data is added to those cells, or you might want to display only the first row of data in cells with multiple rows of data.
To manually set the height of rows in Google Sheets, follow these steps:
Highlight the row or rows you want to select.
To highlight multiple rows, hold down Ctrl on Windows or Command on Mac while you select the rows.
Right click on the rows and select Resize Row
In the dialog that appears, type in the new row height.
Heights are set in pixels with the default being 21 pixels. You can also choose the Fit To Data option to let Google Sheets select a row height based on the data currently in that row.
Click OK when you’re done to resize the rows
Note that if you resize the row to be smaller than the data in the row, any data that doesn’t fit in the new row height will be hidden but remain in the cell.
You can see this data by selecting the cell and looking in the formula bar
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to change row height in Google Sheets. Want more? Check out all the Google Sheets Tutorials.
Get more Google Sheets stuff
Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.
Thank you for subscribing.
Something went wrong.