Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
1 ENTER TEXT | 2 CALCULATE SUMS & USE FORMULAS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
To Adjust the Column Width
The last step in formatting the worksheet is to adjust the width of the columns so that all the titles can
be seen clearly. Why? To make a worksheet easy to read, the column widths should be adjusted appropriately. Excel
includes several methods for adjusting cell widths and row heights, and these methods are discussed later in
this book. The following steps adjust the width of columns A through N so that the contents of the columns
are seen clearly.
• If you are using a mouse, point
to the boundary on the right side
of the column A heading above
row 1 to change the pointer to a
split double arrow (Figure 1– 50).
pointer changes to
split double arrow
Figure 1– 50
• If you are using a mouse,
doubleclick the boundary to adjust the
width of the column to the width
of the largest item in the column
(Figure 1– 51).
What if none of the items in
column A extends 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-tap or double-click
the right side of the column A
heading, 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.
column A resized
Figure 1– 51