How to Make Cells Same Size in Google Sheets?

The cells of a blank Google Sheets document or spreadsheet come in the same uniform size by default. Therefore, if you’re curious about how to make cells same size in google sheets, you’re probably wondering how to keep them uniformly sized after you’ve started resizing them.

It’s also handy to know how to do this when copying and pasting raw data from other websites or from Microsoft Excel itself, with them ending up constricted in some way.

Why Do You Need to Make Cells the Same Size in Google Sheets?

It’s hard having to manually resize each and every cell, row, or column manually in a neat and organized manner when you can do so all at the same time or for the whole spreadsheet. It’s also hard to deal with badly formatted and funky raw data you’ve pasted unto the sheet.

  • Funky Formatting: When pasting raw data, they might end up trying to fit into the default size of your empty spreadsheet’s cells, resulting in funky formatting that looks wrong.
  • Format All at Once: Instead of having to manually estimate its original formatting, you can fix all these unformatted text and figures by resizing multiple rows and columns at the same time.
  • Another Good Quick Fix: Aside from using the techniques outlined on this tutorial, another good quick fix is to simply select the raw data and do a “Text wrap” on them so that the cells automatically fit the data size.

How to Make Cells Same Size in Google Sheets

Step 1: Open a new spreadsheet. We’ve even renamed this one after the tutorial!

Step 2: Select all cells by pressing “Ctrl + A” or clicking on the top-left corner gray pane. This selects your entire spreadsheet as a whole, actually.

Cells Same Size Step 2A - Select all cells

If you have data on your spreadsheet, you can select that instead of the whole spreadsheet. Just highlight multiple rows or columns by pressing the Ctrl key then clicking your mouse on the column letters or row numbers you wish to select.

Cells Same Size Step 2B - Select only certain cells

We’ve selected Column Letters this time. By the way, the table info we’re using was taken from an article comparing Kratom to CBD.

Step 3: Resize the topmost row by clicking on then dragging the bottom part of Row 1. Your cursor should turn into a double-headed arrow while you’re doing this.

Cells Same Size Step 3A - Drag Row 1 down to resize Row 1

Now all the other rows you’ve selected should follow suit and get resized thusly. They’ll uniformly follow the size of the first row you’ve resized. Selecting them then resizing a row acts like an “Apply to All” feature for them.

Cells Same Size Step 3B - All the rows have now been resized uniformly

Step 4: Now do the same with columns. Resize Column A in order to see the changes reflect all the way to Column E. What good for the goose is good for the gander; what’s good for the rows is good for the columns!

Cells Same Size Step 4A - Resize columns the same way

You can do this on Column A or even Column C. It applies to all columns, really.

Cells Same Size Step 4B - The cells have been uniformly resized by rows and columns

Even if there were no data inside those cells and you just went with the “Ctrl + A” or “Select All” method of cell resizing, the same results should apply.

Cells Same Size Step 4C - Same results with the blank version of the spreadsheet

Whatever you do to one cell should apply to the rest of the spreadsheet. Resize the cells by the rows and columns and the rest of the cells will follow.

Step 5: You can also right-click either the row or column to uniformly resize a row or column of cells. Just click “Resize column/row” on the ensuing right-click menu.

Cells Same Size Step 5 - Right-click a row or column then select Resize orw or column

Step 6: You’ll be given a prompt with two options—”Fit to data” or entering a specific column width in pixels. The safe bet here is to go with “Fit to data”. You can also enter different pixel widths (or heights) by trial and error until you get what you want.

Cells Same Size Step 6 - Choose between Fit to data or pixel width or height

Step 7: Whatever you’ve chosen will apply to the whole column or row that you’ve right-clicked to get to that prompt. Again, what’s good for column pixel width is also good for row pixel height.


Final Words

To resize all the cells of your spreadsheet into the same size, just press Ctrl + A to select them all then resize one of them and watch the rest get formatted the same way as the one cell you resized.

As an alternative, you can right-click on the icons for columns (letters) or rows (numbers) to resize entire rows and columns by the dropdown menu for good measure. Enter a pixel width/height or have the cells “Fit to data”.


  1. Can’t resize multiple rows in Sheets“, Support, Retrieved July 21, 2022
  2. Change row height or column width“, Support, Retrieved July 21, 2022
  3. Mel Hawthorne, “Google Sheets: Set Cells to Same Size“,, March 16, 2021
  4. Goldy Arora, “Bulk Resize columns and rows in google sheets – Watch Video“, YouTube, March 22, 2018
  5. Make All Rows / Columns the Same Size in Excel & Google Sheets“,, Retrieved July 21, 2022

Google Sheet: Make a copy

Andy Avery

I really enjoy helping people with their tech problems to make life easier, ​and that’s what I’ve been doing professionally for the past decade.

Recent Posts