Barcode Label Creation

Barcode Label Creation

Open Microsoft Excel file
Enter your starting label number in A1 slot
Enter =a1+1 in the A2 slot (underneath)
On the bottom right hand corner of the A2 box click and drag the box down to the number of labels you want to create, the numbers in between should fill in the boxes
Now— Save As.. enter a file name
on “Save as type:” find “CSV (comma delimited)
click save
Click OK in first box that appears
Click Yes in 2nd box that appears

Open the Avery Label Pro 3 file
In Avery Pro – you should have your label template – open the template
Click on Data in top toolbar
Go to Link List to Design
in the Files of type: box put in “Delimited Win(*csv,*txt) from drop down menu
find your excel file
click on open
After opening the file
Go to File and Print.

 

 

 

____________________________________
Cory Stokes
SEDC-Educational Technology  Coordinator
Office 435-586-2865

About Chris Haught 176 Articles
Chris is the Media Mentor at SEDC, she loves to help students, librarians and teachers to discover new ways to use technology to enhance their learning.

Be the first to comment

Leave a Reply

Your email address will not be published.


*


This site uses Akismet to reduce spam. Learn how your comment data is processed.