Suppose you have a list of Barcodes for various types of products in an Excel worksheet and you need to print the Barcode Labels. In this article, I’ll show you how to print Barcode Labels in an Excel workbook.
How to Print Barcode Labels in Excel: 4 Easy Steps
In this section, you’ll find a method for printing Barcode Labels in an Excel Spreadsheet. Let’s check them now!
Step 1: Gather and Prepare Data in Excel
First of all, you need to gather the required data and arrange them in an Excel sheet in a preferable manner.
Let’s say, we have a dataset of various products and their price. So, we’ve stored the data in the following way.
- Now, add a column with the heading “Barcode” and fill the cells with the values of the column ID by adding an asterisk(*) at the beginning and the end of the value.
Read More: How to Use Barcode Scanner in Excel
Step 2: Barcode Template Preparing in Word
Now, we need to prepare a template in Word to adjust the barcode labels.
- Open a new Word document, Go to the Mailings tab, and click Start Mail Merge> Labels.
- A dialogue box will show up and select New label from it.
- Customize the dimension of the dialogue box named Label details and press OK.
- Now, select the label you have just created and click OK.
Read More: How to Use Barcode Scanner for Inventory in Excel
Step 3: Bringing Data from Excel
Now, we need to bring the list from the Excel workbook. You can create a new list if necessary!
- Go to Select Recipients and choose Use an Existing List.
- Select your Excel workbook and click Open.
- Choose the worksheet which contains your data.
- Go to the Insert Merge Field and select ID (by which you want to merge).
- Select the other headings one by one.
Read More: Barcode Scanner Entry to Excel Database with Timestamp
Step 4: Generating and Printing Barcode Labels
It’s time to generate and print the Barcode labels, to do so,
- firstly, Select <<Barcode>> and change the text format to BARCODE. You will need Code128 font for this. Install the font with the help of Microsoft Support.
- Barcode format will show up for the text. Now click Update Labels.
- Your data will show up being updated.
- Click Preview Results and you will see Barcodes for different items.
- Go to Finish & Merge>Edit Individual Document.
- Select All and click OK.
- Your result will be ready.
- Type CTRL+P, select your printer, and click Print. You’re done!
Thus we can create and print Barcode Labels in Excel.
Read More: How to Move Barcode Scanner to Next Row in Excel
Download Practice Workbook
Conclusion
In this article, we have learned how to print Barcode Labels in Excel. I hope from now on you can easily print Barcode Labels in an Excel Workbook. If you have any queries regarding this article, please don’t forget to leave a comment below. Have a great day!
Hi,
I got it to work the very first time but when I go back to do it again it’s not working, when click on the next records the Font Code128 just changes back to the normal font, is there something I am missing. I try changing the labels manually but the final result is only the text. I want to print 51 labels per A4 sheet.
Thanks
Ken
Hi KEN,
This may encounter from several reasons.
1. If you have protected the worksheet or specific cells, it can prevent changes to the font settings. Try unprotecting the cells or the entire worksheet to see if that resolves the issue.
2. If there are any conflicting formatting applied to the cells, it might cause the barcode font to revert. Select the cells and clear any formatting such as bold, italic, or color changes. Then, set the font to “Code128” again.
3. Ensure that the page setup and print preview are correctly configured. Check the scaling options to make sure that the labels fit properly on the A4 sheet. Adjust the margins and other settings as needed to accommodate 51 labels per sheet.
4. If the above steps don’t solve the problem, try creating a new Excel file and follow the barcode printing steps from scratch. This can help identify if the issue is specific to your existing file.
Regards,
Rafiul Hasan
ExcelDemy Team