How to make cells the same size in Google Sheets: A Step-by-Step Guide

Let’s talk about spreadsheets. Specifically, how to make cells the same size in Google Sheets. Imagine you’ve got a beautiful set of data, but it’s all a bit wonky because the cells are different sizes. It’s an eyesore, right? Well, don’t worry. It’s a simple fix, and I’m going to show you exactly how to do it. In less than a minute, you’ll be able to transform that chaotic sheet into a tidy, uniform, professional-looking document. Let’s get started!

Step by Step Tutorial: Making Cells the Same Size in Google Sheets

Before we dive into the steps, let’s understand what we’re doing. By making cells the same size, we’re setting a standard width and height for all the cells in your sheet. This doesn’t just make it look neater; it also makes it easier to read and work with.

Step 1: Select All Cells

Click on the square in the top left corner of your sheet, between the A and the 1. This selects all the cells in the sheet.

When you click this square, you’ll notice that every cell in your spreadsheet is highlighted. This means any changes you make will apply to the entire sheet.

Step 2: Resize a Column

Hover over the line between two column headers until you see the resize cursor, then click and drag to resize.

As you drag, you’ll see a number pop up, telling you the width of the column in pixels. You can use this to make sure all your columns are the same width.

Step 3: Resize a Row

Do the same thing with the rows: hover over the line between two row numbers, then click and drag.

Just like with columns, you’ll see a number that indicates the height of the row. If you want uniformity, keep this number consistent across all rows.

After completing these steps, all your cells will be the same size. It’s a small change, but it can make a big difference in the appearance and functionality of your spreadsheet.

Tips for Making Cells the Same Size in Google Sheets

  • Double-clicking the line between column headers or row numbers will automatically resize them to fit the content.
  • Use the "Format" menu to set exact column widths and row heights.
  • Keep in mind that making cells too small might cut off content.
  • To quickly clear formatting and start fresh, use the "Clear formatting" option under the "Format" menu.
  • Remember that you can always adjust individual cell sizes later if needed.

Frequently Asked Questions

Can I make cells the same size across multiple sheets at once?

No, you’ll need to adjust the cell sizes for each sheet individually.

What if I have merged cells in my sheet?

Merged cells can complicate things. You’ll need to unmerge them first, make the cells uniform, and then re-merge if necessary.

Can I use keyboard shortcuts for this task?

Yes! Press Ctrl+A (Cmd+A on Mac) to select all cells. Then use Alt+E, I, R (or Option+E, I, R on Mac) to set row heights and Alt+E, I, C for column widths.

Will resizing cells affect my data?

No, it won’t affect the data itself, just how it’s displayed.

Is there a limit to how small or large I can make the cells?

Yes, Google Sheets has minimum and maximum values for cell sizes, but they’re quite generous and shouldn’t pose a problem for most users.


  1. Select all cells.
  2. Resize a column.
  3. Resize a row.


In conclusion, making cells the same size in Google Sheets is a breeze once you know how. By following the simple steps outlined above, you can quickly transform a messy spreadsheet into a clean, organized data haven. And remember, consistency is key—not just in the size of your cells, but in the way you present your data. A well-formatted spreadsheet speaks volumes about your attention to detail and professionalism. So next time you find yourself drowning in a sea of mismatched cells, just remember: a few clicks, drags, and drops are all that stand between you and spreadsheet nirvana. Now, go forth and organize!