When you create an Excel Table, or a Pivot Table, a default style is applied. You can change to a different built-in style, or create custom styles, with your own formatting. There are details below, and an Excel custom styles problem that you might run into.
Do you ever need to compare two Excel Tables? Here's a simple formula that quickly shows if there are any differences, between tables that have the same number of columns and rows.
With a formatted Excel table, you can turn the Total Row on or off easily, and it shows at the bottom of the table. Someone asked me how to add data to Excel Table with Total Row showing – they were hiding the totals every time they wanted to add data. You don't need to do that!
This week, while working on a client's Excel project, I ran into some trouble with Excel tables, while adding new data. Instead of expanding to include the rows, the table just ignored them.
Fortunately, the problem is easy to fix, if you know how, and if you have the patience to do lots of clicking.
When you create a named Excel table with the Table command on the Ribbon's Insert tab, the table retains any formatting that it currently has, and the default Table Style is applied.
When you create a list in Excel, do you automatically convert that list to a formatted table?