How to do text wrapping in Excel
A free Office suite fully compatible with Microsoft Office
You have a lot of data to display in your spreadsheet, but you don't want it to look messy. You could keep squeezing everything together, making your spreadsheet hard to read. The solution is text wrapping. It will group your information into paragraphs and make it easy to read at a glance.
Excel text wrapping is something that you may not have encountered before. Typically, you'll use Excel to display information in rows and columns. But there are some cases where you want the text to wrap around objects or paragraphs within your workbook. In this tutorial, you will learn how to do text wrapping in Excel. Text wrapping is a functionality that allows you to link different cells together so that the text from one cell flows into another and so on.
Tips that are provided in this article are compatible with versions 2010/2013/2016.
How To Do Text Wrapping in Excel- Cell formatting Method
Text wrapping is a feature that allows the text in a cell to flow beyond the boundaries of the cell.
Text wrapping is a feature that wraps the text in the boundaries of the cell.
If you are using Excel 2016, 2013, or 2010, you can use the Format Cells dialog box.
1. Select all cells where you want to wrap text, right-click and select Format Cells.
2. In the Alignment tab, select Wrap Text and then click OK. The text will be wrapped automatically.
3. Let’s try it on an example.
4.In the alignment tab, select text wrap.
The result you can see is the following.
Now you know how to do text wrapping in Excel.
How To Do Text Wrapping in Excel- Wrap Text option
In Excel, you can use the Wrap Text option to wrap text around the shape or object that you have selected. You can also do this by choosing a text block and then clicking on the Wrap Text button on the Home tab of the ribbon.
To wrap text around an object in Excel, follow these steps:
1.Select the text.
2.Select the wrap text option from the ribbon.
3.The result is as follows.
Now you know how to do text wrapping in excel using the wrap option from the ribbon.
How To Do Text Wrapping in Excel- Using Keyboard Shortcut
Text wrapping makes it easy for users to edit and format the text without worrying about whether the text is too long or too short for its container. Let’s see how we can wrap text in Excel using keyboard shortcuts.
This keyboard shortcut will allow you to wrap text around any selected shape present on your worksheet.
1.Select the text
3.Your text will be wrapped like this
Now you know how to wrap text in Excel using the keyboard shortcut.
Did you learn about how to do text wrapping in Excel?. You can follow WPS academy to learn more features of Word documents, Excel Spreadsheets, and PowerPoint slides.
You can also download WPS Office to edit word documents, Excel Spreadsheets, and PowerPoint free of cost. Download Now! And get an enjoyable working space.
Was this helpful?
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. How to compare two excel sheets and highlight differences
- 3. Check if value is in list in Excel (3 easy methods)
- 4. How to copy file names in Excel from a folder?
- 5. How to color cell based on value in Excel?
- 6. How to add month name from date in Excel formula