How to Make All Cells the Same Size in Excel (7 Easy Ways)

Method 1 – Using Column Width Command to Make All Cells Same Size in Excel

Steps:

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. Or, you can also use shortcut keys CTRL + A.

Using Column Width Command

Go to the Home tab.
Select the drop-down named Format on the Cells group.
Tap on the Column Width command on the drop-down list.

Calling Column Width Command

The Column Width input box will appear.

Enter the desired Column width you want. We’ve entered 20.
Click OK.

Setting Column Width

The column widths will become the same size. The two groups of names are now fully visible due to the resizing of the cells.

Using Column Width Command to make all cells the same size in excel

Method 2 – Selecting Particular Excel Rows and columns to Make the Same Size for All Cells

Steps:

Select Column A.
Press the SHIFT key.
Hold down the SHIFT key and click on Column B. This will select columns A & B together.

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

Follow the steps shown in the previous method. Choose the Column Width command & an input box will appear.

Enter the number you want as the Column width.
Press ENTER or click OK.

Setting Column Width

Columns B and C will be resized while other columns will remain unchanged.

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

You can follow the same procedures to resize rows.

Method 3 – Using the Mouse to Fix the Same Size for All Excel Cells Manually

Steps:

There is an extension border between columns B and C.
Hover the mouse cursor over the extension border. The cursor will change its shape into an arrow (or symbol) that indicates you can drag the border to resize it leftward or rightward.

Using Mouse to Fix the Cell Size Manually

Double-click the left button of the mouse.

It will resize Column B only.

To resize Column C which is currently merged with Column D, follow the same procedure.

Hover the mouse cursor over the border between columns C and D.
Double-click the mouse and Column C will be resized automatically.

Double-Clicking Between Two Columns

Using Mouse to to make all cells the same size in excel

Read More: How to Fix Cell Size in Excel

Method 4 – Selecting AutoFit Option for Fixed Column Width & Row Height

Steps:

Click on the Select All icon in the left top corner under the Name box.

Choosing AutoFit Option to Fix Column Width & Row Height in Excel

Go to the Home tab.
Click on the Format drop-down on the Cells group.
Select AutoFit Column Width from the list.

Calling AutoFit Column Width Command

The columns will be resized.

Choosing AutoFit Option to make all cells the same size in excel

Method 5 – Applying Excel VBA to Make All Cells the Same Size

Steps:

Right-click on the Home tab.
Select the Customize the Ribbon… command.

Inserting VBA Code

Under the Customize the Ribbon section on the right, select Main Tabs.

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

Customizing the Ribbon

Check the box of the Developer option & press OK.

Getting Developer tab on the Ribbon

The Developer tab will be added to the Ribbon.

G to the Deoveloper tab.
Click on the Visual Basic command.

The Microsoft Visual Basic for Applications window appears.

Go to the Insert tab.
Select the Module option.

Inserting Code Module

Add the code below in the module.

Sub resize()
Selection.ColumnWidth = 25
Selection.RowHeight = 20
End Sub

VBA Code to make all cells the same size in excel

You can change the value for ColumnWidth as well as for the RowHeight which will resize the cells according to your input criteria.

Run the code by pressing F5 on the keyboard or clicking on the Play (marked inside the red box) button shown in the figure.

Executing Code

The columns will be resized. Inserting VBA Code to make all cells the same size in excel

Method 6 – Making All Cells the Same Size Using Shortcut in Excel

Steps:

Select cells in the B4:C14 range that you want to resize.

How to Make All Cells the Same Size Using Shortcut in Excel

Press the ALT key and without releasing it, press the H, O, and W keys one after another.
It will open the Column Width input box.
Set your desired Column width and click OK.