December 4, 2020

How to change cell size in Google Sheet

In this lesson we will learn how to change the cell size in Google Sheet.

By mentioning the cell size here to be more specific we are meaning the row and column size. Let’s clarify it with a simple example as follows.

Let’s say we have the below table in a Google sheet.

Now if we want to increase or decrease the length of each column we can do that by dragging the right border of the column to right or left respectively as follows.

In this process we can increase or decrease the size of multiple columns together. Like below we have selected the first two columns and then dragged the right border of the second column to right and the size for both columns have been increased.

In the same way if we would like to increase or decrease the height of any particular row we need to drag the lower border of the row down or up respectively as follows.

But there are more ways to change the row or column size. Like let’s say we want to set a specific size for the first two columns in our table.

To do that first select the first two columns and then right click on the column letter.

Then choose option ‘Resize Columns’.

Now in the below pop up select the option “Enter new column width in pixels” and enter the column width you would like to set for each of the selected columns. Here we have added 200 as new column width. Now click OK.

You can see below, first two column sizes in our table have been increased accordingly.

In the same way you can change the row size as follows. Here we have selected the last six rows and then right click on the row number and choose the ‘Resize rows’  option.

Now in the below pop up select the option “Specify Row Height” and enter the row height you want to set. This will be applicable for each of the selected rows. Here we have added 50 as the new row height. Now click OK.

As you can see below the last six row heights have been increased accordingly.

In both pop up for resize rows or resize columns there is an option as “Fit to data”. If you select this option and click OK in the pop up the row or column sizes will be adjusted according to the data size in it. As below we have selected this option for all rows in our table.

See below the row size in our table after applying the above change.

The same we have done for all columns in our table.

Below is the table with the column size fit to data.

Leave a Reply

Your email address will not be published. Required fields are marked *