A number of features in the robust and popular online spreadsheet program Google Sheets make it easy to organize and analyze data. We can change the row heights when working on the Sheets document in order to make the data aligned and improve readability. Understanding how to modify row height effectively can improve the workflow, whether you’re working on a financial report, project management sheet, or any other data-driven document.
This post will demonstrate the method of changing the row heights in Google Sheets step-by-step with examples.
What is meant by Change in Row Height in Google Sheets?
The vertical measurement of a row within a spreadsheet is referred to as row height in Google Sheets. There are cells in each row where you can enter and modify data. The vertical space allotted to display the content in such cells depends on the row height.
In Google Sheets, the default row height is predetermined at a certain height, which might not always be ideal for displaying all kinds of data. To make sure the content is completely visible and readable, the row height must be adjusted when rows feature a lot of text or taller items like photographs or merged cells.
The readability of the spreadsheet and the presentation of the sheet can be improved by adjusting the row height.
How to Change Row Height in Google Sheets?
To change the height of rows in Google Sheets, we will consider an example of Google Sheets:
In the above figure, it can be seen that the data is not visible due to size compatibility with the row height. Now we can set the data by changing the height of rows by following the steps mentioned below.
Step 1: Select the Rows
Select all those rows whose height is supposed to be changed. To select the row, click on the first row of the sheet, then press the CTRL key and drag the mouse cursor to the last row of the sheet:
Now we can change the height of selected rows in Google Sheets.
Step 2: Change the Height of the Rows in Google Sheets
Now there are two different methods of changing the height of selected rows in Google Sheets.
Method 1: Change the Height of the Rows in Google Sheets by using the Mouse
The easiest method is changing the rows’ height by using the mouse cursor. With the help of the mouse, you can change the height by changing it:
Drag it up or down to change the row height:
The height of the rows has been changed in Google Sheets. You can also double-click on the alignment icon to change the rows with reference to the data in it.
Method 2: Change the Row Height in Google Sheets by using the “Resize” Option
Another method for changing the row height by selecting the rows is to right-click on the selected rows and then click on “Resize rows 1-5”:
A new dialog box will appear, either choose the “Specify row height” and specify the height to which you want to change it. Or select “Fit to data”, in it the rows will automatically adjust their height with respect to the data in it. We will use the “Fit to data” and then click on “OK”:
The row’s height is set with respect to the data in it:
By the above two methods, we can change the height of rows in Google Sheets.
To change the row height in Google Sheets, first select the rows then set the height of the rows by dragging the alignment icon up or down. Or choose the “Resize rows” from the dropdown menu by right-clicking on the selected rows. In this blog, two different methods are explained in detail to change the height of the rows in Google Sheets.