Q: Is there a quick & easy way of deleting the same set of columns across multiple tabs of a spreadsheet?
I have to adapt a spreadsheet to send to a client & has data in hundreds of tabs which I don't want to share with them A: Click on the first sheet tab. Now hold down the SHIFT key and click on the last sheet tab. This will select all of the sheets in the middle in addition to the two end sheets. Now select the columns you want to delete. Delete them. This will delete them in ALL of the sheets you have selected. (You can optionally use CTRL-click to select individual sheets and columns).
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.