Apply table  
 
 

Applying the tool

Select a range in order to apply the configurations for the table and press the button of the ribon of the Sp.

 
You will be able to apply the tables according to the configuration that you have elected by means of this tool
When applying a table at the heading parts of tables, a style will be assigned (Heading 1 (table)) 
The central part of the table will receive the configurations of take turns rows shading
The row of the totals will receive the Total style
 
 
Settings
Access the dialog below from the Quick styles panel, by selecting the button
 

Edit

Press the corresponding button to the formats to edit in order to modify a style.
 

 

Alternate rows
 
Note:

This tool works with the stylos Heading 1 ( table ) and Total " of the theme styles activate book if

you wish  the tool apply the stylos Heading 1 ( table ) and total " of other theme styles first
you must apply the new styles on your book.
 
This Function is available  for Excel 2007 only.