How to Make a Cell Bigger in Excel (7 Easy Ways)

Method 1 – Using the Merge and Center Options to Make a Cell Bigger in Excel

Select Cell D5 and its adjacent cells that are required to make the cell bigger.

Use Merge and Center Option to Make a Cell Bigger

Select Home > Merge & Center Group > Merge & Center.

Use Merge and Center Option to Make a Cell Bigger

The selected cells are merged and the value fits inside the cell.
Select Format Painter from the Home tab.

Drag the brush icon downwards to apply the same format to the remaining cells in the columns.

We will get bigger cells as shown in the image below.

Read More: How to Change Cell Size in Excel

Method 2 – Applying Wrap Text Feature for Making a Cell Bigger

Select the Cell D5.
From the Home tab, click on Wrap Text.

Apply Wrap Text Feature for Making Bigger Cell in Excel

From the row bar, double click on the two-direction arrow icon.

Right-click on D5 and select the Format Painter icon from its Context Menu.

Drag the brush icon downwards to apply the same format to the remaining cells in the column.

This will wrap the text in the cells, showing the full text and automatically adjusting the row height.

How to Make a Cell Bigger in Excel

Method 3 – Changing Column Width to Expand a Cell with Mouse Click

Select the Email ID
Drag the indicated sign to the right to fit in the Email IDs in the cells.

Change Column Width to Expand a Cell with Mouse Click

Another option is to double-click on this sign.
The following image is the result.

Method 4 – Making a Cell Bigger Using Keyboard Shortcut in Excel

Select the column to be enlarged.
Press Alt + H + O + I on your keyboard one after the other.

Make a Cell Bigger Using Keyboard Shortcut in Excel

Alt + H will bring the Home tab, O to the Format group, and I will select the AutoFit Column Width.

The column width will be adjusted automatically to fit the text inside the cell.

Method 5 – Applying Format Option to Create a Bigger Cell

Select the Email ID column.
Go to the Home tab> Format > AutoFit Column Width.

Apply Format Option to Create a Bigger Cell

The column width will automatically be adjusted to fit the text inside the cells of the selected column.

Read More: How to AutoFit in Excel

Method 6 – Fixing Row Height with Format Option to Make a Bigger Cell

Select Row 5 to Row 9.

Fix Row Height with Format Option to Make a Bigger Cell

Go to the Home Tab > Format > Row Height.

Fix Row Height with Format Option to Make a Bigger Cell

Enter a value in the Row Height dialog box according to your preference.
We have entered 45 points as Row Height.

Press OK and the row heights will be increased to 45 points.

Select the Email ID column and go to the Home Tab >Select Wrap Text.

You will be able to fit the texts in the cells as shown below.

Method 7 – Making a Cell Bigger with Excel VBA Code

Select Visual Basic from the Developer Shortcut key is Alt + F11.

Make a Cell Bigger with Excel VBA Code

In the Microsoft Visual Basic for Applications window, select Module from the Insert tab.

Enter the following code.

Sub AutoAdjustColumnWidth()
Columns("D").AutoFit
End Sub

Make a Cell Bigger with Excel VBA Code

Press F5 and the following result will be as shown below.

Download Practice Workbook

Make a Cell Bigger.xlsm

<< Go Back to Cell Size | Excel Cells | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!