Microsoft Office Tutorials and References
In Depth Information
To Adjust the Column Width
To Adjust the Column Width
The last step in formatting the worksheet is to adjust the width of column A so that the word Accessories in
cell A8 is shown in its entirety in the cell. Excel includes several methods for adjusting cell widths and row heights,
and these methods are discussed later in this topic. The following steps adjust the width of column A so that the
contents of cell A8 are displayed in the cell.
1
Point to the boundary on the right
side of the column A heading above
row 1 to change the mouse pointer
to a split double arrow (Figure 1–69).
mouse pointer
is split double
arrow
current right
border of
column A
Figure 1–69
2
Double-click on the boundary to
adjust the width of column A to
the width of the largest item in the
column (Figure 1–70).
What if none of the items in column
A extended through the entire
width of the column?
If all of the items in column A were
shorter in length than the width of
the column when you double-click
the right side of the column A head-
ing, then Excel still would adjust the
column width to the largest item
in the column. That is, Excel would
reduce the width of the column to
the largest item.
mouse
pointer
new column
A width
Figure 1–70
 
 
Search JabSto ::




Custom Search