I’m a pro label maker. Just kidding, I’m not. In this post, I want to share with you how to quickly create labels with Microsoft Excel and Microsoft Word. There is nothing fancy about this. It’s a pretty easy and simple process. I think that teachers, educators, church leadership, and lay staff could appreciate this helpful walk through. I did this process on a Mac, but the idea is the same even if the button aren’t in the same place.
Easy barcode creation in Excel This very easy to use barcode font package for Excel 2010 or higher creates all common linear barcodes for retail and warehousing. The fonts are bundled with an Excel Add-In that handles all data conversion, check digit calculation etc.
Step 1
Create a list in Excel.
Pretty simple. Now save it somewhere where you can easily locate it. You can’t create labels in Excel without having an Excel spreadsheet first!
Step 2
Now open up Word. Click Tools, Mail Merge Manager (or labels…)
1. Click Create New, Labels. Pick what type of labels you have.
2. Now click “Get List” and choose Open Data Source… then open your Excel file.
Step 3
Insert your placeholders. These essentially tell the document where to put things. I drag them over into an entry and then copy and paste them into every little slot. I think that there is a faster way to do this on a Windows machine. Again, the logic is the same. Make sure after each one to put <<Next Record>>.
Step 4
Complete the merge. You can either open up a new documents with your labels or print directly. I like to open mine first.
- Merge to New Document
- Merge to Email
When you merge to a New Document, you get this:
Which you can also print.
That’s all folks!
Need more help? Want a video tutorial? Comment below and let me know!