Printing labels from Excel – Knowligent
Printing labels from Excel

Printing labels from Excel

HomeHow to, TechPrinting labels from Excel

This guide explains how to create and print labels from Excel using the mail merge feature in Microsoft Word. Instructions apply to Excel and Word 2019, 2016, and 2013, and Excel and Word for Microsoft 365.

You can print mailing labels from Excel in minutes using Word’s mail merge feature. With organized columns and rows, sorting capabilities, and data entry features, Excel may be the perfect application for entering and storing information such as contact lists. Once you’ve created a detailed list, you can use it with other Microsoft 365 applications for a variety of tasks.

To create address labels from Excel, you need to add descriptive column headings so that everything prints correctly. For example, you might have the following column headings:

Type a heading in the first cell of each column that describes the data. Create a column for each element you want to include in the labels.