Azalea Software, Inc. www.azalea.com Print Code 39 Barcodes in Excel Spreadsheets Code39 Bar Codes in Excel

Printing Code 39 bar codes in your Excel spreadsheets is really very easy. Create Code 39 barcodes using our Excel macros. The macros convert the data in your spreadsheet into a scannable Code 39 barcode.

making Code 39 bar codes in Excel spreadsheetsC39Tools comes with a set of macros that add the necessary start and stop bars to your string. All you have to do is format the string the macro generates in our Code 39 fonts. The sample code makes standard Code 39 symbols as well as Code 39 Full ASCII. If you need to use the optional Code 39 check digit, we have a macro for that too.

Macros and User Defined Functions for Excel 2003 & 2007:
    Code 39  •  Code 39 Full ASCII  •  Code 39 check digit

The macro code & ReadMe for Excel 2004 (Mac):
    Code 39  •  Code 39 Full ASCII  •  Code 39 check digit

Code 39 barcode softwareThe macros above are the easiest and fastest way to use C39Tools and Excel. They're straightforward and self contained. The sample spreadsheets have plenty of comments in them to show you how they work. Feel free to copy them to your spreadsheets.


An alternative is to use the Excel XLA that ships with all of our font packages. The XLA file includes custom functions that create barcodes in your spreadsheets. Download AzaleaBarCodes.xla into your XLStart directory (Program Files\Microsoft Office\OFFICE11\XLSTART). If you're running Windows XP or Vista, insert barcode.dll into your \WINDOWS\SYSTEM32 directory. On Windows 2000, Windows Server, or WindowsNT, put barcode.dll in your \WINNT\SYSTEM32 directory. Reboot your computer and our barcode functions will appear as a user defined function in Excel.

C39Tools' installer automatically places the files you need in the appropriate folders for you. If you need to do it manually yourself, place AzaleaBarCodes.xla into your XLSTART directory (Program Files\Microsoft Office\OFFICE11\XLSTART or OFFICE12\XLSTART) and put barcode.dll into either your \WINDOWS\SYSTEM32 or \WINNT\SYSTEM32 directory.

Open your Excel spreadsheet.

We’ll assume that your input data is in the A column and that we want to create your barcodes in the B column. Type the equal sign "=" in cell B1.

Insert a new formula

The available functions drop down list becomes active (black arrow above A1 cell). You can alternately go your menu and select Insert and then Function.

Name your formula

Choose “More functions,” and a second window will pop open. Then choose “User defined” and Azalea’s Code 39 functions appear. Select “AzaleaCode39” or “Azalea Code39ASCII” as appropriate, then click the OK button.

Choose a function

Choose the cell that your data is in; in our example, it’s cell A1. Click OK.

Enter a database field name

Select formula name

Choose cell B1 and then Format>Cell>Font. Select an Azalea Code 39 font from the list and then set the point size.

Select formula name

It’s a good idea to center your barcode in the cell. To do so, click the “Alignment” tab and then Center for horizontal and perhaps vertical.

Then to copy our work over to all our cells in the B column, choose Edit>Fill>Down, or press shift-enter in cell B1.

Select formula name

Now it’s time to print our barcodes! In this case where we have four examples, select A1-A4 / B1-B4, and then File>Print>Preview.

Select formula name

Your print preview will come up and it should look like this. 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.

Select formula name

Need help? Email us at azalea at azalea dot com or call 1.206.341.9500