question

NishleyFagoone-8828 avatar image
0 Votes"
NishleyFagoone-8828 asked ·

How do you prevent Excel from merging a cell/table automatically after pasting from Word to Excel?

When I hit enter on any table, and include data there, after I paste it, Excel merges it! I don't want it to merge. I want it to be a table.

alt text


not-supported
1.jpg (53.9 KiB)
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered ·

You might not get answer here as this forum doesn't support Excel. You may post this question in a dedicated forum for Excel here https://social.msdn.microsoft.com/Forums/en-US/newthread?category=undefined&forum=exceldev


· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JorneS avatar image
0 Votes"
JorneS answered ·

Excel applies the style from the source, so that is merged tables. If you want other behavior you should do something like this.

After pasting you can press the 'ctrl' button (press and release) and then the 'm' button, this will also set the formatting to destination and it should not merge.


· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.