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 turn gray except for DELETE WORKSHEETS. I want to delete, for instance, Columns A-C across six worksheets. How do I do that, please? There's got to be a way! Thank you in advance
14 Replies
- 1. select your work sheet with control + shift
2. select your delete area
3. press ctrl + delete or removing column press ctrl + - 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.
