Microsoft Excel 2007 with Example

4 Format Cells:

4.9 Format Cells: Cell Styles

Quickly format a cell by choosing a cell style. You can also create your own cell style. Quickly format a range of cells by choosing a table style.

1. For example, select cell B2 below.

Select a Cell

2. On the Home tab, in the Styles group, choose a cell style.

Choose a Cell Style

Result.

Cell Style in Excel

To create your own cell style, execute the following steps.

3. On the Home tab, in the Styles group, click the bottom right down arrow.

Click Bottom Right Down Arrow

Here you can find many more cell styles.

4. Click New Cell Style.

Click New Cell Style

5. Enter a name and click the Format button to define the Number Format, Alignment, Font, Border, Fill and Protection of your cell style. Simply uncheck a check box if you don't want to control this type of formatting.

6. Click OK.

Style Includes

7. On the Home tab, in the Styles group, apply your own cell style.

Apply Your Own Cell Style

Result.

Your own Cell Style in Excel

Note: right click a cell style to modify or delete it. Modifying a cell style affects all cells in a workbook that use that cell style. This can save a lot of time. A cell style is stored in the workbook where you create it. Open a new workbook and click on Merge Styles (under New Cell Style) to import a cell style (leave the old workbook with the cell style open).