It sounds to me as if things are working properly. Not the way you'd like
them to, but properly. Cell width is still not copied in Excel 2007. Why it
should adjust in one dimension and not the other is another of those
mysteries that may one day end up on the wide screen as a Speilburg or
Peckinpaw epic.

What's interesting is that if you go to your original sheet and click the
column header then use the Format Painter (little paint brush tool) and then
click the column header in the copied-to sheet, then you get width/height
adjustments also.

"Meenie" wrote:

Sorry J :)
I have Excel 2000, and this is from one worksheet in a workbook to another
page in the same workbook (altho it seems to behave the same way if it's to a
new worksheet in a new workbook also).
and it's the formatting that isn't being copied - mostly the sizes of the
cells.
I see in "paste special" you can paste it in then return to "paste special"
again and click on "column height" and the column height will change to the
correct one, but there is no "row width" so you have to go and fix that
manually.
Why is that?
When you first do the "paste special" it defaults to "all" but it doesn't
really copy it ALL in ! :)
Yes, I've noticed that excel thinks a bit differently than I do, lol (but
Word is much much worse!!)
Thanks

"JLatham" wrote:

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