If you want to know how to wrap text in Excel, we’ve got you covered right here.
Keeping spreadsheets, tables, and charts in Microsoft Excel organized and professional can be a challenge. However, there are a few features that can help you keep everything neat, such as Wrap Text. This option will split extra-long text into multiple lines so that you can see all of it clearly without having to change the text or cell size.
So, without wasting another second, let’s check out how to wrap text in Excel.
How to wrap text in Excel through a button
The best way to wrap text in Excel is by using a dedicated button.
Step
Select the cell
The first thing you need to do is select the cell which has the text that needs to be wrapped.
Step
Click on Wrap Text
Then, go to the Home tab, and click on Wrap Text, which can be found in the Alignment box.
This will wrap the text.
How to wrap text in Excel through Format options
Alternatively, if the Wrap Text button is not working for some reason, you can try doing it through the Format options.
Step
Press Ctrl + 1
After selecting the cell with the text, press CTRL + 1 on your keyboard.
Step
Check the Wrap Text box
Next, go to the Alignment tab, check the box next to Wrap Text, and click OK.
Final thoughts
Above are a few options to help you wrap text in Excel, which can be used to make the sheet look organized and professional. Both methods work flawlessly, but we’d recommend using the Warp Text button, as the second method requires you to go through a few extra steps.
If you want to learn more about Excel and its features, give these helpful guides a read:
