Microsoft Office Tutorials and References
In Depth Information
Adjusting Columns and Rows
Click and drag. Again pointing to the
same seam shown in Figure 5-2, when
your mouse pointer turns to a two-headed
arrow, drag. Drag to the right to widen
the column or to the left to narrow it.
The AutoFit Column Width command
in the Home tab’s Format button menu
does the same thing as double-clicking
the column letter seam. Just select the
columns first and then make the button
Use the Format button menu to choose
how to adjust your column width.
Use the Ribbon. If you prefer a more
methodical approach, select the columns
you want to adjust, use the Cells group
of the Home tab, and click the Format
button. In the menu displayed in Figure
5-3, choose Column Width and then use
the dialog box shown in Figure 5-4 to
adjust the column’s width to a specific
measurement. The number displayed when
you open the dialog box is the current
number of characters at the default point
size that the cells in that column will
house. The higher the number you enter,
the wider the column will be.
Enter a value to widen or narrow
the selected column.
Don’t remember how to select a column
or series of columns? Click the column
letter to select an individual column,
or drag through the column letters of a
series to select several contiguous columns
all at once. If you want to select multiple
but non-contiguous columns, press and
hold the Ctrl key as you click each
desired column’s letter.