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

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

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

OOOPS I wrote height and width backwards!!! Sorry.
YOU know what I mean :D

"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

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

Are those guys distantly related to Spielberg and Peckinpah?


Gord

On Mon, 19 Mar 2007 14:12:03 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

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

Distant cousins - twice removed by alien abduction. Most famous for 'B'
movies and low budget copycat films of current big money makers.

"Gord Dibben" wrote:

Are those guys distantly related to Spielberg and Peckinpah?


Gord

On Mon, 19 Mar 2007 14:12:03 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis) wrote:

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

Thanks
I think... lol. You'd think it'd work better by the time they got to 2007! :)
The paint feature works sometimes and sometimes doesn't.
It's a sad sad thing :)
Any clue why "print preview" is so poor? :D

"JLatham" wrote:

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

Sorry, no real explanation for a poorer quality print preview. I've noticed
what I'd call a general degradation of appearance on LCD monitors in most of
the new products coming out: IE 7 and Office 2007 - I don't know whether it's
choice of font styles, colors or a really strange engine driving it all. Or
maybe I'm just getting old and picky and just don't like change for simply
change's sake.

"Meenie" wrote:

Thanks
I think... lol. You'd think it'd work better by the time they got to 2007! :)
The paint feature works sometimes and sometimes doesn't.
It's a sad sad thing :)
Any clue why "print preview" is so poor? :D

"JLatham" wrote:

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

I was making a workbook with 4 sheets, each sheet had exactly the same
information on it. I created the first one, then copied the info to the other
three.
But when I looked at them in print preview - and when I printed them out - I
discovered that each one was a different size! The original fit perfectly on
the page.
The second one didn't - even though I looked at each column and the
measurements were the same, it went off the page!
If I went to "print preview" and moved the lines, then the graph was very
small on the page.
And each page the size was proportionatly different!
Finially I discovered that when I copied the first spreadsheet, the margins
changed on the left and right from 0.25 each side to 0.75 on each side!!!!
Good heavens... and I thought row height and column width were a pain!!
Meenie

"JLatham" wrote:

Sorry, no real explanation for a poorer quality print preview. I've noticed
what I'd call a general degradation of appearance on LCD monitors in most of
the new products coming out: IE 7 and Office 2007 - I don't know whether it's
choice of font styles, colors or a really strange engine driving it all. Or
maybe I'm just getting old and picky and just don't like change for simply
change's sake.

"Meenie" wrote:

Thanks
I think... lol. You'd think it'd work better by the time they got to 2007! :)
The paint feature works sometimes and sometimes doesn't.
It's a sad sad thing :)
Any clue why "print preview" is so poor? :D

"JLatham" wrote:

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