Microsoft Office Tutorials and References
In Depth Information
Changing the Widths of Columns and Heights of Rows
4
Release the
mouse button.
ScreenTip shows
proposed column width
column widths of
E, G, and J set to
9.00 characters
Click the
column F heading
above row 1 to
select column F.
While holding
down the CTRL key,
click the column H
heading and then
the column I
heading above
row 1, to select
columns F, H, and I.
mouse pointer
Point to the
boundary on the
right side of the
column I heading
above row 1.
columns F, H,
and I selected
Drag to the left
until the ScreenTip
indicates Width:
12.67 (121 pixels).
Do not release
the mouse button
(Figure 2–56).
dotted line shows
proposed right
border of column I
Figure 2–56
5
Release the
mouse button.
widths of columns
E, G, and J set to
9.00 characters
width of column A set
to 14.11 characters
width of columns B
and C set to best fi t
width of column D
set to 6.00 characters
Point to the
boundary on the
right side of the
column D heading
above row 1.
widths of columns F,
H, and I set to 12.67
characters
Drag to the left
until the ScreenTip
indicates Width: 6.00
(61 pixels) and then
release the mouse
button to display the
worksheet with the
new column widths.
Figure 2–57
Click cell A18 to deselect
columns F, H, and I (Figure 2–57).
Other Ways
1. Right-click column heading
or drag through multiple
column headings and right-
click, click Column Width on
shortcut menu, enter desired
column width, click OK
button
2. Right-click column heading
or drag through multiple
column headings and right-
click, click Format button on
Ribbon, click Column Width
in Format gallery, enter
desired column width, click
OK button
 
 
Search JabSto ::




Custom Search