You can trust PC Guide: Our team of experts use a combination of independent consumer research, in-depth testing where appropriate - which will be flagged as such, and market analysis when recommending products, software and services. Find out how we test here.
If you want to know how to print address labels from Excel, we’ve got you covered.
Mail merge in Excel is an amazing feature that can help send emails in bulk, but you can also use it to print address labels. The entire process revolves around preparing the label data and then using the mail merge feature to print them. However, for those who are new to Excel, the process can be challenging.
This is where we come in. In this guide, we will walk you through how to print address labels from Excel. So, without any further ado, let’s get started!
Scenario on hand: We have a fictional dataset of customers with their titles, first names, last names, street addresses, city, state, and ZIP code.
What we want to accomplish: Explore how to create address labels using Excel and Word by following along a step-by-step guide:
The first step is to accumulate your dataset in one Excel sheet and clean the data, with each entry in the correct column.
If you start with the label-making process before gathering and cleaning your data, you will end up with a disuniform format or missed packages because of wrong address labels.
When you’re creating columns for address labels, here are some columns to add to your data:
For our demonstration, we have created a dataset of 9 addresses. Note that the columns are on the first row of the worksheet:
Step 2: Using Word to create labels
With your Worksheet saved, it’s time to open Microsoft Word, where you’ll select the types and sizes of your labels.
First, open a new Word document. At the top of the screen, select the “Mailings” option. From the options that appear below, select the “Start mail merge” box. From the drop-down that opens, select “Labels…”
Step 3: Connect your worksheet to your labels
Now that the label type and size are set up, you need to connect the Word document with the data on the Excel worksheet.
First, open Word and select “File” at the top right. From the side panel that opens, select “Options.”
Step 4: Mail merge
Finally, go to “Mailings”. There, select “Address Block.” Find the button that says “Match Fields…” on the bottom right, ensure your headings are in the correct places and hit “OK.”
Step 5: Previewing and finalizing labels
Click “Preview Results” to adjust the spacing and ensure everything is okay.
Step 6: Adding borders to your labels
Once you’ve finalized your labels, adding borders to them is a great way to make them look uniform.
The Word mail merge labels feature adds all the information from your Excel workbook in the form of a table.
So, to add borders, go to the top right corner of your sheet to locate an icon that lets you select the table. This will add two more items to the menu on the top: “Table Design” and “Layout.”
Head to “Table Design” to add borders to this table.
Wrapping up
This was everything you needed to know about how to print address labels from Excel. This guide is perfect for businesses that have to ship out packages. Mainly because organizing and cleaning the data in Excel and then using Word’s mail merge feature assures that there is not even a slight chance of error. You can even use this trick to send out your personal Christmas cards or wedding invitations.
Learn more about Excel through these guides:
Andrew is one of three co-founders of BGFG, the parent company of PC Guide. A keen gamer and PC enthusiast, Andrew dabbles in a bit of writing sometimes - when he gets the chance to!
PC Guide is reader-supported. When you buy through links on our site, we may earn an affiliate commission. Read More
PCguide.com is part of the BGFG family of websites. Our mission is to provide you with great editorial and essential information to make your PC an integral part of your life. You can also follow PCguide.com on our social channels and interact with the team there.