How to Make Excel Cells Expand to Fit Text Automatically (5 Methods)

Excel has a specific row height and column width. So when you enter some text or values that occupy more space than the current size of cells, you’ll notice that it crosses the border of the cells. In such cases, Excel offers some features to adjust the rows and columns to fit the text in the cell. Today, in this article we will demonstrate some methods to make excel cells expand to fit text automatically.


Download Practice Workbook

Download this practice book to exercise the task while you are reading this article.


5 Suitable Ways to Make Excel Cells Expand to Fit Text Automatically

Consider a situation where you are working in a book shop and you are inputting the Book Names and their Descriptions. But the fixed row and the cell height are not covering the text length so the texts are spilling out. We need to make some adjustments using some Excel features to make cells expand. In this article, we will apply five different methods to do that.

Double Click the Mouse to Make Excel Cells Expand to Fit Text Automatically


1. Double-Click the Mouse to Make Excel Cells Expand to Fit Text Automatically

Step 1:

  • Move your mouse cursor to the right edge column header.
  • When the mouse icon changes to a double-sided arrow icon, stop moving your mouse

Double Click the Mouse to Make Excel Cells Expand to Fit Text Automatically

  • Now Double-Click on the icon to fit text automatically.

Double Click the Mouse to Make Excel Cells Expand to Fit Text Automatically

Step 2:

  • So we can see that cells are adjusted automatically in the Book Names Do the same for the Description Column.

Double Click the Mouse to Make Excel Cells Expand to Fit Text Automatically

  • And Double click on the icon to auto-fit your texts.

Double Click the Mouse to Make Excel Cells Expand to Fit Text Automatically

Read more: How to Autofit in Excel


2. Use a Keyboard Shortcut to Make Excel Cells Expand to Fit Text Automatically

You can also use keyboard shortcuts to fit text automatically. Follow these easy steps to learn.

Step 1:

  • Select the column whose cells you want to expand to fit cells. Now press “Alt+H+O+I” on the keyboard.

Use a Keyboard Shortcut to Make Excel Cells Expand to Fit Text Automatically

  • And our cells are expanded automatically.

Use a Keyboard Shortcut to Make Excel Cells Expand to Fit Text Automatically

  • Do the same for the next column also

Use a Keyboard Shortcut to Make Excel Cells Expand to Fit Text Automatically

  • Press “Alt+H+O+I” to get your job done.

Use a Keyboard Shortcut to Make Excel Cells Expand to Fit Text Automatically

Step 2:

  • If you have to fix your column height you can do it using keyboard shortcuts too.
  • Select the columns you want to fit text automatically.
  • Press “Alt+H+O+A” on the keyboard

Use a Keyboard Shortcut to Make Excel Cells Expand to Fit Text Automatically

  • And our column heights are expanded to fit text automatically.

Use a Keyboard Shortcut to Make Excel Cells Expand to Fit Text Automatically


3. Apply Excel Feature to Make Excel Cells Expand to Fit Text Automatically

Excel has a built-in feature to fit text automatically when your texts are crossing the fixed row or column height and width. The feature is described below.

Step 1:

  • In your Home tab, go to the Cell ribbon and select Format. From the available options, click AutoFit Row Height.

Apply Excel Feature to Make Excel Cells Expand to Fit Text Automatically

  • And our row heights are expanded to fit text automatically.

Apply Excel Feature to Make Excel Cells Expand to Fit Text Automatically

Step 2:

  • Now we will fix our column width. Go to the Cells ribbon again and select Format. From the available option, click on Autofit Column Width.

Apply Excel Feature to Make Excel Cells Expand to Fit Text Automatically

  • Finally, our cells are expanded to fit text automatically.

Apply Excel Feature to Make Excel Cells Expand to Fit Text Automatically


4. Introduce Wrap Text Feature to Make Excel Cells Expand to Fit Text Automatically

Step 1:

  • Select the whole dataset. Go to Home Tab and from Alignment Ribbon click on the Wrap Text option

Introduce Wrap Text Feature to Make Excel Cells Expand to Fit Text Automatically

  • The Wrap Text option made the texts of the cells remain within the cell. The cells are now vertically expanded to fit text automatically.

Introduce Wrap Text Feature to Make Excel Cells Expand to Fit Text Automatically


5. Employ Shrink to Fit Option to Expand Excel Cells to Fit Text Automatically

Step 1:

  • The shrink to Fit option will fill your text within the fixed cell size. To do that, select your whole dataset. Press “Ctrl+1” to open the Number Format tab

Employ Shrink to Fit Option to Expand Excel cells to Fit Text Automatically

  • In the new tab, go to the Alignment tab and check on Shrink to Fit. Click on to continue.

Employ Shrink to Fit Option to Expand Excel cells to Fit Text Automatically

  • Our texts are shrunk within the cells

Employ Shrink to Fit Option to Expand Excel cells to Fit Text Automatically


Things to Remember

⏩ The Shrink to Fit option may not be comfortable for bigger texts. In that case, other methods will do just fine.

⏩ Shrink to fit doesn’t work for cells that have the Wrap Text applied to it.


Conclusion

How to make excel cells expand to fit text automatically is shown in this article. We hope this article proves useful to you. Do comment if you have any questions or queries.


Similar Articles to Explore

Asikul Himel
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo