Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:

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

share|improve this question
up vote 4 down vote accepted

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.

share|improve this answer
+1 - Paste special works the same in 2007. – JNK Aug 3 '10 at 1:09
Actually, I want everything except the styles in the source workbook that the source sheet doesn't use, so it can be even simpler. I can just select all of the cells in the source sheet, copy them, and paste them without Paste...Special. It does create a "Normal2" style, but it's just one to delete. I don't know why I've never thought to copy a sheet by copying all of its cells instead of copying the whole tab by the "Move or Copy" dialog. Thanks! Definite +1, and I'll formally accept this answer if nobody has anything even more direct. – jtolle Aug 3 '10 at 2:13
this should work for my other question too, if you want to answer that and get credit... – jtolle Aug 3 '10 at 2:15
Done and done. Thank you :) – e.James Aug 3 '10 at 9:12
Accepted. While not precisely the solution, it's good enough for me. I'm not trying to automate this - just to eliminate the inconvenience of deleting all the superfluous styles. Obviously, this method won't copy code behind the sheet, etc., but I don't care about that. – jtolle Aug 7 '10 at 15:04

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .