Wednesday, November 2, 2016

Excel tip: Wrap Text

Here is one I see a lot. When you want to shorten the column and there are two words in the header. I have seen 2 rows used for the header. 

No need to do this, use Wrap Text.
If you want text to appear on multiple lines in a cell, you can format the cell so that text wraps automatically, or you can enter a manual line break.
Wrap text automatically:  Select the cells you want to format.  On the Ribbon on the Home tab, click the wrap text icon.

Enter a line break manually: To start a new line of text at a specific point in a cell, click where you want to break the line, and then press ALT+ENTER.
Note:   If all wrapped text is not visible, it may be because the row is set to a specific height. Data in the cell will wrap to fit the column width and row height. You may need to adjust the row height to see all text. 

No comments:

Post a Comment