Excel 2007 auto expand table that has a total row?

Hi all,

I've got a workbook (attached) that I previously developed in Excel 2003. I use it to track my hours on projects at work.

ABH_Hours_Tracking_Example.xlsm

In the old version, I had a table which automatically expanded as I added new data below the last filled row. Below that, I had a blank row and then a row which included a manually entered

Please Login or Register  to view this content.

which expanded nicely with the table, and gave me, at a glance, the subtotal for whatever filters I had applied to the table.

Now that I've upgraded to 2007, I can't figure out how to replicate all of that functionality. I can make a table that expands automatically as I add new data below. I can activate the total row and get totals for the various filtering scenarios. I can't seem to get both. When I try the old way, with a manually created subtotal cell, the cell doesn't get pushed down as new table rows are added. If I activate the total row, I can't figure out where to type/click to automatically expand the table down another row.

Surely this is within the capabilities of Excel 2007? I don't believe that this is such an out-of-the-way way to use the software, but for the life of me, I can't find any answers on google or by trial and error.

Can someone help me figure out what I'm doing wrong, and let me know the right way to get back to the same function that I had in the 2003 version file?

Thanks,
Adam Hartman

DBY,

Yes, that does 95% of what I wanted. I wish it was one less keystroke, though! Still, that gets me what I really need. Thanks.

-Adam