Thread: How to insert a row by hitting tab with filter applied in a table

I am using MS Excel 2007. My problem is with inserting rows in a table when a filter is applied.

I created a table in excel 2007 with no Excel 2007 specific table styles assigned. I applied an auto filter. The table automatically adds a new row when I hit the tab key irrespective of any filter applied. However, when I add a "Total Row" to the table, and apply a filter, I get the following message when I try to add a new row by hitting the TAB key "Cannot shift cells in a filtered range or table".

This would not be a problem only if I did not have other tables that I personally created returning this error message. Now even the new tables from scratch return this error unless I remove "Total row". Without the "Total row", the table acts as expected. I can add rows by hitting the tab button whether or not there is a filter applied.

I already checked if there was some kind of protection, hidden cells, or some formatting that would generate such strange behavior. I did not have this issue before. Can anyone assist me fixing this annoying issue?