Microsoft Office Tutorials and References
In Depth Information
Controlling the size of cells
Controlling the size of cells
The primary methods you use to control the size of cells are adjusting the row height and
changing the column width. In addition, you can adjust the size of cells by merging several
cells into one or by unmerging previously merged cells. The Format menu, located in the
Cells group on the Home tab, is the central command location for cell sizing, as shown in
Figure 9-60.
Figure 9-60 You can use the Cell Size commands on the Format menu to manage row height
and column width.
Here are the options you can use:
Column Width and Row Height These two commands display a dialog box where
you can type a different value to be applied to selected cells. Column width is limited
to 255, and row height can be up to 409. The default column width for Excel is 8.43
characters; however, this does not mean each cell in your worksheet can display 8.43
characters. Because Excel uses proportionally spaced fonts (such as Arial) as well as
fixed-pitch fonts (such as Courier), different characters can take up different amounts
of space. A default-width column, for example, can display about eight numerals in
most 10-point fixed-pitch fonts.
AutoFit Row Height This command adjusts the row height in selected cells by
adjusting them to accommodate the tallest item in the row. (Row height is usually
self-adjusting based on font size.)
Search JabSto ::




Custom Search