Forum Discussion
Deleting columns in multiple worksheets
The directions I've found online for deleting columns in multiple worksheets doesn't work. I can select a group of worksheets, all formatted the same, but when I do that the "delete" functions all tu...
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.