How to Insert a Link to Send an E-mail in an Excel 2007 Workbook
Changing Excel 2007’s Default Font and Font Size
Inserting Decimal Points Automatically in Excel 2007

Finding the Formatting Toolbar Button Equivalents in Excel 2007

Finding the Excel 2007 Ribbon equivalents for the buttons that were on the Formatting toolbar in earlier versions of Excel is easy. Each button on the Formatting toolbar is prominently displayed on the Home tab of the Excel 2007 Ribbon. They’re all easy to identify because they use the same icons as before and are located in the Font, Alignment, and Number groups on the Home tab.

Find the Formatting toolbar button equivalents on the Home tab of the Ribbon.
Find the Formatting toolbar button equivalents on the Home tab of the Ribbon.

The Ribbon's Font group

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.

The Ribbon's Alignment group

The Alignment group of the Home tab includes the Left Align, Center, Right Align, Decrease Indent, Increase Indent, and Merge and Center buttons from the Formatting toolbar of earlier versions, as well as the following new 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, turning the text 90 degrees, 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.

The Ribbon's Numbers group

The Numbers contains the Percent Style, Comma, Increase Decimal, and Decrease Decimal buttons from the Formatting toolbar, as well as these new 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, and lets you open the Number tab of the Format Cells dialog box if you need more choices.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Applying Conditional Formatting in Excel 2007
Copying Excel 2007 Formatting with Format Painter
Formatting Dates in Excel 2007
How to Insert a Hyperlink to a File or Web Site in Excel 2007
How to Insert a Hyperlink to a Different Cell in an Excel 2007 Workbook
Advertisement

Inside Dummies.com