Microsoft® Office Excel® 2007 Plain & Simple

Defining Cell Styles

When you develop a worksheet, you will probably create a set of formats you want to apply consistently to certain parts of it. For example, you might always want your column headings to be slightly larger and in a different font than the body of the worksheet. You can save the formatting you want for a worksheet element and save it as a style, which you then can apply to appropriate parts of your worksheets. Excel 2007 makes using styles much easier than in previous versions. Not only do you have more built-in styles from which to choose, it’s no trouble to create a custom style of your own.

Apply a Style

1. Select the cells you ...