Section 6 - Multiple Lines of Text in a Cell

Sometimes, text is too wide to fit inside a cell. One way to accommodate the text is to increase the width of the columns. Another option, however, is to wrap the text in the cell. This creates multiple lines of text in a cell, and allows you to view all the text in the cell without changing the column width.

• In Excel XP or MAC Excel 2004, to wrap the text in a cell, click in the cell(s) where you want multiple lines of text. From the Format menu choose Cells and select the Alignment tab. Check the box next to "Wrap Text". When you type text in the cell(s) it will wrap AFTER you press Enter or Tab.

• In Excel 2007, to wrap the text in a cell, under the Home tab, click on the Wrap Text icon in the Alignment group.

• Or click on the dialog box launcher icon on the bottom right hand side of the alignment group. The Format Cells dialog box will appear and you can check the Wrap Text check box.