A normal Excel sheet has cells that are 8.43 points in width and 15 points in height. This is usually about 64 pixels wide and 20 pixels tall.
Bạn đang xem: 4 ways to wrap text in excel
If your text data is long, you can increase the cell width to fit the data length.
A better option might be to wrap the text to increase the row height so the data fits in the cell instead!
In this post you’ll learn 3 ways to wrap your text data to fit it inside the cell.
What is Text Wrap?
This means that if text is too long to fit inside its cell, it will automatically adjust to appear on multiple lines within the cell.
The data inside the cell will not change and no line break characters will be inserted. It will only appear to be formatted on multiple lines.
You can open this menu with a right click on the cells then choose Format Cells or by using the Ctrl + 1 keyboard shortcut.
Go to the Alignment tab in the menu ➜ Check the Wrap text option in the Text control section ➜ then press the OK button.
This is a great option when you want to apply wrap text and other formatting options at the same time.
Automatically Adjust Row Height to Fit Text
If your row height does not properly adjust to fit all the text and is either too small or too big, then you will need to adjust it.
You can do this manually by clicking and dragging the row but there is an easy option to auto-adjust the height.
Go to the Home tab ➜ select the Format options ➜ then select AutoFit Row Height from the menu. You can also do this by double clicking on the edge of the row heading.
The row height will adjust to the exact height needed to show all the text.
Manually Add Line Breaks to Wrap Your Text
The wrap text option will automatically format your text with line breaks based on the available width of the cell.
If you want to choose where the line breaks appear, then you can do this by manually adding line break characters to your text data.
Place the cursor in the text at the point where you want to add a line break then hold the Alt key and press Enter.
This will add a line break character into your text data and the data will appear on multiple lines in the sheet.
Remove Wrap Text
It’s just as easy to remove wrap text formatting as it is to apply it in the first place.
Select the cells from which you want to remove the formatting and then perform any of these methods.Go to the Home tab and press the Wrap Text command.Open the Format Cells menu and uncheck the Wrap text option in the Alignment tab.Use the Alt ➜ H ➜ W keyboard shortcut.
The exact same commands used to apply the formatting can be used to remove the formatting as well!
Remove Manually Added Line Breaks
If you’ve manually added line break characters to your text to achieve a wrapping effect, then you will need to remove them using a find and replace method.
Press Ctrl + H to open the find and replace dialog box.
Place the cursor in the Find what section and press Ctrl + J to add a line break character. Leave the Replace with section empty and then press the Replace All button.
This will replace all the line break character that you manually added by nothing thereby removing them.
Wrapping text is a great option for styling your spreadsheets and making them more readable.
It’s great too, because it’s very easy to do.
What’s your favourite method? Let me know in the comments!
About the Author
John is a Microsoft MVP and freelance consultant and trainer specializing in Excel, Power BI, Power Automate, Power Apps and SharePoint. You can find other interesting articles from John on his blog or YouTube channel.
Browse All Posts
7 Ways to Rename a Sheet in Microsoft Excel
Sep 25, 2021
Keeping your spreadsheet organized is important! A well organized spreadsheet...
8 Ways to Merge Cells in Microsoft Excel
Sep 8, 2021
Merged cells are one of the most popular options used by beginner spreadsheet...
6 Ways to Count Colored Cells in Microsoft Excel
Sep 7, 2021
You have probably used color coding in your Excel data or seen it in a...
Submit a Comment Cancel reply
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.
Notify me of follow-up comments by email.
Notify me of new posts by email.
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Get The Latest News
Follow us on social media to stay up to date with the latest tips in Excel!