How To Change Row Height In Google Sheets

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:

Step 1

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.

Step 2

Right click on the rows and select Resize Row

Step 3

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.

Step 4

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

Summary

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.