Hi, it's really annoying when you have a nicely formated report and then you
copy and paste it to another workbook and you loose the formatting. Is there
any way to avoid this?

Debbie -

Have you tried Copy, Edit, Paste Special, and select Value and Number
formats ?

HTH,
Carole O

"Debbie" wrote:

Hi, it's really annoying when you have a nicely formated report and then you
copy and paste it to another workbook and you loose the formatting. Is there
any way to avoid this?

Thanks for your reply Carole, but not exactly sure what you mean. I've tried
the Paste Special but I can only choose one option either 'format' or 'value'
I usually leave it at the default which is 'all' but I loose formats such as
column width, wrap, etc.

"Carole O" wrote:

Debbie -

Have you tried Copy, Edit, Paste Special, and select Value and Number
formats ?

HTH,
Carole O

"Debbie" wrote:

Hi, it's really annoying when you have a nicely formated report and then you
copy and paste it to another workbook and you loose the formatting. Is there
any way to avoid this?

Highlight the columns where the report is included and then copy paste all.
The column widths etc. should remain intact.

"Debbie" wrote:

Thanks for your reply Carole, but not exactly sure what you mean. I've tried
the Paste Special but I can only choose one option either 'format' or 'value'
I usually leave it at the default which is 'all' but I loose formats such as
column width, wrap, etc.

"Carole O" wrote:

Debbie -

Have you tried Copy, Edit, Paste Special, and select Value and Number
formats ?

HTH,
Carole O

"Debbie" wrote:

Hi, it's really annoying when you have a nicely formated report and then you
copy and paste it to another workbook and you loose the formatting. Is there
any way to avoid this?

When you have copied your data, just paste normally first time round
ignoring any errors, then paste again using paste special as values.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Dave Breitenbach" wrote in
message ...
Highlight the columns where the report is included and then copy paste
all.
The column widths etc. should remain intact.

"Debbie" wrote:

Thanks for your reply Carole, but not exactly sure what you mean. I've
tried
the Paste Special but I can only choose one option either 'format' or
'value'
I usually leave it at the default which is 'all' but I loose formats
such as
column width, wrap, etc.

"Carole O" wrote:

Debbie -

Have you tried Copy, Edit, Paste Special, and select Value and Number
formats ?

HTH,
Carole O

"Debbie" wrote:

Hi, it's really annoying when you have a nicely formated report and
then you
copy and paste it to another workbook and you loose the formatting.
Is there
any way to avoid this?

I've highlighted the columns and then used copy, then pasted all and it still
doesn't retain the column width, etc.
Any other suggestions?
"Dave Breitenbach" wrote:

Highlight the columns where the report is included and then copy paste all.
The column widths etc. should remain intact.

"Debbie" wrote:

Thanks for your reply Carole, but not exactly sure what you mean. I've tried
the Paste Special but I can only choose one option either 'format' or 'value'
I usually leave it at the default which is 'all' but I loose formats such as
column width, wrap, etc.

"Carole O" wrote:

Debbie -

Have you tried Copy, Edit, Paste Special, and select Value and Number
formats ?

HTH,
Carole O

"Debbie" wrote:

Hi, it's really annoying when you have a nicely formated report and then you
copy and paste it to another workbook and you loose the formatting. Is there
any way to avoid this?

Sorry Ken, that's not working for me either.

"Ken Wright" wrote:

When you have copied your data, just paste normally first time round
ignoring any errors, then paste again using paste special as values.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Dave Breitenbach" wrote in
message ...
Highlight the columns where the report is included and then copy paste
all.
The column widths etc. should remain intact.

"Debbie" wrote:

Thanks for your reply Carole, but not exactly sure what you mean. I've
tried
the Paste Special but I can only choose one option either 'format' or
'value'
I usually leave it at the default which is 'all' but I loose formats
such as
column width, wrap, etc.

"Carole O" wrote:

Debbie -

Have you tried Copy, Edit, Paste Special, and select Value and Number
formats ?

HTH,
Carole O

"Debbie" wrote:

Hi, it's really annoying when you have a nicely formated report and
then you
copy and paste it to another workbook and you loose the formatting.
Is there
any way to avoid this?

What are the exact ranges you are copying from and to?

Is the destination sheet identical to the source sheet in structure?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Debbie" wrote in message
...
I've highlighted the columns and then used copy, then pasted all and it
still
doesn't retain the column width, etc.
Any other suggestions?
"Dave Breitenbach" wrote:

Highlight the columns where the report is included and then copy paste
all.
The column widths etc. should remain intact.

"Debbie" wrote:

Thanks for your reply Carole, but not exactly sure what you mean.
I've tried
the Paste Special but I can only choose one option either 'format' or
'value'
I usually leave it at the default which is 'all' but I loose formats
such as
column width, wrap, etc.

"Carole O" wrote:

Debbie -

Have you tried Copy, Edit, Paste Special, and select Value and
Number
formats ?

HTH,
Carole O

"Debbie" wrote:

Hi, it's really annoying when you have a nicely formated report
and then you
copy and paste it to another workbook and you loose the
formatting. Is there
any way to avoid this?

A1:L243 is the range I'm copying. I first tried copying by first
highlighting by using the highlight all but next to column A and above column
1. I also tried just highlighting the columns by highlighting across the
cell letters and highlighting the exact range neither worked.
"Ken Wright" wrote:

What are the exact ranges you are copying from and to?

Is the destination sheet identical to the source sheet in structure?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Debbie" wrote in message
...
I've highlighted the columns and then used copy, then pasted all and it
still
doesn't retain the column width, etc.
Any other suggestions?
"Dave Breitenbach" wrote:

Highlight the columns where the report is included and then copy paste
all.
The column widths etc. should remain intact.

"Debbie" wrote:

Thanks for your reply Carole, but not exactly sure what you mean.
I've tried
the Paste Special but I can only choose one option either 'format' or
'value'
I usually leave it at the default which is 'all' but I loose formats
such as
column width, wrap, etc.

"Carole O" wrote:

Debbie -

Have you tried Copy, Edit, Paste Special, and select Value and
Number
formats ?

HTH,
Carole O

"Debbie" wrote:

Hi, it's really annoying when you have a nicely formated report
and then you
copy and paste it to another workbook and you loose the
formatting. Is there
any way to avoid this?

If you select the bit you mentioned which is above 1 and left of A and then
hit copy, then select the same place in the detsination sheet and hit paste,
all the formatting should take, including column widths etc. Now just paste
special with values and the data should be right also.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip