Microsoft Office Tutorials and References
In Depth Information
Joan notes that some of the column titles in the second table are long. For example, the
“Cost per Unit” label in cell C22 is much longer than the values below it. This formatting
has caused some of the columns to be wider than they need to be. Another problem is that
the text for some cells has been truncated because the columns are not wide enough. Joan
suggests that you wrap the text within the column titles and then change the width of the
columns where necessary. To make this change, you will use the Format Cells dialog box.
To have Excel automatically wrap text within a cell:
1. Select the range A22:H22 .
2. Click Format on the menu bar, and then click Cells to open the Format Cells dialog box.
3. Make sure that the Alignment tab is selected, select the Wrap text check box in the Text
control pane, and then click the OK button. The text in many of the selected cells now
appears on two rows within the cells.
4. Change the width of columns A and D to about 12 characters ( 89 pixels) each, columns B
and C to about 10 characters ( 75 pixels) each, columns F and G to about 13 characters
( 96 pixels) each, and column H to about 17 characters ( 124 pixels) each. See Figure 3-12.
Wrapping text and resizing the worksheet columns
Trouble? If your screen does not match Figure 3-12, resize the columns so the values are
easy to read. If some of the text is still hidden, you may need to resize the height of row 22
by dragging the bottom row border down (see Tutorial 1 for a description of resizing rows