The shrink to Fit option will fill your text within the fixed cell size.Employ Shrink to Fit Option to Expand Excel Cells to Fit Text Automatically The cells are now vertically expanded to fit text automatically.ĥ. The Wrap Text option made the texts of the cells remain within the cell.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

Finally, our cells are expanded to fit text automatically.Ĥ.From the available option, click on Autofit Column Width. Go to the Cells ribbon again and select Format. And our row heights are expanded to fit text automatically.From the available options, click AutoFit Row Height. In your Home tab, go to the Cell ribbon and select Format.Apply Excel Feature to Make Excel Cells Expand to Fit Text AutomaticallyĮxcel has a built-in feature to fit text automatically when your texts are crossing the fixed row or column height and width. And our column heights are expanded to fit text automatically.ģ.Select the columns you want to fit text automatically.If you have to fix your column height you can do it using keyboard shortcuts too.Press “ Alt+H+O+I” to get your job done.And our cells are expanded automatically.Select the column whose cells you want to expand to fit cells.You can also use keyboard shortcuts to fit text automatically. Use a Keyboard Shortcut to Make Excel Cells Expand to Fit Text Automatically And Double click on the icon to auto-fit your texts.Ģ.

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

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

When the mouse icon changes to a double-sided arrow icon, stop moving your mouse.

Move your mouse cursor to the right edge column header.

Double-Click the Mouse to Make Excel Cells Expand to Fit Text Automatically In this article, we will apply five different methods to do that.ġ. We need to make some adjustments using some Excel features to make cells expand. But the fixed row and the cell height are not covering the text length so the texts are spilling out. Make Excel Cells Expand to Fit Text Automatically.xlsxĥ Suitable Ways to Make Excel Cells Expand to Fit Text AutomaticallyĬonsider a situation where you are working in a book shop and you are inputting the Book Names and their Descriptions.

Google sheets fit text to cell