Styles in Excel
There are two methods to apply a style to a cell.
The first one is by using the menu: "Format", "Style…". Select the style you need from the dropdown list and click OK. Or in Excel 2010 (2013, 2007): Home tab, Styles group, Expand the Cell Styles gallery and click a style.
In Excel 97-2003 you can save yourself some time (in future) by adding the Style dropdown to a toolbar, like this:
TIP: Adding the style dropdown to a toolbar.
- Rightclick any toolbar or menu and select "Customize...". The dialog screen shown below will appear (after you click the "Commands" tab):
- Below "Categories", click the item called "Format". Now drag the Style dropdown to one of your toolbars (see below)
Dragging the Style control to a toolbar and let go.
Applying a style to some cells now takes nothing more than picking the right one from your new style dropdown. If the format of any of the selected cells deviates from the selected style then Excel (Excel 97 - 2003) will ask you whether or not to update the style to match the formatting of the selected cells (Excel 2010 (2013, 2007) does not ask you this question!):
Confirm to Excel how it must apply the style
This dialog needs some explaining to understand what happens when you click a button.
When you click Yes:
Excel will check all selected cells and add only those elements to the style which coincide for all cells. So if you for example changed a font characteristic for one cell, then Excel will remove the Font settings from the style. Of course you can go back to the style using the menu (format, styles) and modify the style to include that setting again. Note however, that the one cell you changed a font thing to will remain being different from the others.
If you click No:
The selected style will be applied to all cells. Any formatting in those cells will be replaced with the selected formatting elements if the style you chose. Any deviations from a style will be removed. This is the choice Excel 2010 (2013, 2007) makes for you if you select a style from the styles gallery.