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

In this article, you will get the easiest ways to make a cell bigger in Excel. It is very common for a bigger text to be not fitted in the given cell size while working with Excel. So, to fit a bigger text in a cell you have to make a cell bigger. Here, you will get the ways by following which you will be able to do this easily.

Download Excel Workbook

7 Ways to Make a Cell Bigger in Excel

In the following data table, I have 3 columns among which the last column named Email Id has texts which have not been fitted here. So, to fit these texts in the cells I have to enlarge these cells. I will describe different ways of making a cell bigger in Excel with this example.

data table

Method-1: Using Merge and Centre option

Step-01: At first select the cell and its adjacent cells to make the cell bigger and then follow Home Tab>>Merge & Center Group>>Merge & Center Option.

merge and center

Step-02: After that the first cell will be bigger and the Email Id has been fitted here. Now you have to copy this format to the following cells also and so follow Home Tab>>Format Painter Option.

using format painter

Step-03: Now you have to drag down the indicated sign.

using Format painter

Step-04: In this way, all of the Email Ids will be fitted in these cells.

how to make a cell bigger in Excel

Method-2: Using Wrap Text option

Step-01: At first select the first cell of the Email Id column and then follow Home Tab>> Wrap Text Option.

using Wrap Text

Step-02: After that, the first cell will be bigger and the text will be fitted in there. Now you have to follow Step-02 and Step-03 of Method-1.

Using Wrap Text

Step-03: In this way, you will get all of the texts fitted in the bigger cells.

using Wrap Text

Method-3: Fixing Column Width with a Mouse Click

Step-01: At first select the Email Id column and then drag the indicated sign to the right to fit in the Email Ids in the cells.
You can also double-click on this sign.

fixing column width with mouse click

Step-02: In this way, the following result will appear.

making cells bigger

Method-4: Fixing Column Width Using Shortcut Method

Step-01: At first select the column in which the cells are to be enlarged and then press ALT+H, O, I. Here, ALT+H will bring you to the Home Tab, then, O to the Format Group, and then, I will select the AutoFit Column Width.

fixing column width with shortcut method

Step-02: In this way, the texts will be fitted in a bigger cell automatically.

making cells bigger

Read more: How to Autofit in Excel

Method-5: Fixing Column Width Using Format Option

Step-01: Select the Email Id column and then follow Home Tab>>Cells Group>>Format>>AutoFit Column Width

fixing column width with format option

Step-02: In this way, the texts will be fitted in a bigger cell automatically.

making cells bigger

Method-6: Fixing Row Height Using Format Option

Step-01: Select the range of rows which you want to enlarge like here is Row 4 to Row 11 and then follow Home Tab>> Cells Group>> Format>> Row Height

fixing row height

Step-02: Then a Row Height Dialog Box will appear here you will give a Row height according to your needs. Here I have taken 48 Points as Row height.

fixing row height

Step-03: Then the Row heights will be enlarged.

making cells bigger

Step-04: After that, select the Email Id column and follow Home Tab>>Wrap Text

using wrap text

Step-05: Then the texts will be fitted in the cells as shown below.

making cells bigger in Excel

Method-7: Using VBA Code

Step-01: Follow Developer Tab>>Visual Basic. You can do this by pressing ALT+F11 also.

VBA developer

Step-02: After that, Visual Basic Editor will appear, and here follow Insert >>Module

inserting module

Step-03: Then Module 1 will be created and here type the following code. After that, press F5.

Sub AutoAdjustColumnWidth()

Columns(“D”).AutoFit

End Sub

In this code, you can change the column as per your needs. I have selected Column D because I want the cells in this column to be bigger.

VBA Code

Step-04: In this way, the following result will appear.

making cells bigger

Conclusion

In this article, I tried to cover up the easiest ways by following which you will be able to make a cell bigger in Excel. Hope this article will be helpful to you. If you have any further suggestions feel free to share them with us. Thank you.


Further Readings

Tanjima Hossain

Tanjima Hossain

Hello everyone, This is Tanjima Hossain. I have completed my graduation from BUET. Then I have started working as a technical writer in SOFTEKO. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. Besides this I love to interact with different people and I love to spend my spare time by reading, gardening ,cooking etc.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo