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’.