Microsoft Office Tutorials and References
In Depth Information
Working with Alignment and Spacing
Making Your Worksheet Look Good
Manually change the row height. Position
the mouse pointer on the bottom boundary
of the row heading until it turns into a
double-ended arrow. Drag until the row is the
height that you want. As you move the
pointer, a ScreenTip displays the new
height. In Figure 10-12, you see the height
of row 2 increasing.
The Column Width dialog box.
To automatically change the column
width so it fits the widest entry,
doubleclick the boundary on the right side of
the column heading or choose Home>
Cells>Format>AutoFit Column Width.
The column automatically expands to fit
the widest entry in the column.
Default Column Width
The default column width is 8.43 based on
the default 11-point Calibri font. If you
change the default font type or size, Excel may
also change the standard column width. You
can manually set a default column width by
choosing Home>Cells>Format>Default Width.
Increasing row height manually.
Set row height to a specific setting by
choosing Home>Cells>Format>Row Height. The
Row Height dialog box appears. Type the
exact height you want, and then click OK.
Changing Row Height
When you change to a larger font, Excel usually
enlarges the row height to accommodate the larger
font size. You can also manually resize the row
height. Highlight the row headings whose height
you want to adjust and do one of the following:
To automatically change the height of the
row so it fits the tallest entry in the row,
double-click the boundary on the bottom of
the row heading or choose Home>Cells>
Format>AutoFit Row Height. Excel
examines the rows contents and sets the height
slightly larger than the tallest entry.
Excel displays row height in points instead of