Changing Table Styles in MS Excel
To change table style:
1. Click inside the table you’d like to change.
2. On the contextual Design tab, pause on any table style for a live preview, and click when you want to confirm the change (click the arrows in the gallery to view more styles).
3. Make selections in the Table Style Options group to change formatting of the first and last column, to add a Totals Row, or to have banded rows or columns.