How To Make All Cells the Same Size in Google Sheets Easily

Reading time icon 1 min. read


Readers help support MSpoweruser. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help MSPoweruser sustain the editorial team Read more

how to make all cells the same size in google sheets

Here’s how to make all cells the same size in Google Sheets:

Step 1 – Select all columns in the sheet. 

select all columns

Step 2 – Right-click on any column label and select ‘Resize columns A-Z’.

resize columns a-z

Step 3 – Select “Enter new column width in pixels” and input the size you want for all columns.

enter new column width

Step 4 – Click ‘OK’.

Now, let’s move on to rows.

Step 5 – Select all the rows in the sheet.

select all rows

Step 6 – Right-click on any of the row indexes and click “Resize rows 1-1000“.

resize rows 1-1000

Step 7 – Select “Specify row height” and input the custom size.

specify row height

Step 8 – Click ‘OK’.

So, now you know how to make all cells the same size in Google Sheets! Your sheets will now look more organized and be easier to read.

You may also be interested in:

User forum

0 messages