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.
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.
- Then, select Home > Merge & Center Group > Merge & Center option.
- 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.
- 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.
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.
- 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.
- 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.
- 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.
- Then, select Home > Format > Row Height.
- 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.
- 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
- 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.