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 "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?
- When you click on the Review menu, you have protect or unprotect Worbook and also Protect or unprotect Worksheet. Which one are you trying to unprotect?
