你想将Excel文件转换成Word文件?Excel没有转换成Word的转换功能,而且Word也不能直接打开Excel文件。然而,Excel表格可以复制粘贴到Word中,然后保存为Word文件。阅读本文,了解如何在Word文档中插入Excel表格的方法 [1]
。
步骤
方法 1 的 2:
将Excel中的数据复制粘贴到Word中
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/70\/Convert-Excel-to-Word-Step-1-Version-4.jpg\/v4-460px-Convert-Excel-to-Word-Step-1-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/70\/Convert-Excel-to-Word-Step-1-Version-4.jpg\/v4-728px-Convert-Excel-to-Word-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
复制Excel中的数据。在Excel中,拖动选择表格中的内容,然后按下CTRL + C。
- 按下CTRL + A,选择表格中的所有内容,然后按下CTRL + C。
- 你还可以点击“编辑”菜单,然后点击“复制”。
- 如果你用功的是Mac,按下Command + C。
- 除了复制粘贴Excel中的数据,你还可以复制粘贴Excel中的图表。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/18\/Convert-Excel-to-Word-Step-2-Version-4.jpg\/v4-460px-Convert-Excel-to-Word-Step-2-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/1\/18\/Convert-Excel-to-Word-Step-2-Version-4.jpg\/v4-728px-Convert-Excel-to-Word-Step-2-Version-4.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
在Word中,粘贴Excel的数据。在Word中,将指针放到你要粘贴的地方,然后按下CTRL + V。表格就被粘贴到Word中了。
- 你还可以点击“编辑”菜单,然后点击“粘贴”。
- 如果你用功的是Mac,按下Command + V。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/c\/c2\/Convert-Excel-to-Word-Step-3-Version-4.jpg\/v4-460px-Convert-Excel-to-Word-Step-3-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/c\/c2\/Convert-Excel-to-Word-Step-3-Version-4.jpg\/v4-728px-Convert-Excel-to-Word-Step-3-Version-4.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
选择“粘贴”选项。在表格右下角,点击“粘贴”选项,查看不同的“粘贴选项”。
- 如果你看不到粘贴选项按钮,可能是没有启用它。要启用,可以点击“Word选项”,点击“高级”。在“剪切、复制和粘贴”下面,点击“显示粘贴选项”前的选项框[2]
。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/6\/6a\/Convert-Excel-to-Word-Step-4-Version-4.jpg\/v4-460px-Convert-Excel-to-Word-Step-4-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/6\/6a\/Convert-Excel-to-Word-Step-4-Version-4.jpg\/v4-728px-Convert-Excel-to-Word-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
点击保持原格式,就可以使用Excel表格的形式。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/a\/a4\/Convert-Excel-to-Word-Step-5-Version-4.jpg\/v4-460px-Convert-Excel-to-Word-Step-5-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/a\/a4\/Convert-Excel-to-Word-Step-5-Version-4.jpg\/v4-728px-Convert-Excel-to-Word-Step-5-Version-4.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
点击匹配目标格式使用Word表格的形式。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/f8\/Convert-Excel-to-Word-Step-6-Version-4.jpg\/v4-460px-Convert-Excel-to-Word-Step-6-Version-4.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/f8\/Convert-Excel-to-Word-Step-6-Version-4.jpg\/v4-728px-Convert-Excel-to-Word-Step-6-Version-4.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
创建链接的Excel表格。Word中有可以创建链接到其他Office文件的功能,也就是说如果你对Excel文件做出变更,那么也会更新到Word中。点击保持原格式并链接到Excel或匹配目标格式并链接到Excel,创建链接的Excel表格。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/7\/70\/Convert-Excel-to-Word-Step-7-Version-2.jpg\/v4-460px-Convert-Excel-to-Word-Step-7-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/7\/70\/Convert-Excel-to-Word-Step-7-Version-2.jpg\/v4-728px-Convert-Excel-to-Word-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
点击只保留文本,只粘贴Excel中的内容,但没有任何格式。
- 当你使用这个选项后,每一行的位置不会变,而数据之间由制表符分隔。
方法 2 的 2:
在Word中插入Excel图表
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/1\/1f\/Convert-Excel-to-Word-Step-8-Version-2.jpg\/v4-460px-Convert-Excel-to-Word-Step-8-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/1\/1f\/Convert-Excel-to-Word-Step-8-Version-2.jpg\/v4-728px-Convert-Excel-to-Word-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
1
在Excel中,点击选中图表,然后按下CTRL + C,复制它。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/d\/d3\/Convert-Excel-to-Word-Step-9-Version-2.jpg\/v4-460px-Convert-Excel-to-Word-Step-9-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/d\/d3\/Convert-Excel-to-Word-Step-9-Version-2.jpg\/v4-728px-Convert-Excel-to-Word-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
2
在Word中,按下CTRL + V,粘贴图表。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/e\/e7\/Convert-Excel-to-Word-Step-10-Version-2.jpg\/v4-460px-Convert-Excel-to-Word-Step-10-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/e\/e7\/Convert-Excel-to-Word-Step-10-Version-2.jpg\/v4-728px-Convert-Excel-to-Word-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
3
选择粘贴选项。在表格右下角,点击“粘贴选项”按钮,查看不同的粘贴选项。
- 和粘贴Excel数据不同,当你粘贴图表时,只有两种不同的粘贴选项。你既可以更改数据的选项,也可以更改格式的选项。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/2\/2d\/Convert-Excel-to-Word-Step-11-Version-2.jpg\/v4-460px-Convert-Excel-to-Word-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/2\/2d\/Convert-Excel-to-Word-Step-11-Version-2.jpg\/v4-728px-Convert-Excel-to-Word-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
4
点击图表(链接到Excel数据),这样原文件更新后,Word中的图表也会更新。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/00\/Convert-Excel-to-Word-Step-12-Version-2.jpg\/v4-460px-Convert-Excel-to-Word-Step-12-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/00\/Convert-Excel-to-Word-Step-12-Version-2.jpg\/v4-728px-Convert-Excel-to-Word-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":349,"bigWidth":728,"bigHeight":552,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
5
点击Excel图表(整个工作簿)),就可以打开图表来源的Excel文件。
- 要从图表打开Excel文件,你需要右键图表,然后点击“编辑数据”。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/0f\/Convert-Excel-to-Word-Step-13-Version-2.jpg\/v4-460px-Convert-Excel-to-Word-Step-13-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/0f\/Convert-Excel-to-Word-Step-13-Version-2.jpg\/v4-728px-Convert-Excel-to-Word-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":350,"bigWidth":728,"bigHeight":554,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
6
点击粘贴为图片,统计图表就不会跟随原文件更改。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/0\/02\/Convert-Excel-to-Word-Step-14-Version-2.jpg\/v4-460px-Convert-Excel-to-Word-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/0\/02\/Convert-Excel-to-Word-Step-14-Version-2.jpg\/v4-728px-Convert-Excel-to-Word-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":544,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
7
点击保留原格式,就可以使用Excel表格中的样式。
-
{"smallUrl":"https:\/\/www.zenmeban.com\/images_en\/thumb\/f\/f1\/Convert-Excel-to-Word-Step-15-Version-2.jpg\/v4-460px-Convert-Excel-to-Word-Step-15-Version-2.jpg","bigUrl":"https:\/\/www.zenmeban.com\/images\/thumb\/f\/f1\/Convert-Excel-to-Word-Step-15-Version-2.jpg\/v4-728px-Convert-Excel-to-Word-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":349,"bigWidth":728,"bigHeight":553,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
8
点击使用目标格式,就可以使用Word中的表格格式。