Why You Should Add a Table of Contents to Excel What would you do if you had hundreds of sheets in an Excel workbook and needed to find a specific one for updating or modifying data? Searching ...

Add banded rows and columns to your table by going to the "Design" tab and then the "Table Style Options" group.

Here's how you can clear the formatting of your Excel table and revert it to the default style: Click on a cell in your formatted table. Select the Table Design tab that appears on the ribbon.