How to wrap text in Excel
A free Office suite fully compatible with Microsoft Office
The spreadsheet app MS Excel is a very powerful tool. Even if you’re not using it on a daily basis, you might have come across the following problem: You created a nice graph and now you want to add some text to precisely describe what your graph tells. But how do you style this text in MS Word?
You want to present data in Excel, but you want to apply a text wrap and make them look great. This is especially useful if you're using some sort of template for a presentation or brochure with information in cells throughout the page. So if you want to know how to wrap text in excel, you should follow our step-by-step instructions.
Tips that are provided in this article are compatible with versions 2010/2013/2016.
How To Wrap Text In Excel : Cell Formatting Method
The Home tab in Excel provides a number of useful features for formatting worksheets, including the ability to wrap text. Wrapping text allows you to break lengthy text into multiple lines so that it fits into a cell without having to scroll horizontally.:
Now let's see how to use this option:
1 - Select the cell on which you want to wrap text.
2 - Right click on the cell and select Format Cells from the drop-down menu that appears. Then choose Alignment from the tab on the left side of the dialog box that appears, as shown below:
3 - In the Alignment section go down until you find Wrap Text, then check this option as shown in the picture below:
4 - Click OK and that's all! Your text should now be wrapped properly
How To Wrap Text In Excel : Wrap Text From Ribbon
The most common way to wrap text in Excel is by using the Wrap Text tool. This tool is located in the Home tab of the Ribbon. You can also select this option from the Format menu.
1.To use this tool, click on it once and drag your cursor across the area where you want to wrap text. When you release the mouse button, Excel will automatically wrap your text as desired.
2.Now you how to wrap text in Excel using ribbon
How To Wrap Text In Excel: Keyboard Shortcut
When you're working in Excel, it's easy to want your text to wrap around the cells. For example, say you're writing a report and want the text to be broken up over several lines if it doesn't fit in one cell. When you press ALT + H + W, Excel will automatically wrap text at the end of each cell as you type. Here's how it works:
1.Select the text
2.And Press ALT, H and W one by one ,
3.Your text will be wrapped
That’s how you wrap text in excel using hotkeys.
Did you learn how to use the wrap text 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