从Excel中的Excel粘贴表合并单元格 [英] Pasting Table from Excel in Word merges the cells

问题描述

我将Excel数据粘贴到Word中作为WordTable。

I am pasting excel data into Word as WordTable.

如果excel数据/ Word似乎会自动合并单元格文本重叠两个单元格

例如，第一行的第二个单元格中的文本超出单元格宽度并重叠第三个单元格

Word seems to automatically merge cells if excel data/text overlaps two cells
e.g text in 2nd cell of 1st Row is exceeding cell width and overlaps 3rd cell

现在，在Word中粘贴它会自动合并单元格（1,2）和单元格（1， 3）在结果表中。

Now, upon pasting this in Word automatically merges the cell(1,2) and cell(1,3) in resultant Table.

我的要求是获取没有合并单元格的表。

My requirement is to get table without merged cells.

我已经尝试了所有'选择特定于'的选项，但似乎没有任何东西产生没有合并单元格的表。

I have tried all 'Paste Special' options but nothing seems to produce Table without merged cells.

在没有合并单元格的情况下，有没有办法获得Word Table？

Is there any way of getting Word Table in this case without merged cell?

Rahul

推荐答案

如果你需要粘贴链接，我不知道方法。



但是如果你只需要粘贴一份副本即可它不必看起来像原版，一种方法是使用Excel Home-> Alignment-> Wrap Text按钮来包装长文本，然后复制 - >粘贴，然后撤消Excel中的更改。 
$


这比b
更简单，更可靠。在Excel中复制

  b。在Word中，选择性粘贴 - >无格式文本

  c。选择文本并使用Insert-> Table->将文本转换为表格（只要Excel数据中没有标签，就可以。）

If you need to Paste Links, I don't know of a way.

But if you just need to paste a copy and it doesn't have to look too much like the original, one approach would be to use the Excel Home->Alignment->Wrap Text button to wrap long text, then Copy->Paste, then Undo the change in Excel. 

That seems simpler and more reliable than
 a. Copy in Excel
 b. In Word, Paste Special->Unformatted text
 c. Select the text and use Insert->Table->Convert text to Table (OK as long as there are no tabs in the Excel data).

顺便说一句，这似乎不像"开发者"一样。问题！

BTW, this doesn't seem much like a "Developer" question!

这篇关于从Excel中的Excel粘贴表合并单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！