|
Finding the Excel 2007 equivalents for the buttons on the Formatting toolbar in earlier versions of Excel couldn't be easier: Every one of the buttons on the Formatting toolbar is prominently displayed on the Home tab of the Excel 2007 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.
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 contains 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
|
