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?
Bookmarks