Create a sheet of sequential Code 39 barcode labels in Excel

Step 1. Create a list of sequential numbers

  • Click on Sequential to open BarCodeWiz Sequential Number Generator
  • Enter BC1 as the Prefix and click on Generate Data Now. This creates 100 cells of text with values of BC1001 through BC1100.
Generate sequential numbers

Step 2. Open the Labels Wizard

  • Click on Labels with the cells still selected, to open the wizard.
Click on the Labels Wizard

Step 3. Select the label format

  • Click on Select a different label... and choose Avery US 5160 (3 x 10) from the list. Click OK.
Select the Avery Format

Step 4. Create the labels

  • With the correct label now selected, click on Create Labels Now
Create the labels
  • Barcode labels are now formatted, ready to print or save.
Barcode labels are ready to print