如果您正在寻找创建和打印任何类型的标签,那么(create and print labels)Microsoft Word和Excel就是您的不二之选。您可以将标签数据存储在Excel 中(Excel),然后在Word中获取该数据以保存或打印标签。
在本指南中,您将了解如何在Excel中创建与(Excel)Word兼容的标签电子表格、配置标签以及保存或打印它们。
1. 在 Excel 电子表格中输入标签数据(1. Enter the Data for Your Labels in an Excel Spreadsheet)
第一步是使用您的标签数据创建一个Excel电子表格。(Excel)您将为每个数据字段分配一个适当的标题,以便您可以在Word中检索标题。
对于以下示例,我们将创建一个包含以下字段的电子表格:
要开始创建Excel电子表格:
- 在您的 Windows 或Mac计算机上启动Microsoft Excel并创建一个新的电子表格。
- 在 Excel 的电子表格屏幕上,选择第一行中的第一个单元格并输入First Name。
- 选择B列中的第一个单元格并输入Last Name。同样,将Street Address、City、State和ZIP Code分别添加到C、D、E和F列的第一行。
- 现在在您刚刚创建的每个标题下添加数据。您的电子表格应如下所示:
- 添加完数据后,通过选择顶部的文件来保存电子表格。(File)
- 在左侧边栏中选择保存。(Save)
- 在右侧窗格中选择浏览。(Browse)
- 选择一个文件夹来保存您的电子表格,在文件名字(File name)段中输入电子表格的名称,然后选择窗口底部的保存。(Save)
- 关闭 Excel 窗口。
您的Excel电子表格现已准备就绪。
2.在Word中配置标签(2. Configure Labels in Word)
第二步是在Word中配置标签的尺寸(configure the dimensions)。您可以选择几种预定义的标签布局。如果需要,您甚至可以使用自定义尺寸创建自己的标签。
- 在您的 Windows 或Mac计算机上启动Microsoft Word并开始一个新的空白文档。
- 在文档编辑屏幕上,从顶部工具栏中选择“邮件”选项卡。(Mailings)
- 在“邮件(Mailings)”选项卡中,选择“开始邮件合并”(Start Mail Merge),然后从菜单中选择“标签”。(Labels)
- 在打开的窗口中,从标签供应商(Label vendors)下拉菜单中选择标签供应商。然后,从Product number列表中选择一种标签类型,最后,选择OK。
- 如果您想创建自定义标签,请选择“新建标签”(New Label)按钮并在以下窗口中指定您的标签尺寸。
- 您的标签布局现已配置,并在Word中保持此文档打开。
3.将Excel数据导入Word文档(3. Bring the Excel Data Into the Word Document)
现在您的标签已配置,将保存(import the data you saved)在Excel电子表格中的数据导入Word文档。您无需打开Excel即可执行此操作。
开始:
- 当您的Word文档仍处于打开状态时,选择顶部的“邮件”选项卡。(Mailings)
- 在Mailings选项卡中,选择Select Recipients并选择Use an Existing List。你告诉Word你想为你的标签使用一个预定义的列表。
- 在打开的文件资源管理器(File Explorer)窗口中,导航到包含您在上面创建的Excel电子表格的文件夹。双击(Double-click)电子表格将其导入您的Word文档。
- Word 将打开一个选择表(Select Table)窗口。在这里,选择包含标签数据的工作表。
- 勾选First row of data contains column headers选项并选择OK。
4. 将 Excel 中的标签添加到 Word 文档(4. Add Labels from Excel to a Word Document)
您现在将指定要在标签中使用的字段。
要做到这一点:
- 确保您仍在Word中的标签文档上。
- 选择顶部的“邮件”选项卡,然后从“(Mailings)写入和插入字段”(Write & Insert Fields)部分中,选择“地址块(Address Block)”选项。
- 在打开的插入地址块(Insert Address Block)窗口中,选择匹配字段(Match Fields)按钮。
- Word 将打开一个匹配字段(Match Fields)窗口。在这里,确保地址块所需的(Required for Address Block)每个字段与电子表格中的相应字段匹配。例如,地址 1(Address 1)应设置为使用电子表格中的街道地址(Street Address),依此类推。
- 选择确定(OK)关闭窗口。
- 返回“插入地址块(Insert Address Block)”窗口,您可以看到标签的预览。确保此预览代表您要创建的实际标签。然后,选择窗口底部的确定。(OK)
- 在您的Word文档中,您会注意到第一个标签现在显示<<AddressBlock>>。
- 选择顶部的邮件选项卡,然后选择(Mailings)更新标签(Update Labels)。
- 您文档中的所有标签现在都应该显示<<AddressBlock>>。
5. 在 Word 文档中从 Excel 创建标签(5. Create Labels From Excel in a Word Document)
Word现在拥有生成标签所需的所有数据。您现在将完成该过程,Word将显示每个标签的实际数据:
- 在Word的“邮件”选项卡中,选择“(Mailings)完成并合并”(Finish & Merge)选项,然后从菜单中选择“编辑单个文档”。(Edit Individual Documents)
- 在打开的窗口中,选择All并选择OK。
- 您的Word文档现在应该显示所有标签及其各自的数据。
您现在可以保存此标签文档、从中生成PDF或物理打印文档(标签)。
6.将 Excel 创建的 Word 标签另存为 PDF(Save Word Labels Created from Excel as PDF)
您不必使用第三方工具将 Word 的标签文档另存为 PDF:
- 选择Word 窗口顶部的“文件”选项卡。(File)
- 从左侧的边栏中,选择Save As。
- 在右侧窗格中选择浏览。(Browse)
- 选择要保存PDF的文件夹,在文件名字(File name)段中输入PDF的名称,从保存类型(Save as type)下拉菜单中选择PDF ,然后选择(PDF)保存(Save)。
7.打印从 Excel 创建的 Word 标签(Print Word Labels Created From Excel)
您可以直接从Word打印标签。确保(Make)您的打印机在执行打印时已连接到您的计算机:(printer is connected to your computer)
- 选择Word 窗口顶部的“文件”选项卡。(File)
- 在左侧边栏中选择打印。(Print)
- 从右侧窗格的“打印机(Printer)”菜单中选择一台打印机,然后选择顶部的“打印”。(Print)
你都准备好了。
正如您在上面看到的,Word和Excel可以帮助您在 Windows 和Mac计算机上创建几乎所有类型的标签。如果这有助于您在Excel中生成所需的标签类型,请在下面的评论中告诉我们。
How to Create Labels in Word from an Excel Spreadsheet
If you’re looking to create and print labels of any kind, look no further than Microsoft Word and Excel. You can store your label data in Excel and then fetch that data in Word to save or print your labels.
In this guide, you’ll learn how to create a label spreadsheet in Excel that’s compatible with Word, configure your labels, and save or print them.
1. Enter the Data for Your Labels in an Excel Spreadsheet
The first step is to create an Excel spreadsheet with your label data. You’ll assign an appropriate header to each data field so you can retrieve the headers in Word.
For the following example, we’ll create a spreadsheet with the following fields:
- First Name
- Last Name
- Street Address
- City
- State
- ZIP Code
To start creating your Excel spreadsheet:
- Launch Microsoft Excel on your Windows or Mac computer and create a new spreadsheet.
- On Excel’s spreadsheet screen, select the first cell in the first row and type First Name.
- Select the first cell in the B column and type Last Name. Similarly, add Street Address, City, State, and ZIP Code to the C, D, E, and F columns’ first rows, respectively.
- Now add the data beneath each header you just created. Your spreadsheet should look something like this:
- When you’ve finished adding data, save your spreadsheet by selecting File at the top.
- Select Save in the left sidebar.
- Select Browse in the pane on the right.
- Choose a folder to save your spreadsheet in, enter a name for your spreadsheet in the File name field, and select Save at the bottom of the window.
- Close the Excel window.
Your Excel spreadsheet is now ready.
2. Configure Labels in Word
The second step is to configure the dimensions of your labels in Word. There are several predefined label layouts that you can choose from. You can even create your own label with custom dimensions, if you want.
- Launch Microsoft Word on your Windows or Mac computer and start a new blank document.
- On the document editing screen, select the Mailings tab from the top toolbar.
- In the Mailings tab, select Start Mail Merge and then choose Labels from the menu.
- In the window that opens, select a label vendor from the Label vendors dropdown menu. Then, select a label type from the Product number list, Finally, select OK.
- If you’d like to create a custom label, select the New Label button and specify your label dimensions on the following window.
- Your label layout is now configured, and keep this document open in Word.
3. Bring the Excel Data Into the Word Document
Now that your labels are configured, import the data you saved in your Excel spreadsheet into your Word document. You don’t need to open Excel to do this.
To start:
- While your Word document is still open, select the Mailings tab at the top.
- In the Mailings tab, select Select Recipients and choose Use an Existing List. You’re telling Word you want to use a predefined list for your labels.
- In the File Explorer window that opens, navigate to the folder containing the Excel spreadsheet you created above. Double-click the spreadsheet to import it into your Word document.
- Word will open a Select Table window. Here, select the sheet that contains the label data.
- Tick mark the First row of data contains column headers option and select OK.
4. Add Labels from Excel to a Word Document
You will now specify the fields you’d like to use in your labels.
To do that:
- Ensure you’re still on the labels document in Word.
- Select the Mailings tab at the top, and then from the Write & Insert Fields section, select the Address Block option.
- On the Insert Address Block window that opens, select the Match Fields button.
- Word opens a Match Fields window. Here, make sure each field in the Required for Address Block matches with the appropriate field in your spreadsheet. For example, Address 1 should be set to use Street Address from your spreadsheet, and so on.
- Select OK to close the window.
- Back on the Insert Address Block window, you can see a preview of your label. Ensure this preview represents the actual labels you want to create. Then, select OK at the bottom of the window.
- In your Word document, you’ll notice the first label now says <<AddressBlock>>.
- Select the Mailings tab at the top and then select Update Labels.
- All labels in your document should now say <<AddressBlock>>.
5. Create Labels From Excel in a Word Document
Word now has all the data it needs to generate your labels. You will now finish the process and Word will display the actual data for each label:
- In the Mailings tab of Word, select the Finish & Merge option and choose Edit Individual Documents from the menu.
- In the window that opens, choose All and select OK.
- Your Word document should now display all your labels with their individual data.
You can now save this labels document, generate a PDF out of it, or physically print the document (labels).
6. Save Word Labels Created from Excel as PDF
You don’t have to use a third-party tool to save your Word’s label document as PDF:
- Select the File tab at the top of the Word window.
- From the sidebar on the left, select Save As.
- Choose Browse on the right pane.
- Select a folder to save your PDF in, enter a name for your PDF in the File name field, choose PDF from the Save as type dropdown menu, and select Save.
7. Print Word Labels Created From Excel
You can print your labels directly from Word. Make sure your printer is connected to your computer when you perform printing:
- Select the File tab at the top of the Word window.
- Select Print in the left sidebar.
- Choose a printer from the Printer menu on the right pane, and then select Print at the top.
And you’re all set.
As you can see above, Word and Excel help you create nearly all kinds of labels on your Windows and Mac computers. If this helped you generate the type of labels in Excel that you wanted, let us know in the comments below.