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

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. In this article, you will get 7 easy ways how to make a cell bigger in Excel.


Download Practice Workbook

Download this sample file to practice by yourself.


7 Easy Ways to Make a Cell Bigger in Excel

To describe the methods, we need a sample dataset. In the following data table, we have 3 columns among which the last column named Email Id has texts which are not fitted in the cells. So, to fit these texts in the cells we have to enlarge these cells.

How to Make a Cell Bigger in Excel


We will describe 7 different ways of making a cell bigger in Excel with this example.

1. Use Merge and Center Option to Make a Cell Bigger

The merge and center option in the Excel Ribbon is very effective to make cells bigger. For this, follow these steps.

  • First, 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

  • Then, select Home > Merge & Center Group > Merge & Center option.

Use Merge and Center Option to Make a Cell Bigger

  • After that, the first cell will be bigger and the Email Id is fitted here.
  • Now, we need to copy this format to the following cells.
  • Therefore, choose Format Painter from the Home tab.

  • Next, drag the brush icon downwards all through the column.

  • In this way, we will get bigger cells like this.


2. Apply Wrap Text Feature for Making Bigger Cell in Excel

Wrap Text is another powerful tool to create bigger cells.

  • First, select the first cell of the Email Id column which is Cell D5.
  • Then, click on Wrap Text from the Home tab.

Apply Wrap Text Feature for Making Bigger Cell in Excel

  • After that, double-click on the both-sided arrow icon to make the cell bigger.

  • Now, right-click on it and select the Format Painter icon from its Context Menu.

  • Lastly, drag it through the column.
  • In this way, you will get all of the texts fitted in the bigger cells.

How to Make a Cell Bigger in Excel


3. Change Column Width to Expand a Cell with Mouse Click

You can also make multiple cells bigger with simple mouse clicks. Let’s see how it works.

  • First, select the Email Id column.
  • Then, 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

  • Also, you can double-click on this sign.
  • In this way, the following result will appear.


4. Make a Cell Bigger Using Keyboard Shortcut in Excel

Many of you may not know, but it is possible to make cells bigger with keyboard shortcuts as well.

  • First, select the column in which the cells are to be enlarged.
  • Then, press Alt + H + O + I on your keyboard one after another.

Make a Cell Bigger Using Keyboard Shortcut in Excel

Here, Alt + H will bring the Home tab, then, O to the Format group, and then, I will select the AutoFit Column Width.
  • In this way, the texts will be fitted into a bigger cell automatically.

Read more: How to Autofit in Excel


5. Apply Format Option to Create a Bigger Cell

The Format option in Excel is also very useful to make cells bigger. For this, follow the simple process below.

  • First, select the Email Id column.
  • Then, choose Home > Format > AutoFit Column Width.

Apply Format Option to Create a Bigger Cell

  • Accordingly, the texts will be fitted in a bigger cell automatically.


6. Fix Row Height with Format Option to Make a Bigger Cell

The Format option is also effective to adjust row height and make the cells bigger.

  • First, select the range of rows that you want to enlarge like here is Row 5 to Row 9.

Fix Row Height with Format Option to Make a Bigger Cell

  • Then, select Home > Format > Row Height.

Fix Row Height with Format Option to Make a Bigger Cell

  • Next, a Row Height dialog box will appear.
  • Here, give a value for Row Height according to your need.
  • For example, we have given 45 points as Row Height.

  • Afterward, press OK and the row heights will enlarge.

  • Now, select the Email Id column and click on Home > Wrap Text.

  • Finally, you will be to fit the texts in the cells as shown below.


7. Make a Cell Bigger with Excel VBA Code

In this last method, let us apply VBA code to enlarge cells in Excel.

  • First, choose Visual Basic from the Developer Tab. You can do this by pressing Alt + F11 also.

Make a Cell Bigger with Excel VBA Code

  • After that, Microsoft Visual Basic for Applications window will appear.
  • Here, select Module from the Insert tab.

  • Then, type this code on the blank page.
Sub AutoAdjustColumnWidth()
Columns("D").AutoFit
End Sub

Make a Cell Bigger with Excel VBA Code

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.
  • Lastly, press F5 and the following result will appear.


Conclusion

In this article, I tried to cover the 7 easy ways how 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. Follow ExcelDemy for more articles like this.


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

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo