Table Styles

Formatting makes the data easier to read and understand.  Microsoft Excel 2010 has a gallery of Table Styles templates. The Table Styles format the Headers as well as the Columns and Rows.

 

Before You Begin: Please click anywhere on the Table to select it. The Table Tools should be visible.

 

4. Try It: Apply a Table Style

Go to Table Tools->Design.

Go to Table Styles.

Select a Quick Style from the gallery.

 

What Do You See? The Table Styles are grouped by Light, Medium and Dark.

 

What Else Do You See? The Sales Rep data is Filtered. There is a little funnel symbol on the field.

 

Keep going...

 

Table Tools->Design ->Table Styles

Exam 77-882: Microsoft Excel 2010 Core

3. Formatting Cells and Worksheets

3.1. Apply and modify cell formats: Format Table Styles