How to Print Barcode Labels in Excel – 4 Steps

Step 1 – Prepare Data

The dataset showcases products and their price.

• Add a column with the heading “Barcode” and enter the values of the column ID adding an asterisk(*) at the beginning and the end of the value.

Read More: How to Use Barcode Scanner in Excel

Step 2 – Preparing a Barcode Template in Word

• Open a new Word document.
• Go to the Mailings tab, and click Start Mail Merge> Labels.

• In the dialog box, select New label.

• Customize the dimension of the Label details dialog box and click OK.

• Select the label you created and click OK.

Read More: How to Use Barcode Scanner for Inventory in Excel

Step 3 – Inporting Data from Excel

• Go to Select Recipients and choose Use an Existing List.

• Select your Excel workbook and click Open.

• Choose the worksheet.

• Go to Insert Merge Field and select ID.

• Select the other headings one by one.

Read More: Barcode Scanner Entry to Excel Database with Timestamp

Step 4 – Generating and Printing Barcode Labels

• Select <<Barcode>> and change the text format to BARCODE.
• Use the font Code128.
• Install the font with the help of Microsoft Support.

• The Barcode format will be displayed. Click Update Labels.

• Your data is updated.

• Click Preview Results and you will see Barcodes for different items.

• Go to Finish & Merge>Edit Individual Document.

• Select All and click OK.

• This is the output.

• Press CTRL+P, select your printer, and click Print.

Read More: How to Move Barcode Scanner to Next Row in Excel

Download Practice Workbook

Related Articles

• How to Make Auto Enter with Barcode Scanner in Excel
• Creating Barcode Scanner to Track Check in & Check out Time in Excel.
• [Solved] Barcode Scanner Not Going to Next Line in Excel
• Creating a Barcode Scanner Macro in Excel

<< Go Back to Barcode in Excel | Learn Excel