In this article, we will learn about how to print labels in Excel. Labeling is essential in terms of marketing a product, the address of a person to deliver a product, and many more. Microsoft Excel provides us the feature to create labels and preview the labels before we print. We can print labels in excel with the combination of Microsoft Excel and Microsoft Word. The mail merge feature of Microsoft Word word collaborates with Microsoft Excel to print labels in Excel.
Download Practice Workbook
You can download the practice workbook from here.
Required Steps to Print Labels in Excel
The total process to print labels in excel is with the assistance of Microsoft Word is very simple but a little bit lengthy. So, for your convenience to understand easily we will demonstrate this method to you in seven steps.
Step-1: Insert Data in Excel Worksheet for Labels
First and foremost, in Step-1 we will data in an excel worksheet from which we will create labels to print. In the following dataset, we have taken the First Name, Last Name, Address, and Country of five presidents. From this dataset, we will create labels for individual people. Each label will have the First Name, Last Name, Address, and Country of a president.
Step-2: Check the Confirm File Format Conversion Status in Microsoft Word
File format conversion allows us to open any file in any format. To print labels in excel with Microsoft Word we need to check the confirm file format conversion option. Let’s see how we can do this.
- Firstly, open a new document in Microsoft Word and go to the File tab.
- Secondly, from the File tab select Options.
- A new dialogue box will open.
- Lastly, go to the Advanced Scroll down and check the option Confirm file format conversion on open from the General section.
Related Content: How to Print Data with Excel VBA (A Detailed Guideline)
Step-3: Arrange Labels in Word Document to Print Labels in Excel
In this step, we will arrange labels in word documents to input values from our excel worksheet. Let’s see how we can do this.
- First, go to the Mailings.
- Next, from the ribbon select Start Mail Merge.
- Then, from the drop-down menu select the option Labels.
- A new dialogue box named “Label Options” will appear.
- From the dialogue box select the options as shown in the figure and press OK.
- So, we will get a new page like the following image.
- After that, to design the appearance of labels go to the Table Design option and select anyone from the available Table Styles.
- Finally, we can see a table format on the new page.
Read More: How to Set Print Area in Excel (5 Methods)
- How to Print Selected Area in Excel on One Page (3 Methods)
- Excel VBA: Set Print Area for Multiple Ranges (5 Examples)
- Print Titles in Excel Is Disabled, How to Enable It?
- Excel Button to Print Specific Sheets (With Easy Steps)
- How to Print Excel Sheet with Header on Every Page in Excel (3 Methods)
Step-4: Import Excel Data in Microsoft Word Document
Now we will input data in the above table from an excel worksheet. To do this we have to import excel data in our Microsoft Word document. Just do the following action to import data from an excel file.
- Firstly, go to the Mailings.
- Secondly, from the ribbon select the option Select Recipients.
- Thirdly, from the drop-down menu select the option Use an Existing List.
- Fourthly, browse and select the excel file. Click on “Open” to import data.
- A new dialogue box named Confirm Data Source will appear.
- Press OK.
- The above command will open one more dialogue box named Select Table.
- Now select the table “Print_Label$” and click on OK.
- Lastly, the above command will give you a table like the following one. It links the word file with the excel worksheet.
Related Content: How to Print to PDF in Excel VBA : With Examples and Illustrations
Step-5: Insert Mail Merge Fields in Microsoft Word
Now we need to add mail merge fields to create labels with our excel data. We will use input data from the excel worksheet in the final table of Step-5 to create labels. Let’s see how we can insert mail merge fields.
- In the beginning, select the first label field from the table and go to the Mailings.
- Next, select the option Insert Merge Field.
- Then, from the drop-down click on label First_8Name.
- Now, the field First_Name appears in the first box of the table.
- Like the previous step input all the labels one by one.
- To apply this change in the remaining records of the table select the option Update Labels from the Mailings tab.
- Lastly, we get a page like the following one.
Related Content: How to Print Multiple Sheets in Excel (7 Different Methods)
Step-6: Link Word File and Excel Worksheet to Print Labels in Excel
In this step, we will connect our Word file with an Excel worksheet. Let’s see how we can do this:
- Firstly, go to the Mailings tab and select the option “Finish & Merge”.
- From the drop-down, select the option Edit individual Documents.
- Secondly, a new pop-up box will appear named “Merge to New Document”.
- Check the box All and click on OK.
- Lastly, a new document for labels will open. We can see that the labels are inserted one by one on the page in the format we wanted.
Step-7: Use Created File to Print Labels in Excel
So, it’s time to print the labels which we created in the previous step.
- First, go to the File tab.
- Next, select the option Print.
- Finally, the label will be printed like the following figure.
Related Content: How to Adjust Print Settings in Excel (8 Suitable Tricks)
Things to Remember to Print Labels in Excel
- After creating the labels don’t forget to save them for future use.
- Blank cells in rows or columns return inappropriate results. So, try to avoid them.
- Use one column at a time for each label. Otherwise, this method will not work.
In the end, this tutorial was a complete guide about how to print labels in excel. Download the practice worksheet that comes with this article to put your skills to the test. If you have any questions, please leave a comment in the box below. We’ll do our best to respond as soon as possible. Keep an eye out on our website “Exceldemy” for more interesting Microsoft Excel solutions in the future.