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
2. Setup labels in Word
3. Connect labels and worksheet
4. Add mail merge fields
5. Save labels as PDFs & print them
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.
SPONSORED
Name *
Email *
Commenting as . Not you?
Save information for future comments
Comment
Δ
