UPC, EAN, JAN, Bookland (ISBN), and ISSN Bar Codes in Excel
When you need to make UPC, EAN, and ISBN-13 (Bookland) barcodes in Excel, all you need is our Excel plug-in. Azalea’s Excel plugin adds the guard bars, calculates the check digit, and maps the output into our fonts’ character set.
If you need to make UPC bar codes in your Excel project, just install Azalea UPCTools and then reboot. On Windows XP and Vista, it will automatically place the files you need to make bar codes in Excel. If you’d prefer to do it manually, download AzaleaBarCodes.xla into the XLSTART directory (Program Files\Microsoft Office\OFFICE11\XLSTART or OFFICE12\XLSTART). Then you’ll just need to put barcode.dll into either your \WINDOWS\SYSTEM32 or \WINNT\SYSTEM32 directory.
Open your Excel spreadsheet with the data you’re looking to make into barcodes.
Enter your 11-digit UPC number (your prefix + the item number you create) in the cells you want to encode into bar codes. In this example, our “input data” column is Column A.
Pick the cell that you want to contain the bar code symbol; in this case, we’ll use B1. Type the equal sign “=”.
The available functions drop down list opens (black arrow above A1 cell). You can also get to these functions by choosing Format>Insert Function from the menu.
You want to choose “More functions;” this will make another window pop open. Pick “User defined,” which will make Azalea’s UPC functions appear. Select “AzaleaUPC_A” or whatever type of bar code you need. Click the OK button.
You’ll see a box called “Function Arguments” You just need to input the cell location that has the data you want to make into a UPC; in our case, that’s the content of cell A1. Click the OK button.
Select B1. Choose the “Format” menu, pick “Cell” then click the “Font” tab. Select a UPC font and point size (73 points for a full-sized symbol. Your symbol must be at least 60 points to be a scannable UPC barcode.
It’s a good idea to center the barcode in the cell. To do so, click the “Alignment” tab and choose Center for both horizontal and vertical.
Your completed barcode project should look like this. It’s time to print our barcodes!
Select A1-A4 and B1-B4. Choose “File” and then Print and Preview from the menu. Once you’re ready to print your barcodes, press “Print.” If the output result differs or you see boxes or odd characters in the preview, please send a screenshot to technicalsupport at azalea dot com and we’ll be happy to help you get it sorted out.
