Exactly what is not being copied in the way of formats? What version of
Excel do you have.

When you say spreadsheet are you talking about another worksheet in the same
workbook, or to a sheet in a separate workbook (.xls file) completely? I ask
because some people use the term spreadsheet to mean a single worksheet while
others use it mean a .xls file.

And you're probably not doing anything wrong - just doing something
not-quite-completely right (to Excel's way of thinking, but probably not to
the rest of the world).

"Meenie" wrote:

When I copy info from a spreadsheet into another (blank) spreadsheet, why
doesn't it copy the same format as it was in the old spreadsheet? I do "paste
special" but it never comes out quite the same.
No doubt I'm doing something wrong :) I just don't know what it might be!!
Thanks :)
Meenie