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.
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.
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
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.
3 people are following this question.