MS Excel 2003: Multiple Lines Or Lists In A Single Cell
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:
- Select the cell which will hold the list/multiple lines.
- Go to the Format pull-down menu and Select Cells.
- Go to the "Alignment" tab.
- Under "Text Control", click "Wrap Text".
- Click OK to apply the changes & close the window.
- 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.
- If you wish, you may also add bullet points for your list.
Current Record: 3290
Create Date: 02-20-2007
Last Reviewed: 06-06-2009
Home
