The final adjustment you should make in the Table Design tab is to give your table a name. By default, Excel tables are called Table1, Table 2, Table3, and so on.

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.

How do I create and populate tables? And, once a table is created, how do we custom filter, format, and design those tables so they look professional in a report? We’ll show you how it’s done.