If you had entered some text in a cell and later discovered that part of text has been truncated due to too much wide text. To correct this, you may wrap the text in the cell. To wrap the text, perform the following:
1. Select the cell that you need to wrap the text.
2. From the Home tab, in the Alignment section click Wrap Text.
Now the text will be displayed in multiple lines. Note that the row height will also be increased.
The above provided way is the quickest way to wrap text in a cell. You may also perform the same operation by performing the following steps:
1. Right-click on the cell that you need to wrap the text and then click Format Cells... to open the Format Cells dialog box.
2. Click the Alignment tab. In the Text control section, click to place a check mark beside Wrap text.
3. Click OK.
Tuesday, February 23, 2010
Subscribe to:
Post Comments (Atom)
