How to make Excel cells expand to fit Text There are a few ways that you `can make your Excel cells fit text. You will most likely use a mixture of these methods depending on your project.

Microsoft Excel’s AutoFit feature is great when you need to resize a cell to display more text than the cell currently allows. But when you can’t change the size of a cell to fit the text ...

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

Simply press CTRL and the numeric pad's + key—the non-Numpad + key won't work—to automatically resize all columns to fit the text contents.