Add Data to Excel Table with Total Row

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!

Continue reading "Add Data to Excel Table with Total Row"

Excel Table Doesn’t Expand For New Data

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.

Continue reading "Excel Table Doesn’t Expand For New Data"