Page 189 - Excel 2013 All-in-One For Dummies

Using Cell Styles 171
Click Normal, the first style in the Good, Bad, and Neutral section, in the Cell Styles gallery to return the formatting in the cell selection to its original state: General number format, left or right (depending on the contents), horizontal and bottom vertical alignment, Calibri (body) or Arial font, 11- or 10-point font size (depending on the operating system, Windows 7 and Vista or Windows XP), no borders, no fill, and locked protection status.
Defining a custom cell style by example
You don’t have to live with just the predefined styles that Excel gives you on the Cell Styles gallery because you can readily create custom cell styles of your own.
By far the easiest way to create a new custom cell style is by example. When you create a cell style by example, you choose a cell that already displays all the formatting attributes (applied separately using the techniques discussed previously in this chapter) that you want included in the new cell style. Then, you follow these simple steps to create the new style by using the for- matting in the sample cell:
1. Position the cell pointer in the cell with the formatting that you want in the new style.
2. Click the New Cell Style option at the bottom of the Cell Styles drop- down gallery (opened by clicking the Cell Styles button in the Styles group on the Ribbon’s Home tab).
This action opens the Style dialog box with a generic style name (Style 1, Style 2, and so on), and the formatting attributes applied to the cell are listed in the Style Includes (By Example) section of the dialog box.
3. Type the name for the new style in the Style Name text box (replacing the Style 1, Style 2, generic style name).
4. Click OK to close the Style dialog box.
When defining a style by example, select only one cell that you know con- tains all the formatting characteristics that you want in the new style. This way, you avoid the potential problem of selecting cells that don’t share the same formatting. If you select cells that use different formatting when defin- ing a style by example, the new style will contain only the formatting that all cells share in common.
After you close the Style dialog box, Excel adds a thumbnail for the new style to a Custom section at the top of the Cell Styles gallery. To apply this new custom cell style to other cell selections in the worksheet, all you have to do is click its thumbnail in the Custom section of the gallery.
Book II Chapter 2
Formatting Worksheets