How to Make All Cells the Same Size in Excel (5 Quick Ways)

Are you looking for the methods to resize the multiple cells in an Excel spreadsheet? In Microsoft Excel, most of the time we need to resize the shapes of the cells to adjust all the input data in a column or row so that these data don’t merge with other cells. It’s in fact very easy to do & here I’m going to show you some useful methods on how to make all cells the same size by adjusting row height & column width in Excel. 


Download Our Practice Workbook

You can download the workbook here that we’ve used to make this content.


5 Methods You Should Apply to Make All Cells the Same Size in Excel

Here I’m applying all the methods available with visual illustrations & I hope it’ll help you to understand the basics & apply them with comfort while working with your excel spreadsheets.

1. Use Column Width Command to Make All Cells Similar Size

Suppose, you have 2 groups of full names of 20 people & now you want to adjust the column size to show all names exactly in Column A & Column B so that they won’t merge with other cells.

You can do it for Column A & Column B only or even for the whole columns available in the spreadsheet.

Use Column Width Command to Make All Cells Similar Size

Step 1: 

⇒ Click on the ‘Select All’ option which is marked inside a highlighted area in the figure below.

It’ll select all the cells in the spreadsheet.

Use Column Width Command to Make All Cells Similar Size

Step 2:

⇒ Under the Home tab, choose the Cells group of commands.

⇒ From the Cells group of commands, select the drop-down named Format.

⇒ Now tap on the Column Width command.

Use Column Width Command to Make All Cells Similar Size

Step 3: 

⇒ A box will appear, mention the desired column width you want. I’ve typed 20.

⇒ Click OK.

Use Column Width Command to Make All Cells Similar Size

You’ll see all the column widths with the same sizes right away. 

The two groups of names are now fully visible due to the resize of the cells.

Use Column Width Command to Make All Cells Similar Size

Read more: How to Make Excel Cells With The Same Height and Width


2. Select Particular Rows & Columns to Make the Cells Same Size in Excel

Now I’ll show you how to resize only a number of selected columns.

Let’s do it with the previous datasheet.

Select Particular Rows & Columns to Make the Cells Same Size in Excel

Step 1:

⇒ Select Column A with the mouse.

⇒ Press Shift key.

⇒ Holding the Shift key & without releasing, tap on Column B with the mouse.

This will copy Columns A & B together.

Select Particular Rows & Columns to Make the Cells Same Size in Excel

Step 2:

⇒ Like the previous method, do the same now. Choose the Column Width command & a box will appear.

Select Particular Rows & Columns to Make the Cells Same Size in Excel

Step 3:

⇒ Type the number you want as the column width.

⇒ Press Enter on the keyboard or click OK with the mouse.

Select Particular Rows & Columns to Make the Cells Same Size in Excel

You’re seeing the result as only A & B columns have been resized here with the customized width and other columns which you haven’t selected are still lying with their default sizes.

Select Particular Rows & Columns to Make the Cells Same Size in Excel

You can follow the same procedures to reshape the rows.


3. Use a Mouse to Fix the Row & Column Size Manually

What we’ve done in the last 2 methods can also be done with the mouse & it’ll definitely save your time. 

Use a Mouse to Fix the Row & Column Size Manually

Step 1:

⇒ Have a close look between the names of Columns A & B. 

⇒ An extension border is there, point the mouse cursor on the extension border.

⇒ The cursor will change its shape into a sign or symbol which directs you to stretch rightward or leftward.

Use a Mouse to Fix the Row & Column Size Manually

Step 2:

Double click the left button of the mouse & the result will be displayed at once.

You’ve just reshaped Column A only.

Use a Mouse to Fix the Row & Column Size Manually

Step 3:

⇒ Now to resize Column B which is currently merged with Column C, follow the same procedure.

⇒ Put your mouse cursor now on the border between the column names B & C. 

Double click the mouse like before & Column B will be resized too to adjust automatically.

Use a Mouse to Fix the Row & Column Size Manually

This procedure will not only save your time but also adjust the column & row sizes according to their own cells. 


4. Choose ‘Autofit’ Option to Fix Column Width & Row Height in Excel

This is the ultimate option now which will serve your all purposes I hope.

It’ll save your time as well as you don’t have to double click the mouse button every time for all columns or rows.

To follow this method, first of all, click on the Select All option in the left top corner under the Name Box which I’ve shown you already in method 1.

Choose ‘Autofit’ Option to Fix Column Width & Row Height in Excel

Steps:

⇒ Under the Home tab, select Cells group of commands.

⇒ Choose Format drop-down.

⇒ Select Autofit Column Width command.

Choose ‘Autofit’ Option to Fix Column Width & Row Height in Excel

And here’s the final view of your columns with resized shapes.

Choose ‘Autofit’ Option to Fix Column Width & Row Height in Excel

Read more: How to Make Excel Cells Expand to Fit Text Automatically (7 Easy Ways)

5. Insert VBA Codes to Make All Cells Same Size in Excel

If you opt to choose to code to resize the column width & row height then VBScript (Visual Basic Scripting) will be the suitable option.

To do this, at first, you have to enable the Developer ribbon or tab.

Step 1:

⇒ Point your mouse cursor on the Home ribbon & right-click the mouse button.

⇒ Select the ‘Customize the Ribbon…’ command

Insert VBA Codes to Make All Cells Same Size in Excel

Step 2:

⇒ Under the ‘Customize the Ribbon’ tab on the right, select Main Tabs.

Under Main Tabs, you’ll see the Developer option unmarked.

Insert VBA Codes to Make All Cells Same Size in Excel

Step 3:

⇒ Mark the Developer option & press OK.

Insert VBA Codes to Make All Cells Same Size in Excel

Now you’ll be able to find the Developer ribbon at the top.

Insert VBA Codes to Make All Cells Same Size in Excel

Step 4:

⇒ Select the Developer tab.

⇒ From the Developer tab, click on the Visual Basic command.

Insert VBA Codes to Make All Cells Same Size in Excel

A new window will appear which is called Visual Basic Window.

Step 5:

⇒ Select Insert tab.

⇒ Tap on the Module option.

Insert VBA Codes to Make All Cells Same Size in Excel

So finally you’ve enabled a coding module where you’ll type your codes & run the program.

Here I’ve written a code that you can follow to type in your module too.

You can change the value for ColumnWidth as well as Row Height which will visualize & resize the cells according to your input criteria.

Insert VBA Codes to Make All Cells Same Size in Excel

Step 6:

⇒ Now run this code by pressing F5 or simply clicking on the Play(Marked inside the red box) button shown in the figure.

Insert VBA Codes to Make All Cells Same Size in Excel

Finally to your Excel Spreadsheet & you’ll see the changes you’ve made through your coding.

Insert VBA Codes to Make All Cells Same Size in Excel

Notes: 

i) If you want to choose an array that consists of both columns & ranges then you’ll write Range(“A1: B11”).ColumnWidth = 20 in place of ColumnWidth = 20

The same will go for RowHeight by mentioning its range at the beginning.

ii) Again If you opt to choose Autofit with the help of coding then type ColumnWidth.Autofit in lieu of Selection.ColumnWidth = 20

You can do the same for Row Height too.

Or even if you want you can do these together by mentioning both commands serially.


Conclusion

So, these are the basic & most useful methods you can apply to make all the cells the same size in Microsoft Excel. I hope these techniques will have an impact on your work with Excel on a regular basis.

If you find these convenient you’re always welcome to comment with your valuable opinions & thoughts.


Further Readings

Nehad Ulfat

Nehad Ulfat

Hello, Welcome to my profile. I'm a Technical Content Creator as well as a Naval Architect & Marine Engineer. I have preferences to do analytical reasoning & writing articles on various statistical data. Here, you'll find my published articles on Microsoft Excel & other topics related to my interests!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo