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 BC1 as the Prefix and click on Generate Data Now. This creates 100 cells of text with values of BC1001 through BC1100.
![](https://media.barcodewiz.com/images/18227d72-7016-4ff2-b1f4-dc28552b44a2-code39_sequential_excel1.png)
Step 2. Open the Labels Wizard
- Click on Labels with the cells still selected, to open the wizard.
![](https://media.barcodewiz.com/images/566a3437-d386-4360-b2a2-b63c1d6abbcf-code39_sequential_excel2.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/4cb55650-b09a-494c-9cd7-878b37b4eff1-code39_sequential_excel3.png)
Step 4. Create the labels
- With the correct label now selected, click on Create Labels Now
![](https://media.barcodewiz.com/images/45bbf4e8-ac9a-441e-8c92-6e8a4a210283-code39_sequential_excel4.png)
- Barcode labels are now formatted, ready to print or save.
![](https://media.barcodewiz.com/images/502d840a-ed1b-427f-82d4-40f22201bc23-code39_sequential_excel5.png)