Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
Conditional Formatting Operators
As shown in Figure 2 – 49 on page EX 105, the second text box in the New Formatting
Rule dialog box allows you to select a relational operator, such as less than, to use in the
condition. The eight different relational operators from which you can choose for conditional
formatting in the New Formatting Rule dialog box are summarized in Table 2–5.
Table 2 – 5 Summary of Conditional Formatting Relational Operators
Relational Operator
Description
between
Cell value is between two numbers.
not between
Cell value is not between two numbers.
equal to
Cell value is equal to a number.
not equal to
Cell value is not equal to a number.
greater than
Cell value is greater than a number.
less than
Cell value is less than a number.
greater than or equal to
Cell value is greater than or equal to a number.
less than or equal to
Cell value is less than or equal to a number.
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. These values may change depending
on the theme applied to the workbook. For example, in this chapter, the Trek theme was
applied to the workbook, resulting in columns having a default width of 8.11 characters. A
character is dei 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 i 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 the resolution of 1024 × 768 used in this topic,
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.
Hidden Rows and
Columns
For some people, 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 ). You also can use
the keyboard to unhide a
range of rows by selecting
the rows immediately
above and below the
hidden rows and then
pressing CTRL + SHIFT +( ( LEFT
PARENTHESIS ). To use the
keyboard to hide a range
of rows, press CTRL + 9 .
To Change the Widths of Columns
When changing the column width, you can set the width manually or you can instruct Excel to size the
column to best i t. Best i t means that the width of the column will be increased or decreased so that the widest
entry will i t in the column. Sometimes, you may prefer more or less white space in a column than best i t provides.
To change the white space, Excel 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 i 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 i t, double-click the right boundary of the column heading
above row 1.
The steps on the following pages change the column widths: column A, B, and C to best i t; column H to
10.22 characters; and columns D, E, and J to 7.56 characters.
Search JabSto ::




Custom Search