How do you wrap long column headings to the next line in the same cell?
Format the cell to wrap text.In Excel 2007:Click on the cell or highlight the range of cells you want to format.From the Home tab on the ribbon bar, select Format from the Cells section.In the Format menu, click on Format Cells.Click on the Alignment tab.In the Text Control section, click in the box in front of Wrap text.Click OK.In Excel 2003 or earlier:Click on the cell or highlight the range of cells you want to format.On the Format menu, click Cells.Click the Alignment tab.Under Text control, select the Wrap text check box.Click OK.