如何在Microsoft Word中使用Excel样式的电子表格

Like peanut butter and chocolate, a word processor with some basic spreadsheet chops makes a fantastic combination. When you want some rather easy number-crunching embedded in an otherwise ordinary text document, Microsoft Word has you covered, thanks to baked-in functionality from its sister program Excel.

像花生酱和巧克力一样，带有一些基本电子表格印章的文字处理程序可以实现完美的组合。 如果您想在其他普通文本文档中嵌入一些相当简单的数字运算功能，则可以使用Microsoft Word，这要归功于其姊妹程序Excel中的内置功能。

Word’s implementation of Excel spreadsheets essentially embeds a tiny copy of the program, right in the middle of your weekly newsletter to the Booster’s Club. While editing the Excel section of the document, you have access to all of the Excel controls as if you were using Excel in its own window. You can add standard text and numeral value cells, and crucially, formulas that apply specifically to the Excel mini-window.

Word在Excel电子表格中的实现实质上将程序的一个很小的副本嵌入到Booster's Club的每周新闻通讯的中间。 在编辑文档的Excel部分时，您可以访问所有Excel控件，就像在其自己的窗口中使用Excel一样。 您可以添加标准的文本和数字值单元格，以及至关重要的是添加专门适用于Excel迷你窗口的公式。

To insert an Excel table in Word 2016, click the “Insert” tab at the top of the window, and then click the “Table” button. Click the “Excel Spreadsheet” button in the drop-down menu.

要在Word 2016中插入Excel表，请单击窗口顶部的“插入”选项卡，然后单击“表”按钮。 点击下拉菜单中的“ Excel电子表格”按钮。

Here’s a basic example. I’ve filled the standard cells with made-up values for Stanley’s Sprocket sales, and used one of the most common sum formulas for the cells in the last column. So, for the “Yearly Total” value for “Space Sprockets” in cell F2, I use the formula “sum(B2:E2)” to add all four values across the row and get my total automatically. You can use any Excel formula you like in this embedded version of the program.

这是一个基本示例。 我在标准单元格中填充了Stanley的Sprocket销售额的虚假值，并在最后一列中使用了最常用的总和公式之一。 因此，对于F2单元格中“空间链轮”的“年度总计”值，我使用公式“ sum(B2：E2)”将行中的所有四个值相加并自动获得总计。 您可以在此程序的嵌入式版本中使用所需的任何Excel公式。

This is a screenshot of Word, but the menus and controls from Excel appear when editing the embedded spreadsheet.

这是Word的屏幕截图，但是在编辑嵌入式电子表格时会显示Excel的菜单和控件。

Excel spreadsheets have basically infinite amounts of rows and columns, but that’s not practical when you’re using that data as a table in a Word document. To change the number of visible rows and columns, click and drag the anchor points, the black squares that appear in each corner and midpoint of the box around the Excel spreadsheet.

Excel电子表格基本上具有无限数量的行和列，但是当您将这些数据用作Word文档中的表时，这是不切实际的。 要更改可见行和列的数量，请单击并拖动锚点，这些黑点出现在Excel电子表格周围框的每个角和中点。

When you’re done editing those values, you can click any other part of the Word document and the formatting defaults back to a basic table, suitable for printing or disseminating via read-only formats like PDF. Here, you can adjust the width and height of the table to better fit the formatting of the Word document without changing the number of visible columns or rows.

完成这些值的编辑后，您可以单击Word文档的任何其他部分，格式默认为返回基本表，适合通过只读格式(如PDF)进行打印或分发。 在这里，您可以调整表格的宽度和高度，以更好地适合Word文档的格式，而无需更改可见列或行的数量。

To start editing the spreadsheet again, double-click anywhere inside it to bring back the Excel controls.

要再次开始编辑电子表格，请双击其中的任何地方以调出Excel控件。

It’s also possible to embed an existing Excel file, which is handy if you’re trying to share data you’ve already accumulated. From the Insert table, click the “Object” button (the small blue-bordered square under the “Text” section):

也可以嵌入现有的Excel文件，如果您要共享已积累的数据，这将非常方便。 在“插入”表中，单击“对象”按钮(“文本”部分下方的蓝色边框小方块)：

In the window that pops up, click “Create from file,” then click “Browse” to navigate to and open the Excel spreadsheet on your computer’s storage drive. You also have a couple of other options here. Selecting the “Link To File” option keeps the spreadsheet you see in Word linked to the actual Excel spreadsheet, so long as they are kept in the same locations as when you linked them. Changes you make in either place are reflected in the other. You can also choose the “Display As Icon” option to show the spreadsheet as a simple icon in the Word document that you can click to open the spreadsheet in Excel.

在弹出的窗口中，单击“从文件创建”，然后单击“浏览”以浏览并打开计算机存储驱动器上的Excel电子表格。 您在这里还有其他几个选择。 选择“链接到文件”选项可以将您在Word中看到的电子表格链接到实际的Excel电子表格，只要它们与链接时的位置相同即可。 您在任一位置所做的更改都会反映在另一位置。 您还可以选择“显示为图标”选项，以将电子表格显示为Word文档中的简单图标，您可以单击该图标在Excel中打开电子表格。

When you’re done, just click “OK” to insert the spreadsheet.

完成后，只需单击“确定”即可插入电子表格。

Depending on your Word formatting, you may need to resize or edit it to make everything visible.

根据您的Word格式，您可能需要调整大小或对其进行编辑以使所有内容可见。

翻译自: https://www.howtogeek.com/343536/how-to-use-excel-style-spreadsheets-in-microsoft-word/