Microsoft Office Tutorials and References
In Depth Information
Adjusting Columns and Rows
One of the easiest and most effective
ways to make sure your worksheet is legible and
simple to view is to make sure there’s enough
room for your data. Cramped columns and rows
make it hard to read your worksheet content, so
give everything enough elbowroom. As shown in
Figure 5-1, where you see two worksheets with
identical information side by side, it’s easy to
see which one is easier to absorb by someone
viewing the data.
Changing Column Width
To change column width—making the column
wider or narrower, whichever is appropriate—
here are your options:
Double-click. Take your mouse and point
to the seam, as shown in Figure 5-2,
between the column letters at the top
of the column you want to widen and
the one to its right. When your mouse
pointer turns to a two-headed arrow,
double-click. The column is automatically
adjusted to the width of the widest entry
in that column.
Point to this seam and
double-click to adjust the
left column automatically
measurement for this
column appears here
The worksheet on the left is cramped and crowded.
Its companion on the right is spread out
just enough so that everything is easy to read.
Of course, you don’t want to spread everything
out too much, because for worksheets that will be
printed, this can waste paper and make reading
the printed data too difficult, with columns and
rows that fall on all the unnecessary additional
pages. Your goal is to provide enough room for
the data to be legible, in print or onscreen.
Use your mouse to double-click or drag
the columns to the desired width.