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

Nishley Fagoone 1 Reputation point
2020-01-23T16:35:54.037+00:00

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 Monitored
Not Monitored
Tag not monitored by Microsoft.
36,985 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Vaibhav Chaudhari 38,666 Reputation points
    2020-01-24T05:03:24.687+00:00

    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

    0 comments No comments

  2. JorneS 86 Reputation points
    2020-01-24T10:31:39.367+00:00

    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.

    0 comments No comments