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â.
Click the chart for which you want to change the cell range of the source data. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Select Data. In the Select Data Source dialog box, note the location of the data range, and then click OK.Go to the location of the data range, and click any cell in the data range. On the Insert tab, in the Tables group, click Table. Keyboard shortcut You can also press CTRL+L or CTRL+T.f you selected the chart, do the following: On the Design tab, in the Data group, click Select Data. In the Select Data Source dialog box, under Legend Entries (Series) , select the data series that you want to remove, and then click Remove. If you selected a data series on the chart, press DELETE.