Create a sheet of sequential Interleaved 2 of 5 barcode labels in Excel

Step 1. Create a list of sequential numbers

  • Click on Sequential to open BarCodeWiz Sequential Number Generator
  • Click on Generate Data Now. This creates 100 cells of text with values of 001 through 100.
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