After creating either a regular or pivot table, go to the "Design" tab that appears in the Excel ribbon. Click on the thumbnails in the "Table Styles" group to see what your table will look like ...

Choose a table design from the gallery on the Table tab. And that’s it. It took all of 20 seconds to create and format a table in Excel. Next, you’ll add calculations to your table.

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.

Now we will create the relationship between tables after naming the tables. On the Data tab, click Relationships ... When it comes to the Foreign key in Microsoft Excel, it helps to determine ...

On the contextual Table Design tab, choose any of the styles in the Table Styles group. The offerings are the same in both options. Figure B Quickly change an Excel Table’s formatting.