Merge across - copy and paste
 

When I copy multiple rows (name, address, city) from 3 cells into 3 merged
cells(in rows), I get name name name in the first line, and the same
repetitions in the second and 3rd lines. I've tried format, cell, center
across selection, but get the same results. When I copy just the name cell
to the merged cell, it works fine. I don't want to have to copy each of the
three cells and paste them individually. I want to select all three, and
paste them in the merged rows.

Any ideas how to work around this merged cell problem?

Merge across - copy and paste
 

You can't copy multiple cells like that and paste 'cause you're copying the
cell format, too. Why don't you try merging those cells first, and then
copying? Also, I strongly discourage you from doing what you want to do
here. Instead of setting up your workbook in a manner that will not allow
you to later sort (or anything else for that matter) efficiently, why don't
you just do a mail merge? See:
http://www.officearticles.com/word/m...osoft_word.htm
Using mail merge, you can keep your data in "database" format, but display
it any way you like.
************
Anne Troy
www.OfficeArticles.com

"Carole O" wrote in message
...
When I copy multiple rows (name, address, city) from 3 cells into 3 merged
cells(in rows), I get name name name in the first line, and the same
repetitions in the second and 3rd lines. I've tried format, cell, center
across selection, but get the same results. When I copy just the name
cell
to the merged cell, it works fine. I don't want to have to copy each of
the
three cells and paste them individually. I want to select all three, and
paste them in the merged rows.

Any ideas how to work around this merged cell problem?

Merge across - copy and paste
 

Thanks, Anne for your information. It makes things clearer and I can explain
the problem better to my clients. The mailmerge won't work because this data
is copied into a form from various sources.

Carole


"Anne Troy" wrote:

You can't copy multiple cells like that and paste 'cause you're copying the
cell format, too. Why don't you try merging those cells first, and then
copying? Also, I strongly discourage you from doing what you want to do
here. Instead of setting up your workbook in a manner that will not allow
you to later sort (or anything else for that matter) efficiently, why don't
you just do a mail merge? See:
http://www.officearticles.com/word/m...osoft_word.htm
Using mail merge, you can keep your data in "database" format, but display
it any way you like.
************
Anne Troy
www.OfficeArticles.com

"Carole O" wrote in message
...
When I copy multiple rows (name, address, city) from 3 cells into 3 merged
cells(in rows), I get name name name in the first line, and the same
repetitions in the second and 3rd lines. I've tried format, cell, center
across selection, but get the same results. When I copy just the name
cell
to the merged cell, it works fine. I don't want to have to copy each of
the
three cells and paste them individually. I want to select all three, and
paste them in the merged rows.

Any ideas how to work around this merged cell problem?

Merge across - copy and paste
 

Perhaps something like this would be better, then, Carole. They can put
everything into Excel, and "push merge":
http://vbaexpress.com/kb/getarticle.php?kb_id=381
Just a thought, tho. No need to reply if it wouldn't work well for you.
************
Anne Troy
www.OfficeArticles.com

"Carole O" wrote in message
...
Thanks, Anne for your information. It makes things clearer and I can
explain
the problem better to my clients. The mailmerge won't work because this
data
is copied into a form from various sources.

Carole


"Anne Troy" wrote:

You can't copy multiple cells like that and paste 'cause you're copying
the
cell format, too. Why don't you try merging those cells first, and then
copying? Also, I strongly discourage you from doing what you want to do
here. Instead of setting up your workbook in a manner that will not allow
you to later sort (or anything else for that matter) efficiently, why
don't
you just do a mail merge? See:
http://www.officearticles.com/word/m...osoft_word.htm
Using mail merge, you can keep your data in "database" format, but
display
it any way you like.
************
Anne Troy
www.OfficeArticles.com

"Carole O" wrote in message
...
When I copy multiple rows (name, address, city) from 3 cells into 3
merged
cells(in rows), I get name name name in the first line, and the same
repetitions in the second and 3rd lines. I've tried format, cell,
center
across selection, but get the same results. When I copy just the name
cell
to the merged cell, it works fine. I don't want to have to copy each
of
the
three cells and paste them individually. I want to select all three,
and
paste them in the merged rows.

Any ideas how to work around this merged cell problem?