Here's our Microsoft Office Tip for.. February 24, 2003
Click Here to see a complete list of all of our previously released Tips!
Display Multiple Lines of Data in Same Cell
Most of the time our entries are short and sweet--either a value or a short string. Occasionally, though, you may want to display multiple lines of data in the same cell. Fortunately, there are two ways to do it.
Use a line break by pressing Alt-Enter to begin a new line, or format the cell by selecting it and then choosing Format, Cells; clicking the Alignment tab, and selecting Wrap Text. The data you enter will wrap to fit the cell's width.