Whenever you enter a textual content string in Excel which exceeds the width of the cell, you possibly can see the textual content overflowing to the adjoining cell(s).
Under is an instance the place I’ve some handle in column A and these handle overflow to the adjoining cells as properly.
And in case you may have some textual content within the adjoining cell, the in any other case overflowing textual content would disappear and you’ll solely see the textual content that may match the cell column width.
In each instances, it doesnt look good and you might need to wrap the textual content in order that the textual content stays inside a cell and never spill over to others.
This may be accomplished utilizing the wrap textual content function in Excel.
On this tutorial, I’ll present you numerous methods of wrapping textual content in Excel (together with doing it robotically with a single click on, utilizing a components and doing it manually)
So lets get began!
Wrap textual content with a Click on
Since that is one thing you might have to do very often, there may be easy accessibility to rapidly wrap the textual content with a click on on a button.
Suppose you may have the dataset as proven beneath the place you need to wrap textual content in column A.
Under are the steps to do that:
Choose the whole dataset (column A on this instance)Click on the Dwelling TabWithin the Alignment group, click on on the Wrap textual content button.
All it takes it two-click to rapidly wrap the textual content.
You’ll get the ultimate outcome as proven beneath.
You possibly can additional convey down the hassle from two to one-click by including the Wrap textual content choice to the Fast Entry Toolbar. To do that. right-click on the Wrap textual content possibility and click on on Add to Fast Entry Toolbar
This provides an icon to the QAT and if you need to wrap textual content in any cell, simply choose it and click on this icon within the QAT.
Wrap textual content with a Keyboard Shortcut
In case youre like me, leaving the keyboard and utilizing a mouse to click on even a single button might really feel like a waste of time.
Excellent news is that you should utilize the beneath keyboard shortcut to rapidly wrap textual content in all the chosen cells.
ALT + H + W (ALY key adopted by the H and W keys)
Wrap textual content with the Format Dialog field
That is my least most popular methodology, however there’s a cause I’m together with this one on this tutorial (as it may be helpful in a single particular state of affairs).
Under are the steps to wrap the textual content utilizing the Format dialog field:
Choose the cells for which you need to apply the wrap textual content formattingClick the Dwelling tabIn the Alignment group, click on on the Alignment Setting dialog field launcher (its a small tilted arrow in a field icon on the backside proper of the group).Within the Format Cells dialog field that opens, choose Alignment tab (if not chosen already)Choose the Wrap textual content possibilityClick on OK.
The above steps would wrap the textual content within the chosen cells.
Now when youre considering why to make use of this twisted lengthy methodology when you should utilize a keyboard shortcut or a single click on on the Wrap Textual content button within the ribbon.
Usually, you shouldn’t be utilizing this methodology, however it may be helpful if you need to change a few formatting settings. Because the Format Dialog field offers you entry to all of the formatting choices, this may occasionally find yourself saving you a while.
NOTE: You may as well use the keyboard shortcut Management + 1 to open the Format Cells dialog field.
How Does Excel Resolve How A lot textual content to Wrap
Whenever you use the above methodology, Excel makes use of the column width to resolve what number of strains you get after wrapping.
Doing this makes positive that something that you’ve got within the cell is confined throughout the cell itself and doesnt overflow.
In case you modify the column width, the textual content can even regulate to make sure it matches the column width robotically.
Inserting Line Break (Manually, Utilizing Formulation, or Discover and Substitute)
Whenever you apply Wrap Textual content to any cell, Excel determines the road breaks primarily based on the width of the column.
So if there may be textual content which might match within the current column width, it is not going to be wrapped, however in case it cannot, Excel will insert the road breaks by first becoming the content material within the first line after which transferring the remainder to the second line (and so forth).
By getting into a line break manually, you drive Excel to maneuver the textual content to the subsequent line (in the identical cell) proper after the road break is inserted.
To enter the road break manually, comply with the beneath steps:
Double-click on the cell through which you need to insert the road break (or press F2). It will get you into the edit mode within the cellPlace the cursor the place you need the road break.Use the keyboard shortcut ALT + ENTER (maintain the ALT key after which press Enter).
Notice: For this to work, it’s essential to have Wrap Textual content enabled on the cell. If Wrap Textual content just isn’t enabled, you will notice all of the textual content in a single single line, even when you’ve got inserted the road break.
You may as well use a CHAR components to insert a line break (in addition to a cool Discover and Substitute trick to interchange any character with a line break).
Each of those strategies are coated on this brief tutorial on inserting line breaks in Excel.
Dealing with Wrapping Too A lot Textual content
Generally you might have a whole lot of textual content in a cell and if you wrap the textual content, it might find yourself making your row top massive.
One thing as proven beneath (the textual content is taken for bookbrowse.com):
In such a case, you might need to regulate the row top and make it constant. The draw back of that is that not all of the textual content within the cell will probably be seen, but it surely makes your worksheet much more usable.
Under are the steps to set the row top of the cells:
Choose the cells for which you need to change the row heightClick the Dwelling tabIn the Cells group, click on on the Format possibilityClick on on Row TopWithin the Row Top dialog field, enter the worth. I’m utilizing the worth 40 on this instance.Click on OK
The above steps would change the row top and make all of it constant. In case any of the chosen cells have textual content which cannot be slot in a cell with the required top, it will likely be minimize from the underside.
Dont fear, the textual content would nonetheless be within the cell. It simply receivedt be seen.
Excel Textual content Wrap Not Working Attainable Options
In case you discover that the Wrap textual content possibility just isn’t working as anticipated and you continue to see the textual content as a single line within the cell (or with some lacking textual content), there may very well be just a few doable causes:
Wrap Textual content just isn’t enabled
Since it really works as a toggle, rapidly test whether or not its enabled or not.
If its enabled, you will notice that this selection is highlighted within the Dwelling tab
Cell top must be adjusted
When Wrap Textual content is utilized, it strikes the additional strains beneath the primary line within the cell. In case your cell row top is much less, you might not see the whole wrapped textual content.
In that case, it’s essential to regulate the cell top.
You modify the row top manually by dragging the underside fringe of the row.
Alternatively, you should utilize the AutoFit Row Top. This selection is on the market within the Dwelling tab in Format choices.
To make use of the AutoFit possibility, choose all of the cells that you simply need to auto-fit and click on on the AutoFit Row Top possibility.
The Column Width is Already Vast sufficient
And typically there may be nothing improper.
When your column width is vast sufficient, there is no such thing as a cause for Excel to wrap the textual content because it already matches the cell in a single line.
In case you continue to need the textual content to separate into a number of strains (regardless of having sufficient column width), it’s essential to insert the road break manually.
Hope you discovered this tutorial helpful.
You might also like the next Excel tutorials: