May 09 2020 06:24 AM
May 09 2020 06:24 AM
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
May 09 2020 07:54 AM
@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.
May 09 2020 01:52 PM
May 09 2020 02:57 PM - edited May 09 2020 03:01 PM
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.
May 10 2020 06:36 AM
May 10 2020 07:31 AM
@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.
May 10 2020 09:37 AM
@SusanRN Can you answer a question please and honestly.
How did you come by this workbook? Are you even allowed to use a copy (meaning copyright protection)?
I ask this, because as such, I don't think anybody can support you if you have obtained this workbook illegally. This by no means suggest that you have done that, but need to be sure.
May 10 2020 01:22 PM
@Les_Worrall LOL, no it's not illegally obtained. It's a table we use at work and maybe it's because it's a pivot table? A co-worker built the template. Every morning, I copy data from another worksheet, then "refresh data" to produce the results and then create worksheets based off the pivot table results...creating 8 worksheets within the workbook. There's way more information than we need in the individual worksheets and I was looking to create worksheets that were more meaningful and less overloaded with extraneous data that the raw data pulls in.
May 10 2020 01:34 PM - edited May 10 2020 01:35 PM
@SusanRN That makes sense.