Arrow left
Back to product guides
Google Sheets Tips

How to Resize Row Height in Google Sheets

In this article, you will learn how to change row height in Google Sheets. Changing row height helps you make your table or list look beautiful, organized, and straightforward. There are a few ways to adjust row height, so you need to select the most suitable method for your purpose.

How to adjust row height in Google Sheets

Using a mouse cursor

  1. Put your mouse cursor between the row index of a row whose height you want to adjust and that of another row right below the row.
  2. When you see the “↕” mark, click there, drag it until full cell content shows up, and release it.
  3. The size of the row is changed.
How to change row height with your mouse cursor in Google Sheets

This method is effective when you want to change a row height. If you need to modify more than a few rows’ sizes, we recommend you take one of the following approaches.

Using a mouse cursor and a double-click

  1. Select the row indexes whose size you want to adjust.
  2. Put your mouse cursor between one of two adjacent indexes in the selected range.
  3. When you see the “↕” mark, double-click the mark.
  4. The sizes of the rows in the range are automatically adjusted to show their content fully.
How to change the sizes of multiple rows simultaneously in Google Sheets

This method is better than the first one in that you can adjust multiple rows at the same time. As this option makes the row size fit values in cells, some row sizes shrink depending on their data volume. There is another way to get the same effect, described below. As a result, you may see the various sizes of cells on your worksheet, though the values in cells can be visible clearly.

Using a row height menu - 1

  1. Select the row indexes whose size you want to adjust.
  2. Right-click on the chosen range.
  3. Select “Resize rows X-Y”, which brings up a pop-up. (The example below says, “Resize rows 2-6. This is the same for another following example.)
  4. Choose “Fit to data” in the pop-up.
  5. The sizes of the selected rows are adjusted to show their values completely.
How to modify row height by right-clicking in Google Sheets

What a pop-up for the row height adjustment menu looks like in Google Sheets

Using a row height menu - 2

  1. Select the row indexes whose size you want to adjust.
  2. Right-click on the chosen range.
  3. Select “Resize rows X-Y”, which brings up a pop-up.
  4. Choose “Specify row height” and input a specific row size in the pop-up (on a pixel basis).
  5. Click the “OK” button.
What a pop-up for the row height adjustment menu looks like in Google Sheets

We introduced four ways to resize row height. Again, it is important to pick up the most suitable options for your purpose (e.g., getting values in all cells completely visible or setting the same row height for all rows).

How do you autofit column width in Google Sheets?

Check this article to learn how to resize column width in Google Sheets.

Is there another way to show a value in a cell properly?

You can consider wrapping text. Check this article to learn how to use it.

Analyze your live financial data in a snap

Are you learning this tip to build a financial KPI dashboard or conduct financial analysis? If so, LiveFlow may help you to automate manual workflows and keep numbers updated in real time. For instance, you can easily compare your Budget versus Actual without any manual work. Furthermore, you can access other templates here, from the simple Income Statement and Operational KPI templates to Multi-Currency Consolidated Income Statement, Balance Sheet, and Cash Flow templates. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at: founders@liveflow.io
Check Icon
Call us at +1 (415) 650-1711