How to Print Labels From Excel: 6 Easy Steps

Explore these expert-tested steps to get it done

by Loredana Harsana
Loredana Harsana
Loredana Harsana
Managing Editor
Loredana is a passionate writer with a keen interest in PC software and technology. She started off writing about mobile phones back when Samsung Galaxy S II was... read more
Reviewed by Alex Serban
Alex Serban
Alex Serban
Windows Server & Networking Expert
After moving away from the corporate work-style, Alex has found rewards in a lifestyle of constant analysis, team coordination and pestering his colleagues. Holding an MCSA Windows Server... read more
Affiliate Disclosure
  • If you have an address list in an Excel spreadsheet, the easiest way to create labels is Word's Start Mail Merge feature.
  • This guide will help you with step-by-step instructions to print labels from Excel.
How to Print Labels From Excel 6 Easy Steps

XINSTALL BY CLICKING THE DOWNLOAD FILE
To fix various PC problems, we recommend Restoro PC Repair Tool:
This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove viruses now in 3 easy steps:

  1. Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues affecting your computer's security and performance
  • Restoro has been downloaded by 0 readers this month.

Printing labels from a mailing list maintained in Excel can be tricky. However, it can be done with some help from Word’s Start Mail Merge feature. 

In this guide, we will discuss step by step process to print labels from Excel. Let’s get started! 

Can you print labels directly from Excel?

Yes, you can print labels directly using Excel. However, doing so will not give you many options to customize the labels. Also, it is a bit tricky. Therefore, it is advised to use Word’s Start Mail Merge feature and Excel data to create labels from the mailing list.

How do I print labels from an Excel spreadsheet?

Before proceeding with the steps, go through the following preliminary checks:

  • First, make sure your data is uniformly formatted and mistake-free.
  • To make mailing labels, you need to add descriptive column headings.
  • Double-check to ensure that there is no blank row or column within the list.
  • Create separate columns for the title, first and last name, street address, etc.

1. Prepare the worksheet in Excel

  1. Launch Excel and open a spreadsheet.
  2.  Segregate the details in individual columns; the header should be Title, First Name, Last Name, Street Address, City, State, and ZIP code.Arrange your data - Print labels EXCEL
  3. Fill in the data accordingly, go to File, and then click Save from the left sidebar.
  4. Now click Browse, name the file, and save it in the desired location.Browse

2. Setup labels in Word

  1. Launch Microsoft Word on Windows; under New, click Blank document.
  2. Select the Mailings tab from the toolbar, click Start Mail Merge, and choose Labels from the menu.Start Mail Merge
  3. From the next window, Label vendors dropdown menu, choose the label vendor.
  4. Select a label type from the Product number list.Label options
  5. Click the New Label button and choose label dimensions.Label Details
  6. Now, click OK and OK again.

3. Connect labels and worksheet

  1. On the Word document, go to the Mailings tab and Select Recipients.
  2. Click on Use an Existing List to use that Excel sheet you created.Mailing list
  3. From the File Explorer window, please navigate to the spreadsheet and double-click on it.
  4. On the Select Table window, click on the Sheet that you want to use. Then, put a checkmark on the First row of data containing column headers and click OK.Select table

4. Add mail merge fields

  1. On labels document on Word, go to the Mailings tab, and click the Address Block option.
  2. On the Insert Address Block window, click Match Fields.Match fields
  3. Now on the Match Fields window, under Required for Address Block, make sure the entries are correct and are the same as mentioned in the spreadsheet.Match Fields 2
  4. Click OK
  5. Now on the Insert Address Block window, you will get a preview of the label created. Please double-check it and Click OK.
  6. In the first label on the Word document, it should say AddressBlock. Next, go to the Mailings tab, then click Update Labels. After that, all the titles will automatically display AddressBlock.Update labels
  7. On the Mailing tab, click Finish & Merge option and choose Edit Individual Documents. Edit doc
  8. On Merge to Document, Select All and click OK.Merge to new document

5. Save labels as PDFs & print them

  1. Go to File and click Save as on Word document.
  2. Select Browse, then go to Save as type, choose PDF as file type, and save it with a name. Click Save.
  3. Go to the File tab on Word and click Print.Print
  4. Select your printer from the available options and click Print.

How to print labels from Excel in Word?

To print labels from Excel using Word, you need to use the Start Mail Merge feature available on Word. The feature makes it easy to customize the labels and also saves time.

So, these are easy steps to print labels from Excel in no time. Please let us know in the comments section below if it worked for you.

Still having issues? Fix them with this tool:

SPONSORED

If the advices above haven't solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on TrustPilot.com) to easily address them. After installation, simply click the Start Scan button and then press on Repair All.

This article covers:Topics: