How to Wrap Excel 2007 Data to See All the Text

Use the Wrap Text button on the Home tab of Excel 2007 to wrap lengthy text in a cell by displaying it on multiple lines within the cell. This feature helps you avoid the problem of having to abbreviate text or widen columns in order to display all the text contained within cells.

When you select Wrap Text, Excel continues to use the horizontal and vertical alignment you specify for the cell.

Follow these steps to wrap text in cells:

  1. Select the cells containing text you want to wrap.

  2. Click the Wrap Text button in the Alignment group on the Home tab.

    To accommodate more than one line in a cell, Excel 2007 automatically expands the row height so that all wrapped-text entries are visible.

    A new worksheet with the column headings formatted with the Wrap Text option.
    A new worksheet with the column headings formatted with the Wrap Text option.

You can manually break a long text entry into separate lines by positioning the insertion point in the cell entry (or on the Formula bar) at the place where you want the new line to start and pressing Alt+Enter. Excel expands the row containing the cell (and the Formula bar above) when it starts a new line. When you press Enter to complete the entry or edit, Excel automatically wraps the text in the cell, according to the cell’s column width and the position of the line break.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com