Friday, July 31, 2009

Multiple lines in a single Excel field

http://8help.osu.edu/3290.html

In Microsoft Excel, it is possible for a single cell to include multiple lines, or a list of items - however, there is no automatic way to do so.

To accomplish this:
  1. Select the cell which will hold the list/multiple lines.
  2. Go to the Format pull-down menu and Select Cells.
  3. Go to the "Alignment" tab.
  4. Under "Text Control", click "Wrap Text".
  5. Click OK to apply the changes & close the window.
  6. Now, within the selected cell, type the text to include. For each end-of-line or separate list item, press the Alt and Enter keys simultaneously (Command+Alt+Return on a Macintosh). This will begin a new line within the same cell.
  7. If you wish, you may also add bullet points for your list.
[img]http://8help.osu.edu/image.php/239[/img]

No comments:

Post a Comment