Excel contains a very wide variety of formats that you can apply to your cells. Naturally, when you create your worksheets you want your formatting to be consistent. Cell Styles offer an excellent way of achieving this.
Cell Styles are located in the Style group of the Home Tab of the Ribbon. When you click the Cell Styles button the Cell Styles gallery is revealed. The gallery provides a live preview; when you hover any of the styles, the current selection within your worksheets changes, giving you a preview of what your data will look like if you choose that particular style.
The first noticeable benefit of using Cell Styles is that you can apply several formats in one operation. For example, say we choose the Cell Style called "Heading One"; we automatically change the size, alignment and colour of our text. We can speed up the formatting process even more by using the Format Painter button to copy styles into the other areas of the worksheet or even other worksheets. Simply highlight a range of cells that already has a Cell Style applied to it, double-click on the Format Painter button to make sure it stays highlighted then drag across the appropriate range(s) of cells. When you have finished, click on the Format Painter button once more to deactivate it.
Having applied cell styles in various parts of a workbook, you can take advantage of the most important benefit offered by styles; if we modify the attributes associated with any of the styles used in a workbook, the formatting of all cells to which those styles have been applied will automatically be updated.
When modifying a style definition, since we're not directly applying formats to any of the cells, it doesn't matter which cells are highlighted. To modify the attributes of a style, click on the Cell Styles button, right click on the name of the style and then choose "Modify". You will then be presented with the six categories of formats which can be included in a style: Number, Alignment, Font, Border, Fill and Protection. The list is fairly comprehensive; it includes just about everything that Excel has to offer in the way of formatting.
You now have the facility of activating and deactivating categories as necessary. Any categories that do not apply to a particular style can simply remain inactive (i.e., checkbox not ticked). Next, click on each relevant category and make your selections. When you click OK to confirm these changes, all cells to which the style has been applied will be automatically updated. - 16039
Cell Styles are located in the Style group of the Home Tab of the Ribbon. When you click the Cell Styles button the Cell Styles gallery is revealed. The gallery provides a live preview; when you hover any of the styles, the current selection within your worksheets changes, giving you a preview of what your data will look like if you choose that particular style.
The first noticeable benefit of using Cell Styles is that you can apply several formats in one operation. For example, say we choose the Cell Style called "Heading One"; we automatically change the size, alignment and colour of our text. We can speed up the formatting process even more by using the Format Painter button to copy styles into the other areas of the worksheet or even other worksheets. Simply highlight a range of cells that already has a Cell Style applied to it, double-click on the Format Painter button to make sure it stays highlighted then drag across the appropriate range(s) of cells. When you have finished, click on the Format Painter button once more to deactivate it.
Having applied cell styles in various parts of a workbook, you can take advantage of the most important benefit offered by styles; if we modify the attributes associated with any of the styles used in a workbook, the formatting of all cells to which those styles have been applied will automatically be updated.
When modifying a style definition, since we're not directly applying formats to any of the cells, it doesn't matter which cells are highlighted. To modify the attributes of a style, click on the Cell Styles button, right click on the name of the style and then choose "Modify". You will then be presented with the six categories of formats which can be included in a style: Number, Alignment, Font, Border, Fill and Protection. The list is fairly comprehensive; it includes just about everything that Excel has to offer in the way of formatting.
You now have the facility of activating and deactivating categories as necessary. Any categories that do not apply to a particular style can simply remain inactive (i.e., checkbox not ticked). Next, click on each relevant category and make your selections. When you click OK to confirm these changes, all cells to which the style has been applied will be automatically updated. - 16039
About the Author:
The author is a trainer and developer with Macresource Computer Solutions, a UK IT training company offering Microsoft Excel 2007 training courses in London and throughout the UK.
