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 ABC as the Prefix and click on Generate Data Now. This creates 100 cells of text with values of ABC001 through ABC100.
![](https://media.barcodewiz.com/images/480ff86f-c2e8-45d1-8804-9e713271b9f8-excel003.png)
Step 2. Open the Labels Wizard
- Click on Labels with the cells still selected, to open the wizard.
![](https://media.barcodewiz.com/images/3f1d9659-6426-45f5-9b83-7737636dd403-excel004.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/b0ce644c-2395-4a6c-8e17-d93720214bb5-excel005.png)
Step 4. Create the labels
- With the correct label now selected, click on Create Labels Now
![](https://media.barcodewiz.com/images/f23d2c41-326a-43bc-aa2c-8d06c8e3b161-excel006.png)
- Barcode labels are now formatted, ready to print or save.
![](https://media.barcodewiz.com/images/6825512e-0190-4686-9d30-947718947d58-excel007.png)