How to Print Barcode Labels in Excel (with 4 Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

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.

Print Barcode Labels in Excel

  • 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.

Print Barcode Labels in Excel Sheet

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.

Printing Barcode Labels in excel

  • A dialogue box will show up and select New label from it.

Print Barcode Labels in an Excel Workbook

  • Customize the dimension of the dialogue box named Label details and press OK.

Printing Barcode Labels in an Excel Worksheet

  • Now, select the label you have just created and click OK.

Print Barcode Labels in Excel Workbook

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.

Print Barcode Labels in Excel

  • 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!


Related Articles


<< Go Back to Barcode in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rafiul Hasan
Rafiul Hasan

Rafiul Hasan, holding a BSc in Naval Architecture and Marine Engineering from Bangladesh University of Engineering & Technology, contributes significantly to the ExcelDemy project with almost 1.6 years of dedicated work. Currently an Excel and VBA Content Developer, he has a passion for problem-solving. Authoring over 100 articles for ExcelDemy showcases expertise in Microsoft Office Suites and Data Analysis. In addition to content development, Rafiul actively engages with the ExcelDemy forum, offering valuable solutions to user queries and... Read Full Bio

4 Comments
  1. 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

  2. Thanks for Sharing this information. it is very helpful for me

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo