Microsoft Office Tutorials and References
In Depth Information
Working with Alignment and Spacing
If a label does not fit into the cell, the contents
spill into the next cell to the right, if the next cell
is empty. If the next cell is not empty, Excel
displays only the amount of text that fits into the cell.
The extra text is not cut off, it’s just not displayed.
If a value is too wide, Excel may do one of several
Display the number in scientific notation so
it displays in fewer characters.
Automatically widen the cell.
Round the value’s decimal points.
Display the data as a series of number signs
The following steps show you how you can widen a
Manually changing column width.
To adjust the width of columns headings,
select the headings of the columns you want
widened. If you want to adjust a single
column, click any cell in that column or select
the column heading.
Excel displays cell width in characters and
pixels instead of inches. The minimum
column width is 0 characters, and the
maximum is 255 characters.
2. Choose a method to adjust column width:
To manually change the width of
columns, position the mouse pointer
on the right boundary of the column
heading until it turns into a
doubleended arrow. Drag until the column is
the width that you want. As you move
the pointer, a ScreenTip displays the
new width. In Figure 10-10 you see the
expansion of column A.
To set column width to a specific
setting, choose Home>Cells>Format>
Column Width. The Column Width
dialog box, shown in Figure 10-11,
appears. Type the exact width you
want; then click OK.