How to Format Cell Size in Google Sheets

In this article, we will look at how we can format the cell size in Google Sheets with examples following some basic scenarios.

When you open a Google Sheets spreadsheet, you are presented with a clean and uniform grid of cells. If you have already worked with the application, you will know that there are multiple ways to change the cell sizes depending on the data, but also some restrictions.

So, the rest of the article will be dedicated to guiding you to give more control over these changes. Also answering some burning questions many users may have along the way.

Let’s get started.

How to Format Cell Size in Google Sheets

The first question that may come to mind is can you format individual cell sizes in Google Sheets?

The answer is no, you cannot resize individual cells.

You can only resize either the entire column or the row. Which in turn resizes all the cells in them.

But doing so is quite easy, and in most cases, necessary to organize how your worksheet will be presented.

1. Resize the Entire Row or Column in Google Sheets by Using the Cursor

To show the process, I have created the following dataset of full names for two teams participating in the local SoftBall Tournament:

sample dataset for how to format cell size in google sheets

In the image above we can see that some of the data that was input into the dataset have a length beyond the standard size of the cell.

This means that a lot of meaningful data has been lost this way.

So, to show these data, we must format the cell sizes. And in this case, the entire column size. Let’s see how to do this step by step:

Step 1: Move the cursor to the edge or border of the column number. In this case, we will move the cursor to the right edge of column A. Doing so, will change the cursor shape (two arrows pointing away from each other).

the mouse cursor changes shape when placed at the bother of the column number

Step 2: Click and drag the cursor as far as necessary to change the column width. It should be far enough to make the overflowing or hidden data visible.

format column cell size in google sheets using cursor animated

And that’s it!

We have successfully formatted the size of all the cells in column A in this worksheet. Now the hidden data are visible.

And as for changing the size/height of all the cells in a row, the process is quite similar:

Step 1: Bring the mouse cursor to the edge of the row. Preferably the bottom edge.

resize cursor for rows in google sheets

Step 2: Click and drag the cursor up or down to change the height of the cells in the row.

format row cell size in google sheets using cursor animated

Change the Sizes of Multiple Columns and Rows Uniformly in Google Sheets

It is also possible to format the size of multiple rows or columns together in Google Sheets.

The only extra step added to the previous method is the selection of the rows or columns.

Step 1: Select the column numbers to highlight the entire column.

  1. To select adjacent columns:
SHIFT+Click the column numbers

selecting adjacent columns

  1. To select non-adjacent columns:
CTRL+Click the column numbers

Step 2: Use the cursor to click and drag right or left to increase or decrease the size of the cells of the selected columns. You can select any of the edges of the selected columns.

formatting the size of multiple columns at once in google sheets animated

As you can see from the image above, all of the column widths have changed uniformly.

And the same method can be applied to rows as well.

Fit Cell Width Size Automatically

While clicking and dragging to update the cell size in Google Sheets gets the job done, it can be inefficient in regards to both time and space required for the cell to show all the data correctly.

Thankfully, Google Sheets provides its users with a feature that automatically adjusts the column size with the maximum width of the data that might be in it.

Simply double-click the edge of the column number that you want to format the size of in Google Sheets:

double clicking on the border automatically adjusts the size of the cell in google sheets animated

2. Format Cell Size Using Manual Input in Google Sheets

If you want to change the cell size to be pixel perfect in Google Sheets, this is the right section for you.

Each cell in Google Sheets has a default size for its width and height in pixels:

  • Cell Width: 100 px
  • Cell Height: 21 px

You can view and change this measurement by using the steps below:

1. To Change the Width of a Cell by Manually Inputting the Measurement

Step 1: Select the column number to highlight the entire column.

Step 2: Right-click over the selected cells to open the menu of options. Here, select the Resize column option.

the resize column option

This will open the Resize Column window.

Step 3: In this window, you can adjust the pixel value to the number you want (the default is 100). This will update the width of all the cells in the column.

the resize column window with default value in google sheets

For now, we will set the width to 200 px:

changing the size of the column with by pixels

You can also select the Fit to data option to allow Google Sheets to automatically set the width of the column according to the highest width of data in the column.

This is similar to the “double-clicking to fit size” method we’ve seen previously.

2. To Change the Height of a Cell by Manually Inputting the Measurement

Step 1: Select the row number to highlight the entire row.

Step 2: Right-click over the selected cells to open the menu of options. Here, select the Resize row option.

the resize row option in google sheets

Step 3: In this window, you can adjust the pixel value to the number you want (the default is 21). We will input 28 px in this case.

format the row cell size by manually inputting value in google sheets

Resize Multiple Rows or Columns

You can also apply this method for multiple columns or rows.

Simply select the columns or rows before right-clicking to open the menu. The Resize option will be slightly different since we have multiple selections:

the resize column option for multiple columns in google sheets

But the size input procedure is still the same in the Resize window:

even for multiple selections, the resize window is the same

Can you Change Cell Size Input Parameters (Pixels to Inches)?

No. There is no way (so far) to change the input type in Google Sheets.

So, the best idea is to perform a calculation to find the desired measurement in pixels.

For example, 96 Pixels = 1 Inch

Therefore, if we want to format the width of a cell by 3 inches, we only have to input 288 px (3*96) in the Resize Column window.

3. Merge Cells to Format Cell Size in Google Sheets

So far, any size formatting we’ve done affected the entire column or row.

But can we resize cells without affecting another?

While the simple answer is no, we can opt for a crude alternative. That is by merging different cells together to create a single cell of a different size.

Simply select the cells and navigate to the Merge cells icon in the toolbar:

the merge cell icon in the google sheets toolbar

The result is one giant cell created from the selected ones:

changing cell size by merging it with others

By default, we have 3 Merge options available in Google Sheets:

  1. Merge all
  2. Merge vertically
  3. Merge horizontally

the 3 merge options in google sheets

Here are the results of the merges when applied to four adjacent cells:

the results of using the three merge option

This method is best used when you have a dataset like the following image.

sample dataset where changing the column size affects different cells

Here, the title “2021 SOFTBALL TOURNAMENT” is overflowing in the cell that it is assigned.

If we are to change the size of the cell, the rest of the column with the names will be affected.

So, merging the title cell with the adjacent ones will do the trick:

merging cells to format cell size without affecting other cells in google sheets

Learn More: How to Merge Cells in Google Sheets (4 Ways)

Final Words

That concludes all the ways we can use to format a cell size in Google Sheets. All the methods involved use built-in features to make things much simpler.

Feel free to leave any queries or advice you may have in the comments section below.

Related Articles for Reading

Mehrab Imtiaz

Mehrab Imtiaz

Mehrab Imtiaz is a Technical Writer for officewheel.com specializing in everything Google Sheets. Mehrab has always had a profound passion for writing and with his experience with MS Excel and Google Sheets throughout his career, it seems to be a great match when it comes to dishing out tips and tutorials for all to enjoy.

We will be happy to hear your thoughts

Leave a reply

OfficeWheel
Logo