How to Make All Cells the Same Size in Excel (Quick and Easy) 

Today we’ll be talking about how to make all cells the same size in Excel. 

Let’s start! 

How to Select All Cells in One Click

To make all cells in the spreadsheet the same size, first click into the top left corner of the sheet to select all columns and rows. 

How to Resize All Columns to the Same Width

Then set the cursor on the column headers, specifically on one of the lines marking a column border.

The cursor changes to a double arrow. Now just press the left mouse button, hold it, and set the width as necessary.

As soon as you release the button, the width you’ve set will apply to all columns.

How to Set a Specific Column Width

We can also set a specific value as the column width and it can be done more easily than you’d think! 

Again, set the cursor on the column headers, but instead of dragging the border line manually, do a right-click and choose the option ‘Column Width’.

Here’s a window in which we can type a specific number to define how wide all columns in the spreadsheet should be. Let’s go for 11 here, press OK and here we go with all columns having the same specified width. 

How to Adjust Row Height Uniformly

The same way we can adjust the row height.  

First, we set the cursor on one of the row borders.

Then we press and hold the left mouse button and drag to set a universal row height. 

If there’s a specific value to be used for the row height, right-click on the row headers on the left, choose ‘Row Height’ and enter the defined number.

We’re going to use 13 here. 

Press OK and that’s all it takes to set the same height for all rows in the spreadsheet! 

Don’t miss out a great opportunity to learn:

• How to Insert Column in Excel
• How to Select Two Different Columns in Excel at the Same Time
• How to Move Columns in Excel

If you found this tutorial helpful, give us a like and watch other tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!