Last Updated on October 30, 2023 by Jake Sheridan
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.
More ways to use rows in Google Sheets:
- Move A Row
- Delete Empty Rows
- Group Rows
- Number Rows
- Make A Row Float
- How Many Rows Can Google Sheets Handle?
- Add A Row
- Highlight A Row
- Insert Multiple Rows
- Delete Every Other Row
- Delete Rows
- Alternate Row Colors
- Highlight Row Based On Cell
- Select Multiple Rows
- Sum A Row
- Sort Rows
- Resize Rows
- Merge Rows
- Remove Duplicate Rows
- Switch Rows
- Select Every Other Row
- Duplicate Rows