Page 166 - Excel 2013 All-in-One For Dummies

148 Formatting Cell Ranges with the Mini-Toolbar Formatting Cell Ranges with the Mini-Toolbar
Excel 2013 makes it easy to apply common formatting changes to a cell selec- tion right within the Worksheet area thanks to its mini-toolbar feature — nicknamed the mini-bar.
To display the mini-toolbar, select the cells that need formatting and then right-click somewhere in the cell selection. The mini-toolbar then appears immediately below or above the cell selection’s shortcut menu. (See Figure 2-9.)
The mini-toolbar contains most of the buttons from the Font group of the Home tab (with the exception of the Underline button). It also contains the Center & Merge and Center buttons from the Alignment group (see “Altering the alignment” later in this chapter) and the Accounting Number Format, Percent Style, Comma Style, Increase Decimal, and Decrease Decimal buttons from the Number group. Simply click these buttons to apply their formatting to the current cell selection.
Figure 2-9:
Right-click your cell selection to display its shortcut menu along with the mini-bar, whose buttons you can use to format the selection.