Microsoft Excel 2007 tutorial: apply create or remove a cell style


Apply, create, or remove a cell style

V. Apply, create, or remove a cell style

What is cell style? A cell style is a define set of formatting characters, including fonts and font sizes, number formats, cell borders, and cell shading. You can also prevent making changes to specific cell styles from anyone by using locked cell style.

Microsoft Office Excel provides several built-in cell styles that you can apply or modify. You can also create your own custom cell style by modify or duplicate it.

V.1. Apply a cell style

- Select the cells that you want to apply a cell style.

- On the Home tab, in the Styles group, click Cell Styles.

Excel 2007 Cell Styles

- In the list, click the cell style that you want to use.

V.2. Create a custom cell style

- On the Home tab, in the Styles group, click Cell Styles, and then click New Cell Style.

Excel 2007 New Cell Style

The Style dialog box appears:

Excel 2007 Style dialog box

- Enter an appropriate name for the new cell style in the Style name box.

- Click Format button.

The Format Cells dialog box appears.

- On the various tabs in the Format Cells dialog  box, select the formatting that you like, and click Ok button.

- In the Style dialog box, under Style includes (By Example), clear the check boxes for any formatting options that you don't want to include in the cell style, and then click Ok button.

V.3. Create a cell style by modifying an existing cell style

You can create a custom cell style by modify or duplicate an existing cell style.

+ Modify an existing cell style

-  On the Home tab, in the Styles group, click Cell Styles.

- Right-click the cell style that you want to modify, and then click Modify on the shortcut menu.

Excel 2007 modify cell style

- On the Style dialog box, click Format button.

- On the various tabs in the Format Cells dialog  box, select the formatting that you like, and click Ok button.

- In the Style dialog box, under Style includes (By Example), select or clear the check boxes for any formatting options that you want or don't want to include in the cell style, and then click Ok button.

Note:  When you modify an existing cell style, the Style name box of the Style dialog box is disable that you cannot rename a built-in cell style. So, the built-in cell style will be updated with any changes that you make. A modified cell style is added to the list of custom cell styles.

+ Duplicate an existing cell style

-  On the Home tab, in the Styles group, click Cell Styles.

- Right-click the cell style that you want to format, and then click Duplicate on the shortcut menu.

Excel 2007 duplicate cell style

- In the Style name box of the Style dialog box, type an appropriate name for the new cell style.

Note: If you don't rename a built-in cell style, the built-in cell style will be updated with any changes that you make. A duplicate cell style is added to the list of custom cell styles.

- Click Format button.

- On the various tabs in the Format Cells dialog  box, select the formatting that you want, and click Ok button.

-  In the Style dialog box, under Style includes (By Example), select or clear the check boxes for any formatting options that you want or don't want to include in the cell style, and then click Ok button.

V.4. Remove a cell style

You can remove a cell style from the selected cells without deleting it or delete the cell style from the list.

+ Remove the cell style from selected cells

- Select the cells that are formatted with the cell style that you want to remove.

- On the Home tab, in the Styles group, click Cell Styles.

- Under Good, Bad and Neutral, click Normal.

+ Delete the cell style

- On the Home tab, in the Styles group, click Cell Styles.

- Right-click the cell style that you want to delete, and then click Delete on the shortcut menu.

Note: The normal cell style is not allowed to delete.

 


Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.