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.
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.
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.
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.
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!
You can do this on Column A or even Column C. It applies to all columns, really.
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.
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.
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.
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”.
References:
- “Can’t resize multiple rows in Sheets“, Google.com Support, Retrieved July 21, 2022
- “Change row height or column width“, Google.com Support, Retrieved July 21, 2022
- Mel Hawthorne, “Google Sheets: Set Cells to Same Size“, TechniPages.com, March 16, 2021
- Goldy Arora, “Bulk Resize columns and rows in google sheets – Watch Video“, YouTube, March 22, 2018
- “Make All Rows / Columns the Same Size in Excel & Google Sheets“, AutomateExcel.com, Retrieved July 21, 2022
Google Sheet: Make a copy