Microsoft Office Tutorials and References
In Depth Information
You’ll use the drag technique to increase the width of the columns in which the data
display has been truncated. As you drag the dividing line, a ScreenTip appears and dis-
plays the column width in characters and pixels.
To change the width of columns in the worksheet:
1. Move the mouse pointer to the dividing line between the column A and column B headings
until the pointer changes to
2. Click and drag the pointer to the right to a length of about 20 characters (or 145 pixels ).
See Figure 1-17.
Increasing the width of column A
pointer changes shape over
the column dividing line
3. Release the mouse button. All the names in column A should now be visible.
Trouble? If the text in column A is still truncated, drag the dividing line further to the right.
4. Move the mouse pointer to the dividing line between column B and column C until the
pointer changes to
, and then increase the width of column B to 25 characters (or
5. Use your mouse to increase the width of column D to 15 characters (or 110 pixels).
Changing the width of the columns does not affect the height of the rows. However,
now that column A is wider and the rows are taller, there is a great deal of empty space.
To remove the empty space, you’ll resize the rows. Rather than choosing a size for the
rows, you’ll let Excel make the adjustment automatically. If you double-click the dividing
line of a column or row heading, the column width or row height adjusts to match the
length of the longest entry in that column or row. You’ll use this technique now to modify
the height of the second row in the worksheet.
To change the height of the second row:
1. Move the mouse pointer to the dividing line between the second and third rows until the
pointer changes to
2. Double-click the dividing line between the second and third rows. See Figure 1-18.