Home | Computers | Software
As well as using and modifying Excel's own built-in cell styles, you also have the option of creating your own. One convenient method of doing this is to select a range of cells and apply all the formatting attributes that you want to add to your style and then convert those attributes into a cell style. When you create a cell style, Excel will pick up all the attributes from the selected cells and include them in the style. Let's say, by way of illustration, we want to create a cell style for headings with text angled at 45 degrees. You can set the text angle to 45 degrees by choosing "Angle Counter Clockwise" from the Alignment section of the Home Tab of the Excel Ribbon. Let's also centre the text horizontally and vertically, change the text colour and make the text bold and slightly larger. Having chosen the relevant options, we simply highlight a cell that contains these formats and choose "New Cell Style" from the Cell Styles drop-down menu in the Styles Tab of the Excel Ribbon. The Style dialogue will then appear. Here, we can enter a name for our new cell style: let's say we call this first cell style "Angled Heading". The Style dialogue contains six categories of formatting information which can be activated or deactivated by clicking on a series of checkboxes. We can simply switch off those categories of formatting that don't apply. In our "Angled Heading" example, we won't need the categories "Number", "Border", "Fill", or "Protection"; so we can uncheck all of them. Next to each of the aforementioned categories, Excel displays all the attributes of the highlighted cell; so it is not necessary to set any options; all we need to do is click OK. When creating a style in this way, it's important to realise that Excel does not apply the style to the cell or cells on which the style was based. If you want to apply the style to the cell, you need to do so explicitly by highlighting the cell and choosing the name of your new cell style from the Cell Styles drop-down menu in the Styles section of the Home Tab of the Excel Ribbon. Having created a style you'll notice that Excel has an extra category called custom in the Cell Styles drop-down menu and it is here that you can choose the style that you just created. Although the highlighted cell may look the same, it will now be associated with the new style. We would then go on to apply the style wherever it was needed throughout our workbook. Just doing this is, in itself, a big time-saver. In addition, however, if we were to change the format of our heading, all we need to do is to modify the attributes associated with our cell style and all of our headings will be automatically updated.
Article Source: http://www.ezine-directory.info
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.
Please Rate this Article
5 out of 54 out of 53 out of 52 out of 51 out of 5
Not yet Rated
