Microsoft Office Tutorials and References
In Depth Information
Calibrating Columns
through their column letters on the frame; if they don’t, hold down the Ctrl
key while you click the individual column letters). After you select the
columns, double-click any of the right borders on the frame.
Best-fit à la AutoFit doesn’t always produce the expected results. A long title
that spills into several columns to the right produces a very wide column
when you use best-fit.
When AutoFit’s best-fit won’t do, drag the right border of the column (on the
frame) until it’s the size you need instead of double-clicking it. This manual
technique for calibrating the column width also works when more than one
column is selected. Just be aware that all selected columns assume whatever
size you make the one that you’re actually dragging.
You can also set the widths of columns from the Format button’s drop-down
list in the Cells group on the Home tab. When you click this drop-down
button, the Cell Size section of this drop-down menu contains the following
width options:
Column Width to open the Column Width dialog box where you enter
the number of characters that you want for the column width before you
click OK
AutoFit Column Width to have Excel apply best-fit to the columns based
on the widest entries in the current cell selection
Default Width to open the Standard Width dialog box containing the
standard column width of 8.43 characters that you can apply to the
columns in the cell selection
Rambling rows
The story with adjusting the heights of rows is pretty much the same as that
with adjusting columns except that you do a lot less row adjusting than you
do column adjusting. That’s because Excel automatically changes the height
of the rows to accommodate changes to their entries, such as selecting a
larger font size or wrapping text in a cell. I discuss both of these techniques
in the upcoming section “Altering the Alignment.” Most row-height
adjustments come about when you want to increase the amount of space between a
table title and the table or between a row of column headings and the table of
information without actually adding a blank row. (See the section “From top
to bottom,” later in this chapter, for details.)
Search JabSto ::

Custom Search