Forum Discussion
Deleting columns in multiple worksheets
You may hold the Ctrl key and select the desired worksheets and then click and hold on column letter A and drag to the column letter C to select columns A:C. Then right click on one of the selected column and choose Delete.
Subodh_Tiwari_sktneer Hi
Click on the tab at the bottom of the screen of the first worksheet and then shift click on the last tab and you should have selected all the worksheets.
Click on Column A whilst all the sheets are selected and Shift Click on column C
Point the mouse pointer at any of the selected letters A to C and click the right mouse button, then select Delete.
If delete is grayed then that suggests that your worksheets are protected. You need to turn the protection off.Subodh_Tiwari_sktneer "delete" is still gray and unselectable.
I have 4 worksheets selected/grouped. I selected A-C on the first sheet. Right clicked and no delete is available for selection. Only cut, copy, format, column width, hide and unhide are selectable. Under Delete in the toolbar, only delete sheet is selectable.
Subodh_Tiwari_sktneer That's what I thought as well, as the original template is not mine. But when I go to "unprotect," it doesn't show it as "protected." But maybe *because* the original author isn't me?
