如果您曾经想将Excel文件中的数据包含到Word文档中,您可能只是从Excel 中(Excel)复制数据并将其粘贴到Word中。
虽然这可行,但存在许多限制。其中最重要的一点是,如果原始数据文件发生更改,您的Word文档将永远不会反映这些更改。
如果这些问题中的任何一个对您来说很重要,那么有更好的方法可以将Excel工作表插入Word文档。在本文中,您将了解所有可能的方法以及优缺点。
此外,请务必查看(check out our YouTube video)下面的 YouTube 视频,我们会向您展示与文章中相同的步骤。
(Insert)通过复制/粘贴将Excel 工作表插入Excel Worksheet Into A Word Doc Via Copy/Paste
当然,从Excel工作表中获取数据到Word文档中最快和最简单的方法就是使用Window 的复制和粘贴功能(Window’s copy and paste feature)。
为此,您将打开包含数据的Excel文件,突出显示包含要带入文档的数据的单元格,然后按键盘上的Ctrl-C。
如果您将光标放在Word文档中并按键盘上的Ctrl-V,您会注意到您选择的单元格完美地显示在Word文档中。
这里有一些警告。
导入的Excel单元格成为Microsoft Word表格。因此,如果您想在数据导入后格式化此表,则不能执行诸如使用Excel公式或其他Excel格式化功能之类的操作。
第二个问题是它只适用于较小的数据表。如果您想在Excel(Excel)电子表格的下方进一步复制和粘贴数据,您将丢失标题。
这真的不是很有用。在这种情况下,您需要尝试以下选项之一,将Excel工作表插入Word文档。
- 优点(Pros):快速方便,适合小桌子。
- 缺点(Cons):不使用源数据进行更新,并且在大表上丢失标题,不完全保留原始格式。
(Insert)将Excel 工作表(Excel Worksheet)作为嵌入(Embedded)对象插入
如果您希望以后能够使用Excel函数和其他Excel格式化功能来更新表格,最好将Excel数据粘贴为嵌入对象。
去做这个:
- 选择要复制的Excel工作表部分,然后按(Excel)Ctrl-C。
- 在Microsoft Word中,将光标放在要插入数据表的位置。
- 在主菜单中,选择(Home)粘贴(Paste)下的向下箭头,然后选择选择性粘贴(Paste Special)。
- 您将看到一个选择性粘贴(Paste Special)对话框出现。选择Microsoft Excel 工作表对象(Microsoft Excel Worksheet Object)并选择OK。
这会将复制的单元格插入到您的Word文档中。新对象的行为根本不像Microsoft Word表格,您将无法从Microsoft Word内部编辑表格中的数据。
但是,您可以调整整个对象的大小,使其适合文档的边距。
如果您确实想编辑数据,只需双击该对象,它将在Microsoft Excel中打开整个原始电子表格。
请记住,这是一个全新的Excel文件(不是原始文件)。但是,您在该Excel(Excel)文件中所做的任何编辑和保存都会在您的Word文档中更新。
这是如何工作的:
- 当您使用嵌入对象粘贴Excel数据时,Word会创建原始(Word)Excel文件的副本。
- 双击对象时,Word会打开复制的文件进行编辑。
- 您可以使用 Excel 的所有功能和格式功能进行任何更改。
这种方法的好处在于,在转换为Microsoft Word表格的过程中,原始格式不会发生任何变化。它还为您提供原始数据文件的“附加” Excel数据文件,以防您想要修改数据或将其他数据添加到Word中粘贴的(Word)Excel对象。
- 优点(Pros):快速方便,适用于大型表格,并保留原始格式
- 缺点(Cons):不更新源数据,不能直接在Word中编辑表格(Word)
(Insert)将Excel 工作表(Excel Worksheet)作为链接对象(A Linked Object)插入
将Excel(Excel)工作表插入Word文档的最佳方法是将其粘贴为链接的嵌入对象(a linked embedded object)。
执行此操作的过程与上述过程相同,除了在“选择性粘贴”窗口(Paste Special window)中您要确保选中“粘贴链接”(Paste Link)复选框。
您会看到插入的Excel数据看起来与上一节中的相同,但存在显着差异。
如果您返回原始Excel文件并对粘贴的任何单元格中的数据进行任何更改,您将看到这些更改立即在Microsoft Word文档中更新。
即使您尚未将更改保存在Excel文件中,更改也会在Word中生效。这实质上使您可以从Word(Word)创建实时视图,以查看某人正在积极对任何Excel文件进行的更改。
如果您愿意,您可以使用此功能在Word(Word)中创建实时仪表板,以显示有人可能在Excel文件中更改的任何重要数据点。
- 优点(Pros):快速方便,适用于大型表格,保存原始格式,并通过源数据更新即时更新。
- 缺点(Cons):不能直接在Word中编辑表格。
如您所见,有多种方法可以将Excel工作表插入Word文档。您选择的选项实际上仅取决于您打算如何使用该数据以及您是否希望查看或使用原始Excel文件中的数据更改。
您以前是如何将Excel数据导入Word的?当您尝试这样做时,您是否遇到过任何问题?在下面的评论部分分享您的经验。
How to Insert an Excel Worksheet into a Word Doc
If уou’ve ever wanted to include data that you havе in an Excel file into a Word document, you’ve probably just coрied the data from Excel and pasted it into Word.
While this works, there are a number of limitations. One of the most important is that if the original data file ever changes, your Word document will never reflect those changes.
If either of those issues matter to you, there are better ways to insert an Excel worksheet into a Word doc. In this article, you’ll learn every way possible to do that as well as the pros and cons.
Also, be sure to check out our YouTube video below where we show you the same steps as in the article.
Insert An Excel Worksheet Into A Word Doc Via Copy/Paste
Of course, the fastest and easiest way to get data from an Excel worksheet into a Word document is just using Window’s copy and paste feature.
To do this, you’ll open the Excel file with your data, highlight the cells that contain the data you want to bring into your document, and press Ctrl-C on the keyboard.
If you place your cursor into your Word document and press Ctrl-V on the keyboard, you’ll notice that the cells you’ve selected appear perfectly in the Word document.
There are a few caveats here.
The imported Excel cells become a Microsoft Word table. So if you want to format this table after the data is imported, you can’t do things like use Excel formulas or other Excel formatting features.
The second issue is that it only works well for smaller tables of data. If you want to copy and paste data further down the Excel spreadsheet, you’ll lose the headers.
This isn’t really very useful. In this case, you’ll want to try one of the options below to insert an Excel worksheet into a Word doc instead.
- Pros: Fast and convenient, good for small tables.
- Cons: Doesn’t update with source data, and lose headers on large tables, doesn’t fully conserve original formatting.
Insert An Excel Worksheet As An Embedded Object
If you want to be able to use Excel functions and other Excel formatting features later to update the table, you’re better off pasting the Excel data as an embedded object.
To do this:
- Select the section of Excel worksheet that you want to copy and press Ctrl-C.
- In Microsoft Word, place the cursor where you want to insert the data table.
- In the Home menu, select the down arrow under Paste and select Paste Special.
- You’ll see a Paste Special dialogue box appear. Select Microsoft Excel Worksheet Object and select OK.
This will insert the copied cells into your Word document. The new object won’t behave like a Microsoft Word table at all, and you won’t be able to edit the data inside the table from inside Microsoft Word.
However, you can resize the entire object so that it fits inside the margins of your document.
If you do want to edit the data, just double-click on the object and it will open the entire original spreadsheet inside Microsoft Excel.
Keep in mind this is an entirely new Excel file (not the original). But any edits you make and save in that Excel file will update in your Word document.
How this works:
- When you use an embedded object to paste Excel data, Word creates a copy of the original Excel file.
- When you double-click the object, Word opens the copied file for editing.
- You can use all of Excel’s functions and formatting features to make any changes.
What is nice about this approach is that none of the original formatting gets changed during the conversion to a Microsoft Word table. It also gives you an “attached” Excel data file of the original data file in case you ever want to modify the data or add additional data to your pasted Excel object in Word.
- Pros: Fast and convenient, good for large tables, and conserves original formatting
- Cons: Doesn’t update with source data, and can’t edit table directly inside Word
Insert An Excel Worksheet As A Linked Object
The best way to insert an Excel worksheet into a Word doc is by pasting it as a linked embedded object.
The procedure to do this is identical to the one above, except in the Paste Special window you want to make sure to select the Paste Link checkbox.
You’ll see that the inserted Excel data looks the same as in the previous section, but there’s a significant difference.
If you return to your original Excel file and make any changes to the data in any of the cells you pasted, you’ll see those changes immediately update in your Microsoft Word document.
The changes take effect in Word even if you haven’t saved the changes in the Excel file. This essentially lets you create a live view from Word into changes someone is actively making in any Excel file.
If you wanted to, you could use this feature to create a real-time dashboard in Word to display any important data points that someone may change in an Excel file.
- Pros: Fast and convenient, good for large tables, conserves original formatting, and updates instantly with source data updates.
- Cons: Can’t edit table directly inside Word.
As you can see, there are multiple ways to insert an Excel worksheet into a Word doc. The option you choose really only depends on how you intend to use that data and whether you want to see or use data changes in the original Excel file.
How have you imported Excel data into Word before? Have you had any issues when you tried to do so? Share your experience in the comments section below.