Using the Text to Columns Tool . One way to split data into multiple columns in Microsoft Excel is to use the built-in Text To Columns tool. This method is handy if you prefer to ...

If you decide to use Excel for your tasks, learning how to make Excel cells fit text is very important. ... You can see that the text spills over into the space of multiple cells.

Open the Excel worksheet for which you want to alter the column width. Click on the Home tab in the Excel ribbon. Go to the Cells group and click on the "Format" icon to reveal the Cell Size menu.

But when you can’t change the size of a cell to fit the text, this tip shows how you can resize the text to fit within the cell. SEE: Explore these Excel tips every user should master .