Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
1
Drag through column
headings A, B, and C
above row 1 to select
the columns.
columns A, B,
and C selected
mouse pointer pointing
to right boundary of
column C
Point to the boundary
on the right side of
column heading C
to cause the mouse
pointer to become
a split double arrow
(Figure 2 – 53).
What if I want to
make a large change
to the column width?
If you want to increase
or decrease column
width signii cantly,
you can right-click a
column heading and
then use the Column
Width command on the shortcut menu to change the column’s width. To use this command,
however, you must select one or more entire columns.
Figure 2 – 53
2
Double-click the right
boundary of column
heading C to change
the width of the
selected columns to
best i t.
mouse pointer pointing
to right boundary of
column H
Point to the boundary
ScreenTip shows
proposed column
width
on the right side of
the column H heading
above row 1.
column widths
A, B, and C set
to best i t
When the mouse
pointer changes
to a split double
arrow, drag until the
ScreenTip indicates
Width: 10.22 (99
pixels). Do not release
the mouse button
(Figure 2 – 54).
What happens if
I change the column
width to zero (0)?
If you decrease the
column width to 0,
the column is hidden. Hiding cells is a technique you can use to hide data that might not
be relevant to a particular report or sensitive data that you do not want others to see. To
instruct Excel to display a hidden column, position the mouse pointer to the right of the
column heading boundary where the hidden column is located and then drag to the right.
dotted line shows
proposed right
border of column H
Figure 2 – 54
 
Search JabSto ::




Custom Search