How to Print Labels in Excel (With Easy Steps)

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.

Insert Data in Excel Worksheet for Labels

Read More: How to Print Address Labels in Excel (2 Quick Ways)


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.

Check the Confirm File Format Conversion Status in Microsoft Word

  • Secondly, from the File tab select Options.

Check the Confirm File Format Conversion Status in Microsoft Word

  • 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.

Arrange Labels in Word Document to Print Labels in Excel

  • A new dialogue box named “Label Options” will appear.
  • From the dialogue box select the options as shown in the figure and press OK.

Arrange Labels in Word Document to Print Labels in Excel

  • 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.

Arrange Labels in Word Document to Print Labels in Excel

Read More: How to Set Print Area in Excel (5 Methods)


Similar Readings


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.

Import Excel Data in Microsoft Word Document

  • Fourthly, browse and select the excel file. Click on “Open” to import data.

Import Excel Data in Microsoft Word Document

  • 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.

Import Excel Data in Microsoft Word Document

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.

Insert Mail Merge Fields in Microsoft Word

  • Now, the field First_Name appears in the first box of the table.

Insert Mail Merge Fields in Microsoft Word

  • 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.

Insert Mail Merge Fields in Microsoft Word

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.

Link Word File and Excel Worksheet to Print Labels in Excel

  • 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.

Link Word File and Excel Worksheet to Print Labels in Excel

Read More: How to Print Excel Sheet with Lines (3 Easy Ways)


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.

Use Created File to Print Labels in Excel

  • Next, select the option Print.

  • Finally, the label will be printed like the following figure.

Use Created File to Print Labels in Excel

Related Content: How to Adjust Print Settings in Excel (8 Suitable Tricks)


Things to Remember to Print Labels in Excel

  1. After creating the labels don’t forget to save them for future use.
  2. Blank cells in rows or columns return inappropriate results. So, try to avoid them.
  3. Use one column at a time for each label. Otherwise, this method will not work.

Conclusion

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.


Related Articles

Mukesh Dipto

Mukesh Dipto

Hi there! I am Mukesh Dipto. I graduated with a bachelor's degree in engineering. Currently, I am working as a technical content writer in ExcelDemy. You will find all my articles on Microsoft Excel on this site. Outside of the workplace, my hobbies and interests include sports and meeting new people. I also enjoy sports. My favorite sports are football (to watch and play) and Badminton (play).

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo