How to Print Labels From Excel
You can print mailing labels from Excel in a matter of minutes using the mail merge feature in Word. With neat columns and rows, sorting abilities, and data entry features, Excel might be the perfect application for entering and storing information like contact lists. Once you have created a detailed list, you can use it with other Microsoft 365 applications for numerous tasks.
Prepare the Worksheet and Enter the Data
To make mailing labels from Excel, you need to add descriptive column headings so everything prints out correctly. For example, you might have the following column headings:
Title (Mr./Ms./Dr.)First NameLast NameStreet AddressCityStateZIP Code
Set Up Labels in Word
Next, you need to choose the size and type of the labels you’re printing.
Connect the Worksheet to the Labels
Before performing the merge to print address labels from Excel, you must connect the Word document to the worksheet containing your list. The first time you connect to an Excel worksheet from Word, you must enable a setting that allows you to convert files between the two programs.
Add Mail Merge Fields and Perform the Merge
After you’ve organized the data, you need to add mail merge fields before you can complete the merge. This is where those headings you added to your Excel worksheet will come in handy.
