Is there a way to copy an Excel worksheet without copying all of the cell styles in the source workbook to the target workbook?

Question

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:

http://superuser.com/questions/167825/how-do-i-copy-a-worksheet-without-creating-local-copies-of-workbook-scoped-named

It earned a "tumbleweed" badge, but perhaps whoever answers this will have an answer for it as well...

Answer 1

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.