This text appears to be a somewhat garbled and machine-translated version of an article about how to use the “boss” feature (actually called “text wrapping”) in Microsoft Excel.
Here’s a cleaned-up and rewritten version:
How to Use Text Wrapping in Excel: A Step-by-step Guide
Are you tired of manually formatting your cells in Excel? Do you want to know the secret to easily wrapping text in a cell without any hassle? Look no further! In this article, we will guide you through the different methods to use text wrapping in Excel.
Why Use Text Wrapping in Excel?
Text wrapping in Excel allows you to easily format your cells by inserting line breaks without having to manually adjust the cell’s dimensions. This feature is especially useful when working with long texts that need to be formatted correctly.
Method 1: Using Keyboard Shortcuts (Alt + Enter)
The most practical method to use text wrapping in Excel is by using a keyboard shortcut. To do this:
- Double-click on the cell where you want to insert the text.
- Start typing your text, and when you reach the desired line break, press Alt + Enter.
That’s it! The indicator will automatically move to the new line below the cell, allowing you to continue typing.
Method 2: Using The Text Wrapping Option
Another method to use text wrapping in Excel is by using the text wrapping option. To do this:
- Highlight the cells where you want to insert the text.
- Go to Home > Alignment > Text Wrapping.
- Confirm your selection by clicking OK.
The text will automatically be formatted with line breaks, and the cell height will be adjusted accordingly.
Method 3: Using Formulas (CONCATENATE)
A more advanced method is by using formulas. To do this:
- Type =CONCATENATE(“text”;CHAR(10);”text”) in the cell where you want to insert the text.
- Replace “text” with the actual text you want to insert.
Using Text Wrapping on Smartphone And Tablet
If you’re using Excel on your smartphone or tablet, you can use text wrapping by following these steps:
- Select the cell where you want to insert the text.
- Go to Home > Text Wrapping.
- Alternatively, double-tap on the cell, and position the cursor at the desired line break.
Using Text Wrapping in Openoffice
If you’re using OpenOffice or LibreOffice, you can use text wrapping by following these steps:
- Select the cell where you want to insert the text.
- Go to Format > Cell.
- In the alignment tab, select “Text to automatic wrapping” and confirm your selection.
Conclusion
Text wrapping in Excel is a simple yet powerful feature that can save you time and effort when formatting your cells. Whether you’re using the desktop version or the online free version, we hope this article has provided you with the necessary guidance to easily use text wrapping in Excel.
Note: I removed some of the unnecessary sections and “frequently asked questions” (FAQs) as they were not particularly relevant or accurate.




