Table Styles

Formatting makes the data easier to read and understand.  Microsoft Excel has a library of Table Styles. The 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 available.

 

4. Try It: Apply a Table Style

Go to Table Tools->Design.

Go to Table Styles.

Select a Quick Style from the library.

 

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...

Exam 77-420 Microsoft Excel 2013
3. Create Tables
3.2 Modify a Table: Apply Styles to Tables

 

graphic1
Table Tools->Design ->Table Styles
graphic3

 

graphic2