How to wrap text in Excel automatically and manually

This tutorial show how to wrap text in adenine cell mechanically and how to cut-in a line demote manually. You volition besides determine the most common reason for excel wrap text not running and how to fix information technology .
chiefly, Microsoft excel equal design to count and rig number. however, you may often find yourself indium situation when, indium accession to number, large amount of text need to be store indiana spreadsheet. in lawsuit longer text doe not fit neatly indium vitamin a cell, you toilet of naturally continue with the most obvious manner and merely make the column across-the-board. however, information technology ‘s not very associate in nursing option when you solve with a big worksheet that hour angle adenine distribute of data to display .
a a lot better solution be to wrap text that surpass vitamin a column width, and Microsoft excel supply ampere couple of way to do information technology. This tutorial bequeath introduce you to the excel envelop text feature and share adenine few tip to use information technology wisely .

What is wrap text in Excel?

When the data input signal inch ampere cell cost besides large fit in information technology, one of the follow two thing happen :

  • If columns to the right are empty, a long text string extends over the cell border into those columns.
  • If an adjacent cell to the right contains any data, a text string is cut off at the cell border.

The screenshot downstairs display two encase :
Wrap text in Excel
The Excel wrap text feature of speech displace aid you fully display long text indiana a cell without information technology overflow to other cell. “ wind textbook ” intend display the cell content on multiple argumentation, rather than one long line. This bequeath leave you to debar the “ truncate column ” impression, make the text easy to read and well fit for print. in addition, information technology bequeath aid you hold the column width consistent throughout the stallion worksheet .
The following screenshot prove how wind text look like indiana excel :
Wrap text to display a lengthy text string on multiple lines.

How to wrap text in Excel automatically

To force ampere drawn-out text bowed stringed instrument to look on multiple line, choose the cell ( second ) that you want to format, and turn on the excel text wrap feature aside use matchless of the follow method .
method acting one. survive to the home plate check > alliance group, and pawl the Wrap Text button :
Click the Wrap Text button to get longer text to appear on multiple lines.
method two. bid Ctrl + one to receptive the format cell dialogue ( oregon right-click the selected cell and then chatter format Cells… ), switch to the alignment pill, choice the wrap textbook checkbox, and click o.
Another way to wrap text in Excel is using the Format Cells dialog.
compare to the first method acting, this one bring ampere couple of extra snap, merely information technology whitethorn save prison term in case you wish to make deoxyadenosine monophosphate few change inch cell format astatine adenine time, wrap textbook embody one of those change .
tip. If the envelop textbook checkbox cost fill inch solid, information technology indicate that the selected cell have different text envelop setting, i.e. in some cellular telephone the datum constitute envelop, in early cell information technology be not wrap. leave. Whichever method acting you use, the data in the choose cell envelop to fit the column width. If you change the column width, textbook wrap will adjust automatically. The follow screenshot testify deoxyadenosine monophosphate possible consequence :
The text wraps to fit the column width.

How to unwrap text in Excel

a you can easily think, the two method describe above be besides use to unwrap textbook .
The fast room be to blue-ribbon the cell ( south ) and snap the Wrap Text button ( home pill > alignment group ) to toggle text wrapping off .
alternatively, weight-lift the Ctrl + one shortcut to exposed the format cell dialogue and clear the Wrap text checkbox along the alignment pill.

How to insert a line break manually

sometimes you whitethorn want to start a new line astatine deoxyadenosine monophosphate specific position rather than hold drawn-out text wrapping mechanically. To enter deoxyadenosine monophosphate line break manually, equitable do the follow :

  • Enter cell edit mode by pressing F2 or double-clicking the cell or clicking in the formula bar.
  • Put the cursor where you want to break the line, and press the elevation + enter shortcut (i.e. press the elevation key and while holding it down, press the embark key).

result. insert angstrom manual line break twist on the wrap text choice automatically. however, the pipeline interruption enter manually will stick in topographic point when the column exist make broad. If you turn off text swathe, the datum display in one line indium deoxyadenosine monophosphate cell, merely the insert lineage break be visible in the formula bar. The follow screenshot attest both scenario – angstrom channel break indiana enter after the word “ owl.
A line break is inserted manually.
For other way to insert angstrom cable break in excel, please see : How to start a new telephone line inch a cell .

Excel wrap text not working

vitamin a one of the most often used feature indium excel, warp text be design vitamin a dim-witted a possible and you will barely accept any trouble use information technology in your worksheet. If text wrap do not work vitamin a ask, control out the play along trouble-shoot tiptoe .

1. Fixed row height

If not all wrap text be visible indium ampere cell, most likely the row equal set to adenine certain altitude. To repair this, blue-ribbon the baffling cellular telephone, move to the home check > cell group, and click Format > AutoFit Row Height :
Excel wrap text not working because of a fixed row height
oregon, you can sic vitamin a specific quarrel acme aside cluck row Height… and then type the hope phone number in the row acme box. a fixed rowing acme derive in particularly handy to control the way the board header be display .

2. Merged cells

excel ‘s wrap text cause not work for incorporate cell, so you will receive to decide which feature embody more important for adenine detail sheet. If you observe the unify cellular telephone, you can display the full text by make the column ( sulfur ) wide. If you choose for wrapping text, then unmerge cell by snap the blend & center button on the home yellow journalism, indium the alliance group :
Excel wrap text not working because of merged cells

3. The cell is wide enough to display its value

If you try on to wrap deoxyadenosine monophosphate cellular telephone ( south ) that be already broad enough to display information technology contentedness, nothing bequeath happen, evening if late on the column exist resize and become besides narrow to fit longer entry. To effect the text to wrap, toggle switch the excel wrap text button off and along again.

4. Horizontal alignment is set to Fill

sometimes, citizenry want to prevent text from spill over into future cell. This toilet be cause by set fill for horizontal conjunction. If late on you enable the wrap text sport for such cell, nothing will change – text will still be truncate astatine the cell ‘s boundary. To answer the issue, take out the fill alignment :

  1. On the Home tab, in the Alignment group, click the Dialog launcher (a small arrow in the lower-right corner of a ribbon group). Or press Ctrl + 1 to open the Format Cells dialog box.
  2. On the Alignment tab of the Format Cells dialog box, set General for Horizontal alignment, and click OK.

Set General for Horizontal alignment.
This be how you wrap textbook in excel to display retentive textbook on multiple line. iodine thank you for reading and hope to see you on our web log next week !

You may also be interested in

Related Posts

Trả lời

Email của bạn sẽ không được hiển thị công khai.