How to Change Cell Height and Width in Google Sheets

Adjusting cell height and width in Google Sheets enhances data presentation for tasks like chart creation or collaborative projects. In 2025, Google Sheets cloud-based features, paired with Google Apps Script for automation (similar to Excel VBA), make resizing cells critical for readability and organization.

How to Change Row Height in Google Sheets

Learn how to resize rows in Google Sheets to make your data fit better:

Step 1: Locate the Row

Find the row you want to resize. Hover over the border of the row header until an arrowhead icon appears.

Step 2: Drag the Arrowhead

Click and drag the arrowhead up or down to adjust the height. The row size will change accordingly.

In order to change the size of a cell vertically, you must follow these steps-

Step 1: Locate the row with the desired cell

Locate the row in which the cell whose size you want to change is present. Hover over to the border of the header of that row. You must see an arrowhead symbol.

Step 2: Drag the Arrowhead

When the cursor changes into an arrowhead, press and drag the arrowhead up or down. Note that you have to do this from the bottom side of the cell.

How to Adjust Column Width in Google Sheets

Follow these steps to resize columns in Google Sheets for better data presentation:

Step 1: Locate the Column

Find the column you want to adjust. Hover over the border of the column header until an arrowhead icon appears.

Step 2: Drag the Arrowhead

When the cursor changes into an arrowhead, press and drag the arrowhead up or down. Note that you have to do this from the right side of the cell.

Using Google Sheets Built-In Tools to Resize Cells

Learn how to use built-in tools to resize multiple cells at once.

Resize Cells by Changing the Height

Note that in order to make changes in the vertical dimension, we must change the height of the cells.

Step 1: Select the Desired rows

Locate and select the row/rows in which the cell whose size you want to change is present.

Note that in order to make such selections, you should use the Ctrl key(on Windows) or cmd key(on Mac) while selecting.

Step 2: Right click to Select Resize selected Rows Option

Right click the header of the last selected row and choose the Resize selected rows option.

Step 3: Set desired size

A box will open where you can set the desired size in pixels. When done, click ok.

This is how the sheet looks like after this-

Note that you can also use the fit to data option to automatically adjust the size of the cells as per the data, but this does not always work as desired.

Resize the cell Using Built in Tool by Changing the Width

Note that in order to make changes in the horizontal dimension, we must change the width of the cells.

Step 1: Select the Desired Columns

Locate and select the column/columns in which the cell whose size you want to change is present.

Note that in order to make such selections, you should use the Ctrl key(on Windows) or cmd key(on Mac) while selecting.

Step 2: Right Click and Select Resize Selected Columns Option

Right click the header of the last selected column and choose the resize selected columns option.

Step 3: Set Desired Size

A box will open where you can set the desired size in pixels. When done, click ok.

This is how the sheet looks like after this-

Note that you can also use the fit to data option to automatically adjust the size of the cells as per the data, but this does not always work as desired.

Resize the Cells using the Auto-Resize Feature of Google sheets

Google sheets also let you auto-resize the dimensions of a cell without having to worry about the exact size measures.

How to Auto-size a Column's Width in Google Sheets

Follow these steps to auto-resize a cell horizontally:

Step 1: Hover over the border of the column header

Hover over the right side border of the column header until you see an arrowhead.

Step 2: Double click

Once you see the arrowhead, just double click and the cell size will automatically increase to fit the content.

Note that this method does not work for the rows. You can look at the below sections for an alternative.

Methods to Change the Cell Size in Google Sheets to Fit the data

If you are reading this post, then it might be possible that you are struggling with fitting data in the cells of your Google sheet. If fitting the data in the cells is your main goal, then you can use the below given methods.

Note that these methods are an indirect way of changing the cell size based on the data.

Change the Cell Size in Google Sheets to fit the data using Wrap Text

If you have ever tried entering multiple values in a single cell using the Enter key, you would know that the content goes to a new cell. Here is an example-

This is the result we want to achieve-

But this is what happens when you use the Enter key-

You can see that this time the content is moved to three rows which was not what we wanted. Thus, we can use the Wrap Text option to fix this problem.

Step 1: Select the Desired Cells

Select all such cells whose data you want to fit. To make multiple selections, use the enter key(on Windows) or Cmd key(on Mac) while making selection.

Step 2: Use the Wrap Text Option

Go over to wrap text drop down in the ribbon and choose the wrap option present in the center.

This is how the cell data would automatically be adjusted-

How to Change the Cell Size in Excel to fit the data using Merge Cells

Until now, every time we have seen that changing the size of one cell alters the size of an entire column or row in which the cell is present.

Although you cannot change the size of a single cell, you can merge various cells in Google sheets to obtain a block that is differently sized than the rest of the cells.

Here is how to do this:

Step 1: Select a range of cells

Simply select a section of cells that you want to merge and make as one block.

Step 2: Use the merge cell option

Go over to the merge cells dropdown and choose the desired option.

We are using the merge all option here because we have made selections across both rows and columns.

This is what the cells look like now:

Note that in this post, we are using the merge all option but you can choose whatever you need.