Often when you're entering data into a Microsoft Excel spreadsheet, you want certain cells to span multiple lines, either for addresses, multiline pieces of information or just for readability ...

When you need to format text in multiple ways in a single cell in Microsoft Excel, then this guide shows you how to do it the easy way.

Here are some Microsoft Excel time saving tricks for fast working. Add new line easily in a cell, create chart templates and use them easily. Give name to a cell, etc.

Click the Alignment tab and check the Wrap text checkbox. Click OK. Add your text to the cells. Excel now automatically wraps the text and resizes the cell as needed. Use Forced Line Breaks.