Create a sheet of sequential barcode labels in Microsoft Excel

Step 1. Create a list of sequential numbers

  • Click on Sequential to open BarCodeWiz Sequential Number Generator
  • Enter ABC as the Prefix and click on Generate Data Now. This creates 100 cells of text with values of ABC001 through ABC100.
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