If you need to enter text that is too wide for your column, and you don’t want to split it into several rows, text wrapping is your answer. When you turn on text wrapping, long pieces of text wrap around to the next line within a cell and the cell height  adjusts automatically. You may want to do this anywhere on a spreadsheet, but it it especially common for column headings.

To turn this option on, highlight the cell or cells you want to format (often it’s best to select an entire row or column) then right click on the selected area and choose Format Cells. On the Alignment tab, check the box next to Wrap Text. While you are here, you can also choose to set the vertical alignment to top, center or bottom. That way you can control the appearance of other cells in the same area that don’t need the full height of the cell to display their text.

You can also use the Wrap Text button that is in the Alignment section of the Home ribbon. The buttons for top, center, and bottom vertical alignment are to the left of the wrap text button.

When you turn on text wrapping, Excel will automatically start a new line wherever needed. But it you want to wrap text (insert a line break) at a specific position, such as if you want to hyphenate a long word, you can use Alt+Enter at any time to start a new line within the same cell.

[Facebook] [LinkedIn] [StumbleUpon] [Twitter]