Microsoft Office Tutorials and References
In Depth Information
Decorating a Worksheet with Borders and Colors
4. Enter a descriptive name for your style in the Style Name text box.
5. Click OK.
Next time you open the Cell Styles gallery, you see the name of your
style at the top under Custom.
To remove a style you created from the Cell Styles gallery, right-click its
name in the gallery and choose Delete on the shortcut menu.
Formatting cells with table styles
Especially if your worksheet data is arranged neatly into columns and rows
so that it looks like a conventional table, one of the easiest ways to decorate
cells is to take advantage of table styles. Excel offers many preformatted
table styles that you can apply to columns and rows on a worksheet.
Follow these steps to experiment with table styles:
1. Select the cells you want to format as a table.
2. On the Home tab, click the Format As Table button and select a table
style in the gallery.
The Format As Table dialog box appears.
3. If the cells you want to format include headers, the labels at the top of
column rows that describe the data in the columns below, select the
My Table Has Headers check box.
4. Click OK in the Format As Table dialog box.
You can go to the (Table Tools) Design tab to refine your table. Click the
Quick Styles button on the (Table Tools) Design tab and choose a
different table style in the gallery if you don’t care for the style you chose.
To remove a table style from cells, select the cells, go to the (Table Tools)
Design tab, and choose Clear in the Quick Styles gallery.
As Chapter 5 of this mini-book explains, choosing the Format As Table
command can be a way to filter and sort table data. This is why the Format As
Table command places filter buttons in the first row of tables. To remove
these filter buttons, deselect the Filter Button check box on the (Table
Tools) Design tab.