Datasheet

Ribbon. They’re all easy to identify as they use the same icons as before and

are located in the Font, Alignment, or Number group on the Home tab (refer to

Figure 1-3).

In addition to the Font, Font Size, Bold, Italic, Underline, Borders, Fill Color,

and Font Color buttons from the Formatting toolbar, the Font group also con-

tains the following two buttons:

 Increase Font button that bumps up the current font size a point

 Decrease Font button that reduces the current font size by a point

In addition to the Left Align, Center, Right Align, Decrease Indent, Increase

Indent, and Merge and Center buttons, the Alignment group also contains

the following buttons:

 Top Align button that vertically aligns the data entered into the current

cell selection with the top edge of the cell

 Middle Align button that vertically centers the data entered into the

current cell selection

 Bottom Align button that aligns the data entered in the current cell

selection with the bottom edge of the cell

 Orientation button that opens a pop-menu of orientation options that

enable you to change the direction of the text entered into the current

cell selection by angling it up or down, converting it to vertical text,

rotating it up or down as well as opening the Alignment tab of the

Format Cells dialog box

 Wrap Text button that applies the wrap text function to the current cell

selection so that Excel expands the row heights as needed to fit all of its

text within the current column widths

In addition to the Percent Style, Comma, Increase Decimal, and Decrease

Decimal buttons from the Formatting toolbar, the Numbers group contains

the following buttons:

 Accounting Number Format button that enables you to select among

several different currency formats from U.S. dollars to Swiss Francs as

well as to open the Number tab of the Format Cells dialog box with the

Accounting number format selected

 Number Format button that opens a pop-up menu of different number

options from General through Text as well as opens the Number tab in

the Format Cells dialog box when you select its More Number Formats

option

Part I: Getting In on the Ground Floor

05_037377 ch01.qxp 11/16/06 9:23 AM Page 44