Create a Sheet of Sequential Barcode Labels
Step 1. Create a list of sequential numbers
- Click on Sequential to open BarCodeWiz Sequential Number Generator
- Enter 12345678 as the Prefix and click on Generate Data Now. This creates 100 cells of text with values of 12345678001 through 12345678100.
- Please note that this creates an 11-digit number (UPC-A numbers require 12 digits). The 12th digit will be calculated and added automatically.
![](https://media.barcodewiz.com/images/5ab7dd5e-48fc-4f5f-9052-39903320b2b0-excel2.png)
Step 2. Open the Labels Wizard
- Click on Labels with the cells still selected, to open the wizard.
![](https://media.barcodewiz.com/images/482d1e31-a0f9-42ae-afa1-b402a6837937-excel3.png)
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.
![](https://media.barcodewiz.com/images/ca048d79-00d5-4fb4-be3c-f25d7783c596-excel4.png)
Step 4. Create the labels
- With the correct label now selected, click on Create Labels Now
![](https://media.barcodewiz.com/images/b76a0ef7-499b-4550-ae66-58f3225ae512-excel5.png)
Ready!
- Barcode labels are now formatted, ready to print or save.
![](https://media.barcodewiz.com/images/47f43ace-0214-4b42-9112-afe90de75048-excel6.png)