How to Change Row Height in Google Sheets

Use these steps to change the row height in Google Sheets.

  1. Open your Sheets file from Google Drive.

    Visit https://drive.google.com to view your Sheets files.

  2. Select the row number at the left side of the spreadsheet.

  3. Right-click on the selected row, then choose the “Resize row” option.

  4. Click the “Specify row height” option, then enter the desired size.

    The row height is in pixels, so you may need to try a couple of different options until you get the correct size.

  5. Click the “OK” button to change the row height.

The default row height in Google Sheets is ideal for data that is in the default font size, and only takes up one row in the cell. But if you have found that the current row size is either too big or too small, then you might decide that you need to adjust the size of the row to make it look better.

Fortunately you can change the row height in Google Sheets to make it accommodate your data needs. Our tutorial below will show you how to select a row and enter a new row height value for it.

How to Make a Row Bigger or Smaller in Google Sheets

The steps in this article were performed in the desktop version of Google Chrome, but will also work in other desktop Web browsers as well. Once you have completed this guide you will have adjusted the height of a row in your Google Sheets spreadsheet to a new size that you specify.

Step 1: Sign into your Google Drive account and open the Sheets file containing the row that you wish to resize.

Step 2: Click the row number of the row that you wish to make bigger or smaller. The row number is the gray rectangle at the left side of the spreadsheet. You can select multiple row numbers at once by holding down the Ctrl key on your keyboard and clicking each row number that you want to resize.

how make row bigger or smaller google sheets

Step 3: Right-click the selected row number, then choose the Resize row option. If you have selected multiple rows, then this option will say Resize selected rows instead.

how to resize row in google sheets

Step 4: Select the Specify row height option, delete the current value, then enter the new row height. Once you are done, click the OK button. Note that the default row height is 21 so, for example, if you wanted to make the row twice as tall as it is now, you would enter 42.

how to change row height in Google Sheets

Frequently Asked Questions

How do I change the row height in Google Docs?

Click and hold on the bottom border of the row, then drag it to the desired height. Note that the mouse cursor will switch to a horizontal line with an arrow above and below it when the cursor is in the correct location

How do I change the row height for multiple rows in Google Sheets?

Hold down the Ctrl key on your keyboard and click each row number to change. Right-click a selected row and choose the “Resize rows” option. Click the “Specify row height” button, enter the height for those rows, then click OK.

How do I change the row height in an Excel spreadsheet?

Right-click on the row number, then choose the “Row height” option. Enter the desired row height, then click OK.

How do you swap rows in Google Sheets?

Click and hold on the row number at the left side of the spreadsheet for the row that you want to move, then drag the row to the desired location.

Does your Google Sheets spreadsheet have a lot of rows that you don’t need, but you want to delete them more quickly than one at a time? Find out how to delete multiple rows at once in Google Sheets and quickly get rid of all of your unwanted rows.

See also

solveyourtech.com newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.