Library Technology – Reviews, Tips, Giveaways, Freeware

loading...

How to Wrap text in a cell in Excel 2013

Posted In MS office - By Techtiplib on Tuesday, December 18th, 2012 With No Comments »

Microsoft Excel can wrap text so it appears on multiple lines in a cell. You can format the cell so the text wraps automatically, or enter a manual line break.

1. In a worksheet, select the cells that you want to format.
2. On the Home tab, in the Alignment group, click Wrap Text Button image.

tech tips, tips, excel tips, excel 2013, office, ms office, ms excel, wrap text

Notes:

  • Data in the cell wraps to fit the column width, so it you change the column width, data wrapping adjusts automatically.
  • If all wrapped text is not visible, it may be because the row is set to a specific height or that the text is in a range of cells that has been merged.

To make all wrapped text visibly, do the following to manually adjust the row height:

  1. Select the cell or range for which you want to adjust the row height.
  2. On the Home tab, in the Cells group, click Format.
 tech tips, tips, excel tips, excel 2013, office, ms office, ms excel, wrap text
  1. Under Cell Size , do one of the following:
    • To automatically adjust the row height, click AutoFit Row Height.
    • To specify a row height, click Row Height, and then type the row height that you want in the Row height box.

 Tip: You can also drag the bottom border of the row to the height that shows all wrapped text

Enter a line break

You can start a new line of text at any specific point in a cell.

  1. Double-click the cell in which you want to enter a line break.

Keyboard shortcut    You can also select the cell, and then press F2.

  1. In the cell, click the location where you want to break the line, and then press Alt+Enter.

Via Microsoft

More contents in: , , ,

About -

Hey, this blog belongs to me! I am the founder of TechTipLib and managing editor right now. And I love to hear what do you think about this article, leave comment below! Thank you so much…