The title pretty much says it. I have an Excel document with tons of randomly named styles that I didn't create but that I want to copy a worksheet from. When I do, it drags all of those styles into my target workbook, which I don't want. None of the styles themselves are used on the actual sheet I am copying.
If I can't prevent this, is there a way to delete a bunch of styles as a group, rather than selecting each and deleting it?
This other question of mine is similar, in that the problem I'm having is that I get garbage I don't want (and that I don't see that any user wants) when I copy a worksheet:
How do I copy a worksheet without creating local copies of workbook-scoped named formulas?
It earned a "tumbleweed" badge, but perhaps whoever answers this will have an answer for it as well…
Best Answer
You should be able to select all of the cells in the original worksheet, copy them, and then "paste special" (
Edit > Paste Special) in the target workbook. From within the "paste special" dialog, you can specify only formulas, values, etc. and omit style information.Disclaimer: I haven't tried this with Excel 2007 or higher. I'm stuck on the old version.