Using Styles

It is quite easy to apply a different font to your cells by highlighting them and then choosing a font from the Font section of the Format Cells window.  If you apply a complicated combination of alignment, font, etc over and over again then it can be a good idea to define a style to hold this information.  To define a new style it is best to click on a cell that is already formatted in the way you want.  Click on the Format drop-down menu and choose Style.  An existing style like Normal will already be shown in the box at the top, delete this and type in a name for your new style. 

You can now modify any of the font, border, etc settings by clicking the Modify button which will take you to the Format Cells window.

You can click on the different sections of this window to change font, borders, number format, alignment, etc for the style you are creating.  Applying this style to a cell will apply all these formatting settings at once.

If you only want to use a style to apply font, alignment, background shading and borders then it is a good idea to untick the Number box in the Style window otherwise you may apply your style to a cell that is formatted as, say, currency and remove the number formatting.  If the number style is not included in the style set up then applying the style will leave that setting as it was when you apply the style to a cell.

When you are happy with your style you can click the Add button to save it for use later.  To apply a style to a cell or range of cells, highlight the cells and then click on the Format drop-down menu and choose Style.  Choose the name of the style from the box at the top and then click OK, the selected style will be applied to the highlighted cells.

Click here to return to the Excel index.