How to change cell size in Google Sheets: 3 methods

When it comes to crunching heavy-duty numbers and interpreting Google Sheets data, I’m 99th on the list of the last 100 humans you should ever turn to for help. But if you need help making your spreadsheet pretty, I’m absolutely your guy. 

For example, if your spreadsheet is filled to the brim with illegible data—as in, you literally can’t see everything because your cells aren’t wide enough—here’s how to make cells bigger in Google Sheets. 

And before you ask: no, Gemini can’t resize your cells for you. You’d think Google’s own AI could handle a little cosmetic spreadsheet work, but for now, this one’s still on you.

Table of contents:

1. How to change cell size in Google Sheets using auto-expand

Here’s the quickest way to change cell sizes in Google Sheets to make them fit your text automatically (no hidden values).

1. Highlight the column(s) you want to resize in Google Sheets. 

2. Hover your cursor over the right-side border of the column letter until it switches to the double-arrow icon. Then double-click the border.

3. Google Sheets will automatically expand your cells to fit the longest value within a given column.

That’s it. Google Sheets automatically adjusts the cells so that they’re just wide or tall enough to fit the widest or tallest value within a given column or row.

2. How to change cell size in Google Sheets using manual drag

If you’re working with a large data set, the lack of negative space between cells that you get with the auto-expand feature makes it difficult to scan through the spreadsheet. In this case, I’d suggest manually resizing cells in Google Sheets instead.

1. Highlight the column or row you want to resize in Google Sheets. 

2. Click and drag the right-side border (for columns) or bottom border (for rows) to your desired width or height. 

If you use this technique to change the cell size for multiple columns or rows, Google Sheets will automatically expand all highlighted cells to be the same width or height. 

3. How to change cell size in Google Sheets using specific dimensions

Let’s say your spreadsheet contains duplicates of the same sheet, and you want to keep column and row sizes consistent across sheets. The best method to resize cells in Google Sheets while maintaining that consistency is by entering specific cell dimensions. In my opinion, that’s the only good reason for using this option.  

1. Highlight the column(s) or row(s) you want to resize. 

2. Right-click your selection, and select Resize columns [selected columns] or Resize rows [selected rows]. 

   

3. In the pop-up, enter a new column width or row height in pixels. If you want to make the columns larger than their default width, enter a value greater than 100; for rows, enter a value greater than 21. 

   

4. Click OK. 

5. If you’re applying the same cell size across multiple sheets, repeat the same process and enter the same widths and heights for each sheet. 

Automate Google Sheets with Zapier

If Google Sheets is your go-to app for storing data, use Zapier’s Google Sheets integration to connect it with thousands of other apps so you can build an intelligent, AI-powered data management system.

For example, you can automatically store customer feedback in Google Sheets, use AI to analyze trends in that data—like spotting common feature requests or product bugs—and escalate requests that meet pre-set criteria to the right teams in Slack. Learn more about how to automate Google Sheets, or get started with one of these workflow templates. 

How to change cell size in Google Sheets: FAQ 

When it comes to resizing cells in Google Sheets, there are a lot of things you’d think would be a no-brainer to do—like setting a permanent default cell size for all Google Sheets. Here are answers to common questions about changing cell size in Google Sheets. 

How do I change the default cell size in Google Sheets?

Google Sheets doesn’t let you set a permanent default cell size that carries over to every new spreadsheet. Your best workaround is to set up a spreadsheet with your preferred cell dimensions and save it as a template you can copy whenever you start a new project.

Can you lock cell size in Google Sheets? 

Sort of. There’s no one-click “lock cell size” button, but you can restrict who can edit cell ranges, which effectively does the same thing. Learn more in this Zapier guide on how to lock cells in Google Sheets.

How do I resize only certain cells in Google Sheets?

You can’t adjust the size of a single cell in Google Sheets—any changes you make to a cell’s dimensions apply to the entire row or column. So if you want one cell to be wider, every cell in that column gets wider too. If you really need a single cell to look bigger, you can merge multiple cells to create a larger block, but keep in mind that merging can get messy with your data.

How do I change all cell sizes in Google Sheets at once? 

The smoothest way to change all cell sizes in Google Sheets to share the same width or height in one fell swoop is by using specific cell dimensions. 

1. Highlight every column or row in your spreadsheet. 

2. Right-click your highlighted selection, and click Resize columns [column range] or Resize rows [row range]. 

3. Enter the specific dimensions for your column width or cell height. 

4. Click OK.  

Related reading: 

This article was originally published in July 2024. The most recent update was in March 2026.