Create a Custom Cell Style : Cell Style « Format Style « Microsoft Office Excel 2007 Tutorial






Select a cell or a range. 
           Click the Home tab. 
           Click the Cell Styles button and then click New Cell Style.
Click the Home tab. Click the Cell Styles button and then click New Cell Style.
Type a name for the cell style. 
           Click Format.
Type a name for the cell style. Click Format.
The Format Cells dialog box opens. 
           Make the changes on the Number, Alignment, Font, border, Fill, and Protection tabs, and then click OK.
The Format Cells dialog box opens. Select the formatting on the Number, Alignment, Font, border, Fill, and Protection tabs, and then click OK.
Click OK again.
Click OK.








3.5.Cell Style
3.5.1.Apply a Cell StyleApply a Cell Style
3.5.2.Create a Custom Cell StyleCreate a Custom Cell Style
3.5.3.Modify a Custom Cell StyleModify a Custom Cell Style
3.5.4.Merge Cell StylesMerge Cell Styles
3.5.5.Delete a Cell StyleDelete a Cell Style
3.5.6.Remove a custom cell style from a cellRemove a custom cell style from a cell