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


how to make all cells the same size in google sheets

Fix Windows errors with Fortect:
Fortect can repair common computer errors by scanning your entire system for damaged or missing OS files and replacing them with the original, working versions. Optimize your PC in 3 simple steps:

  1. Download and Install Fortect on your PC
  2. Use the PC Scan feature to look up any Windows issues (including drivers)
  3. Right-click on Repair, and fix it within a few minutes.

Besides that, it helps you clean up junk files, fix stability problems, and get rid of annoying programs and malware traces.

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:

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

User forum

0 messages