Joan Crawford lives on in the H ollywood Royalty Edition of the cult movie classic, complete with all-n ew special features as dazzling and fascinating as the movie star hersel f. Who better to add his own sense of style to th e commentary of the mo vie than camp filmmaker extraodinaire, John Waters.
Cannot Shift Cells in a Filtered Range or Table. This is a simple matter of making sure that none of the columns within the table are hidden. If the first column is hidden, it canât select the table rows, it defaults to the sheet rows and then you get this error âThis operation is not allowed.The operation is attempting to shift cells in a tableâ.f the first column is hidden, it canât select the table rows, it defaults to the sheet rows and then you get this error âThis operation is not allowed. The operation is attempting to shift cells 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. 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.