Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
1
Drag through
column headings
A and B above
row 1 to select the
columns.
Tap or point to
the boundary on
the right side of
column heading B to
cause the pointer
to become a split
double arrow
(Figure 2 – 50).
columns selected
pointer
What if I want to
make a large change
to the column
width?
If you want to
increase or decrease
column width
signicantly, you can
press and hold or
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 – 50
2
Double-tap or
double-click the
right boundary of
column heading B to
change the width of
the selected columns
to best t.
pointer on
right boundary
of column G
Tap or point to the
right boundary of the
column G heading
above row 1.
ScreenTip shows
proposed column
width
When the pointer
changes to a split
double arrow, drag
until the ScreenTip
indicates Width:
10.25 (87 pixels). Do
not lift your nger
or release the mouse
button (Figure 2 – 51).
Figure 2 – 51
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.
 
Search JabSto ::




Custom Search