Forum Discussion
Deleting columns in multiple worksheets
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?
Les_Worrall It doesn't indicate that either sheets or workbook are protected.
It has to be that the template was created by someone else. It doesn't tell me it's protected as it gives ME the option to protect (but no "unprotect") it but it won't allow me delete columns either.
I tried removing the author and saving it separately but it still won't permit me to delete.
Thanks for all the help, everyone.
- If you save it as another file name and open that up, can you then do it?
