TZGQT

In addition to using and modifying the built in Excel cell styles, you can also create your own. A practical method to do so for a number of cells and the formatting of all the attributes you want your style, and then, for these attributes in a cell style. If your style cell, Excel recognizes all the attributes of the selected cells and style. Consider a simple example, we say we want a cell style for the positions of our text angled at 45 degrees.
We use the text of the angle to 45 degrees, typing in “counter-angle to the direction of the tab start Excel Ribbon. Let’s say we want to center the text horizontally and vertically, change the text color and text in bold and a bit bigger. After selecting a style, all these attributes, simply select a cell of these formats and select “New Cell Style in the style of the cells drop-down menu in the Styles tab of Excel Ribbon.
The Style dialog box appears. Here, we can have a name for our new style: Let’s say we call the “bent line. The Style dialog box of six categories of information, the layout can be enabled or disabled on a number of check boxes. We can all kinds of formatting, which are not applicable. Thus, the style of our position, we can disable the ‘number’, “Border”, “fill” or “protection”, we can all turn off. Next to each category, Excel lists the attributes of the selected cell (s), it is not necessary, click each category, for all options, all we need to do, click OK.
When creating a style in this way, it is important to know that Excel is not the style of the cell or cells, which was the style. If the style of the cell, what you should do so specifically to the cell and select the name of the new cell style of the cell styles menu in the style of the tab start Excel Ribbon. After a style, you will notice that Excel with an additional category called “Custom Cell Styles in the menu, and it is here that the style you just created. Although the cell can be selected the same, it is now in a relationship with the new style.
We’ll be on the application of style, where it was necessary throughout our workbook. Only in this way is very time-saving. In addition, however, if we change the format of our position, what we must do is change the attributes of cells associated with our style and all of our positions will be automatically updated.