One way to format a cell is to use one of Excel 2007’s styles from the Cell Styles Gallery. A Cell Style is a collection of formats such as a particular font type and size, particular shading, font color, background color, and more. Click the Cell Styles button on the Styles group on the Home Ribbon to display a variety of pre-defined formats that you can quickly apply to your cells. As you move your mouse pointer over any of the styles in the gallery, the formatting of your worksheet will change to reflect what your cells would look like if you were to apply the style. This is an example of Excel’s new Live Preview feature.
As you work more with Excel, you will most likely develop your own preferred formats for particular worksheets. Rather than setting these formats over and over in your worksheets, you can store these formatting options in Excel’s Cell Style Gallery. You should consider adding any special cell formatting that you plan to use in the future. Cell Styles can be a real time-saver if you find yourself applying the same formatting over and over.
To Apply an Existing Style
- Select the cell or cell range to which you wish to apply a style.
- Click the Cell Styles button on the Styles Group on the Ribbon.
- Move your mouse pointer over any of the styles to preview how the formatting will look on our worksheet.
- Click the Style you wish to use.
To Create a New Style
- Manually apply any formatting to a cell that you wish to include in your style.
- Click the Cell Styles button on the Styles Group on the Ribbon.
- Click New Cell Style on the bottom of the gallery list.
- Enter a name for your new style in the Style Name text box.
- Uncheck any formatting options underneath the Style Includes (By Example) that you do not wish to include in your new style.
- Click the Format button to change the formatting options.
- Click OK. Your new style will now display on top of the Cell Styles gallery under the Custom category.
New Cell Style dialog box
Similar Posts:
- Apply a Quick Style in Word 2007
- Applying Quick Styles to a PowerPoint Table
- Adding Quick Styles to a Picture in Word 2007
- Formatting a Table in Excel 2007
- Formatting Drawing Objects in PowerPoint 2007
- Change the Layout and Style of a Chart in Excel 2007
- Creating a Table of Contents in Word 2007
