Microsoft Office Tutorials and References
In Depth Information
Controlling the size of cells
AutoFit Column Width This command adjusts column widths in selected cells by
adjusting them to accommodate the widest entry in the column.
Default Width This command displays a dialog box where you can change the
starting column width for all selected worksheets in the current workbook. This has
no effect on columns whose width you have previously specified.
Changing column widths
If the standard column width isn’t enough to display the complete contents of a cell, one of
the following will occur:
Text that is too long runs over into adjacent cells.
Long text entries are truncated at the border if the adjacent cell isn’t empty.
● Long numbers appear in scientific notation (for example, 1.23E+12).
● A series of number signs (#) appears if you assign a numeric format.
To change column widths using the mouse, drag the lines between column headings. As
you drag, the width of the column and the number of pixels appear in a ScreenTip, as
shown in Figure 9-61. This figure also illustrates how to change the width of multiple
columns at the same time: drag to select column headings; alternatively, hold down Ctrl, and
click headings to select nonadjacent columns. Then, when you drag the line to the right of
any selected column, all the selected column widths change simultaneously.
Figure 9-61 The pointer looks like a double-headed arrow when you adjust column width or
row height with the mouse.