Code 39 Barcode Add-In for Microsoft Excel

No barcode Code 39 font, Excel macro, formula, VBA to create and print 1D & 2D barcode images in Office Excel spreadsheet

Add Code 39 barcode images into your Excel spreadsheets using this barcode generator add-in

In this Excel user guide, you will learn how to generate, insert Code 39 barcode images in Microsoft Office Excel documents.

Code 39 standard mode, and full ASCII mode
Code 39 check digit
Code 39 barcode dimension size
Code 39 special characters encoding
Support latest version of Office Excel for Windows

How to create Code 39 barcodes in Office Excel?

Download Code 39 Barcode Generator Excel Add-on
Install barcode add-on to create Code 39 barcodes in Excel files
Step by Step Tutorial

ON THIS PAGE:

Overview
Introduction
Code 39 Data Characters Encoding
Code 39 Barcode Dimension Size
How to create Code 39 in Excel

Completely compatible with Microsoft Office Excel 2019, 2016, 2013, 2010 and 2007
Easy to install barcode add-in, without any barcode font, macro vba required
Free barcode add-in software downloads. Complete demo source code included.
Easy to create batch Code-39 from a list of cells
Code 39 specifications are not required for inserting barcode images
Industry standards of Code 39 are well pre-configured
No programming knowledge and no barcode fonts are needed
Create Code 39 barcodes in Excel spreadsheets within a few seconds
Article lists or catalogues may be produced without any effort
Print high quality Code 39 images with both high and low resolution printers

A quick video tutorial for making, printing Code 39 in Excel

Top

Summy:

Quick to create a Code 39 barcode
How to generate a valid Code 39 barcode data
How to create Code 39 image by using selected cell data
How to create a high resolution Code 39 image for printing
How to generate list of Code 39 barcodes in Excel
Install & uninstall barcode Excel add-in

Introduction of Code 39 Barcode Generator Add-In Software for Excel

Top

Barcode Add in for Excel is an advanced and efficient barcode generator, which is used to insert Code 39 barcode images into spreadsheets in seconds. And this add-in can conveniently and quickly generate both a single image and barcode lists of Code 39.

OnBarcode.com provides not only Code 39 Barcode Add in for Excel, but also other linear and 2D barcode excel generator add-ins which support creating Code 128, EAN, UPC, GS1 128, Interleaved 2 of 5, Postal Codes, QR Code, Data Matrix and PDF-417.

Easy to embed Code 39 bar codes into Microsoft Office Excel spreadsheet with a few clicks.
Single Code 39 barcode as well as Code 39 barcode lists can be inserted easily and fast in Excel spreadsheets.
Each selected cell may be converted into Code 39 barcodes with a click and the barcode can be changed automatically with the content of the linked cells.
Parameters of Code 39, including barcode size, barcode types, check digits, rotation, colors etc, are all adjustable.
Thermal printers are supported for printing high quality barcode images on low resolution printers.
Checksum digit may be computed and added automatically by Excel Code 39 Barcode Add-In.
Code 39 Barcode add-in for Excel is available for Microsoft Excel 2016, 2013, 2010 and 2007 versions.

Code 39 barcode data characters encoding using C#

Top

Code 39 standard mode

Code 39 barcode standard mode supports 43 characters, including

Numeric digit: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9
Uppercase letters (A - Z)
Special characters: - (Dash), $ (Dollar), % (Percentage), (Space), . (Point), / (Slash), + (Plus)
Start/Stop character

In Excel code 39 barcode generator, you need choose Barcode Type property value "CODE 39".

Code 39 Full ASCII mode

Code 39 supports encoding the full 128 character ASCII character set in accordance with ISO 646 IRV.

In code 39 barcode generator for Excel, you need choose Barcode Type property value "CODE 39 EX".

Code 39 barcode check digit

Code 39 barcode does not include a checksum or check digit by default.

For applications requiring enhanced data security, the modulo 43 (MOD43) check character may be used as a check digit.

You can view the barcode Code 39 check digit calculator in details

In excel barcode add-on property panel, go to tab "1D Barcode", and check property Add checksum char, and click button "Update". You will find that the barcode image has been updated with check sum digit ("Z") added.

Do not display Code 39 barcode check digit in HRI

You can also enable code 39 check digit, and hide it in the HRI (human readable interpretation).

In Excel Barcode Property Setting panel, go to tab "1D Barcode", and uncheck the option "Display checksum char".

Click button "Update" to refresh the generated Code 39 image with check sum enabled, but check sum digit hidden.

Code 39 barcode Start/stop characters

Code 39 barcode uses asterisk character (*) as Start and Stop characters, and it should not be part of the Code 39 barcode data.

In Excel Code 39 generator, you can display or hide start/stop characters (asterisk *) through check property Show start stop (*) under tab 1D Barcode.

Code 39 Barcode Dimension Size in Excel

Top

In Excel Code 39 barcode generator, you can use the following barcode dimension size settings:

Auto resize: Check this option to enable automatically use maximum bar width and height
Unit of Measure: You can choose PIXEL, CM or INCH.
Image width: Code 39 barcode image width
Image height: Code 39 barcode image height
Bar width (X): Width of narrow element. The mimumum bar width is defined by the application specification
Bar height (Y): Bar module height.
width to narrow bar ratio: Wide/narrow ratio. the valid value is from 2.0 to 3.0 inclusive.
I: Width of intercharacter gap
- minimum gap is equal to X
- maximum: for X < 0.287mm, is 5.3X; for X >= 0.287mm, is 1.52mm or 3X, whichever is greater.
Text margin: Space between bar and text below
Left margin, Right margin: Quiet zone. the minimum width of quiet zone is 10X.
Top margin, Bottom margin: Quiet zone.

You can view the Code 39 Barcode Size Calculator here.

Insert Code 39 Barcodes into Excel

Top

How to Generate a Code 39 Barcode for Excel

Firstly, activate "Barcode Settings" panel to choose "CODE 39" and type required data. Then click "Generate" to create the single Code 39 image into the Microsoft Excel workbook (To remove it, click "Delete").

How to Configure Code 39 within Setting Panel on Excel

Basing on the generation of Code 39 barcode image, switch to "Barcode Size" and "1D Barcode". The start and stop character can be shown or hidden. Besides, users also can check "Apply title (~)" to enable GS1 Application Identifiers and some special characters to be encoded. After that, click "Update".

How to Create Code 39 Barcode List in Excel

Apart from a single Code 39 image, the Excel Barcode Add-In allows barcode lists or tables to be created. Choose a column of cells with data, and select "CODE 39". And then click "Generate".

How to Link Code 39 to Cell for Excel

Generate a Code 39 barcode image, and click "Link To Cell". Then select a cell with data, and click "Update". The Code 39 barcode image has been linked to the required cell successfully. Meanwhile, linking multiple Code 39 images to cells is also able to be implemented by clicking "Update Link To Cell".

More detail will be represented by OnBarcode.com with Integration Tutorial for Office Excel Barcode Generator.

Barcode Types Supported by Excel Barcode Generator

Top

1D / Linear Barcodes

2D / Matrix Barcodes: Data Matrix, PDF417, QR Code