Using the Apply Style list
You can also add an Apply Style dropdown list to the Formatting toolbar and select a style from the list to apply it to the selected cells.
To add an Apply Style dropdown list to the Formatting toolbar:
Click the down-arrow at the right-hand end of the Formatting toolbar. On the drop-down menu, click Visible Buttons. (See Figure 106.)
On the submenu, click Apply Style. The menus close and the Apply Style list now appears on the toolbar between the Styles and Formatting icon and the Font Name list.