Nehad Ulfat
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.
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.
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.
Step 3:
⇒ A box will appear, mention the desired column width you want. I’ve typed 20.
⇒ Click OK.
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.
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.
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.
Step 2:
⇒ Like the previous method, do the same now. Choose the Column Width command & a box will appear.
Step 3:
⇒ Type the number you want as the column width.
⇒ Press Enter on the keyboard or click OK with the mouse.
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.
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.
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.
Step 2:
⇒ Double click the left button of the mouse & the result will be displayed at once.
You’ve just reshaped Column A only.
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.
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.
Steps:
⇒ Under the Home tab, select Cells group of commands.
⇒ Choose Format drop-down.
⇒ Select Autofit Column Width command.
And here’s the final view of your columns with resized shapes.
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
Step 2:
⇒ Under the ‘Customize the Ribbon’ tab on the right, select Main Tabs.
Under Main Tabs, you’ll see the Developer option unmarked.
Step 3:
⇒ Mark the Developer option & press OK.
Now you’ll be able to find the Developer ribbon at the top.
Step 4:
⇒ Select the Developer tab.
⇒ From the Developer tab, click on the Visual Basic command.
A new window will appear which is called Visual Basic Window.
Step 5:
⇒ Select Insert tab.
⇒ Tap on the Module option.
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.
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.
Finally to your Excel Spreadsheet & you’ll see the changes you’ve made through your coding.
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.
