How to Find the Excel 2013 Formatting Toolbar Buttons Equivalents

Finding the Excel 2013 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 displayed prominently on the Home tab of the Ribbon. They're all easy to identify because they use the same icons as before and are located in the Font, Alignment, or Number group on the Home tab.

1

Identify the buttons in the Font 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 Size button bumps up the current font size a point.

Decrease Font Size button reduces the current font size by a point.

2

Identify the buttons in the Alignment group on the Home tab.

In addition to the Align Left, Center, Align Right, Decrease Indent, Increase Indent, and Merge & Center buttons, the Alignment group also contains the following buttons:

Top Align button vertically aligns the data entered into the current cell selection with the top edge of the cell.

Middle Align button vertically centers the data entered into the current cell selection.

Bottom Align button aligns the data entered in the current cell selection with the bottom edge of the cell.

Orientation button 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, or rotating it up or down) and open the Alignment tab of the Format Cells dialog box.

Wrap Text button applies wrap text to the current cell selection so that Excel expands the row heights as needed to fit all its text within the current column widths.

3

Identify the buttons in the Number group on the Home tab.

In addition to the Percent Style, Comma Style, Increase Decimal, and Decrease Decimal buttons from the Formatting toolbar, the Numbers group contains the following buttons:

Accounting Number Format button 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 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.

blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.