Microsoft Office Tutorials and References
In Depth Information
Changing the Widths of Columns and Heights of Rows
When Excel starts and displays a blank worksheet on the screen, all of the columns
have a default width of 8.43 characters, or 64 pixels. A character is deﬁ ned as a letter,
number, symbol, or punctuation mark in 11-point Calibri font, the default font used by
Excel. An average of 8.43 characters in 11-point Calibri font will ﬁ t in a cell.
Another measure of the height and width of cells is pixels, which is short for picture
element. A pixel is a dot on the screen that contains a color. The size of the dot is based
on your screen’s resolution. At a common resolution of 1024
Trying to unhide a range
of columns using the
mouse can be frustrating.
An alternative is to use
the keyboard: select the
columns to the right
and left of the hidden
columns and then press
CTRL + SHIFT +) ( RIGHT
PARENTHESIS ). To use the
keyboard to hide a range
of columns, press CTRL + 0
( ZERO ).
768, 1024 pixels appear
across the screen and 768 pixels appear down the screen for a total of 786,432 pixels. It is
these 786,432 pixels that form the font and other items you see on the screen.
The default row height in a blank worksheet is 15 points (or 20 pixels). Recall
from Chapter 1 that a point is equal to 1/72 of an inch. Thus, 15 points is equal to
about 1/5 of an inch. You can change the width of the columns or height of the rows at
any time to make the worksheet easier to read or to ensure that Excel displays an entry
properly in a cell.
When changing the column width, you can set the width manually or you can instruct Excel to size the column
to best ﬁ t. Best ﬁ t means that the width of the column will be increased or decreased so the widest entry will ﬁ t in the
column. Sometimes, you may prefer more or less white space in a column than best ﬁ t provides. Excel thus allows you
to change column widths manually.
When the format you assign to a cell causes the entry to exceed the width of a column, Excel automatically
changes the column width to best ﬁ t. If you do not assign a format to a cell or cells in a column, the column width
will remain 8.43 characters. To set a column width to best ﬁ t, double-click the right boundary of the column heading
above row 1.
The following steps change the column widths: column A to 14.11 characters; columns B and C to best ﬁ t;
column D to 6.00 characters; columns E, G, and J to 9.00 characters; and columns F, H, and I to 12.67 characters.
• Point to the boundary on the right
side of the column A heading
above row 1.
• When the mouse pointer changes
to a split double arrow, drag until
the ScreenTip indicates Width:
14.11 (134 pixels). Do not release
the mouse button (Figure 2–53).
What happens if I change the
column width to zero (0)?
If you decrease the column width to
0, the column is hidden. Hiding cells
is a technique you can use to hide
data that might not be relevant to
a particular report or sensitive data
that you do not want others to see.
To instruct Excel to display a hidden
column, position the mouse pointer
to the right of the column heading
boundary where the hidden column
is located and then drag to the right.
dotted line shows
border of column A
current right border
of column A