How to generate Code 39 Barcode in Excel w/o download font,
Excel formula?

Free download. No barcode font to create Code 3 of 9 barcode in Excel

How to generate Code 39 barcode into your Excel spreadsheets using this barcode generator add-in without download font, formula, macro program?

Excel Code 39 Generator is FREE now!

Code 39 Generation in OnBarcode Excel Barcode Generator Add-in is FREE now!

You can download the free trial version of Barcode Add-in and create Code 39 and Code 39 extension barcode images in Excel without any watermark.

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

Generate barcode Code 39 with data in alphanumeric, or full ASCII characters
Create Code 39 in Microsoft Excel 365 on Windows, also supports Excel 2021, 2019, 2016, 2013, 2010, 2007
Automatically calculate Code 39 check sum character if needed.
Easy to customize the Code 3 of 9 barcode image dimension size, image dpi, colors in Excel barcode property pane
Quick to generate a single Code 3 of 9 or multiple Code 39 barcodes with few clicks
Free to download Excel barcode add-in without any font, COM control, Excel fomula, VBA, Macro programming skills.

How to create Code 39 barcodes in Microsoft Office Excel without font, formula, Macro?

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

[Video]: How to create Code 39 barcodes in Excel without font, Excel fomula.

Top

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

You could learn more user guide to generate and customize Code 39 barcodes in Office Excel document at
How to generate, customize barcodes in Microsoft Excel?
How to make, print bulk barcodes with list of Excel Cell value in Microsoft Excel sheet?
How to create barcodes in Word mail merge using data from Excel?
How to create and print barcode with customized image width and height in Excel?

OnBarcode.com provides Barcode Generator software (not font) for Excel Add In to generate ISO standard Code 39 barcode in Microsoft Excel document. The barcode generator software also supports Code 128 for ms excel, EAN-13 generator for excel, UPC-A barcode add-in for excel, QR Code generator for excel, Data Matrix for excel, etc.

Quick to Create Code 39 Barcode in Excel

Top

After you have installed the Excel Barcode Generator add-in, you can quickly create and insert Code 39 barcode image to the Excel cells.

Open an Excel file using Microsoft Excel application.
Open Excel Barcode Add-in by selecting Create Barcode under the Excel toolbar "Add-ins" tab.
In cell B2, key in text string CODE39-123.
Select cell B2
Choose "CODE 39" in Barcode Type in "Barcode Settings" pane.
Note: Code 39 supports upper-case letters only. If you need encode lower-case letters, you need choose "CODE 39 EX".
Click Generate button to print and insert Code 39 barcode to cell B2.
Now you will find a new Code 39 barcode image has been printed on cell B2. You can use the Update and Delete buttons to update and remove the barcode image.
If you have modified the cell B2 value, the barcode add-in will automatically refresh the Code 39 barcode in Excel.

Create multiple Code 39 barcodes with auto-update in Excel

Top

Now we will demonstrate how to create list of Code 39 barcode images in Excel with few clicks.
This is a sample Excel document we prepared to generate multiple Code 39 barcodes inside. All Code 39 barcodes will be printed on column C and the barcode datas are using from column B cell values.

Create the first Code 39 barcode in Excel

Select cell C4
Choose CODE 39 from Barcode Type
Change Data text box value to =LINK(B4)
Click Generate button
The first Code 39 barcode has been printed on cell C4. You can customize the barcode.

Create multiple Code 39 barcodes by duplicating the first one

Now you can go on printing list of Code 39 barcodes with few selections and one button clicking.

Select the first Code 39 image, and you will find the printed message Copy from: Cell [C4] CODE39 on the "Barcode Settings" pane.
Select three cells from C5 to C7.
And click Duplicate All button.
You find that all three Code 39 barcodes have been printed and inserted to cells from C5 to C7, and they are using the barcode data from cells values from B5 to B7

Code 39 images auto update

If you have modified the values in cells B4 to B7, the linked Code 39 images will be re-printed automatically.

Code 39 barcode data characters encoding in Excel

Top

Code 39 standard mode

Code 39 barcode standard mode mainly includes

Digits (0-9)
Uppercase letter (A-Z)
Several special characters (Dash), $ (Dollar), % (Percentage), (Space), . (Point), / (Slash), + (Plus)
Start/Stop characters

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

Code 39 Full ASCII mode

Code 39 barcode Full ASCII mode supports encoding the all 128 characters in ASCII View details at What characters does the Code 39 barcode Full ASCII data mode include?

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

Code 39 maximum & minimum character size

There are no requirements for Code 39 barcode data maximum or minimum size.

Some barcode scanners will not scan code 39 for less than 4 characters by default. You need update the barcode scanner configuration.

Code 39 barcode check digit

Code 39 barcode check digit is optional. If need, the Code 39 generator software will generate a check digit based on mod 43 algorithm.

You can view the check digit calculator video tutorial at Code 39 check digit calculator.

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.

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.
Wide-narrow ratio (N): Wide bar width / narrow bar 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.

Print Code 39 with customized Barcode Text in Excel

Top

Print or hide Code 39 check digit character in barcode human readable text in Excel

Sometimes, you need insert Codde 39 check digit, but you do not want to display the character in the Code 39 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.

Print or hide Code 39 barcode Start/stop characters in Excel

Like Code 39 check digit, you can also hide the Code 39 Start and Stop characters (asterisk character *) in the Code 39 HRI.

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

Print or hide Code 39 barcode text label in Excel

When you create Code 39 barcode, you can hide the barcode text.

Uncheck "Display barcode text" in "Barcode text style" group under "1D Barcode" tab.

Customize, print Code 39 barcode text style in Excel

OnBarcode Excel Barcode Generator Add-in provides options to customize the barcode text styles (such as text font family, style, size, color).

To change the Code 39 text font family, font style, text color, you try:

Choose the new text font family from "Font" dropdown list in "Barcode text style" group under "1D Barcode" tab.
Change the text font style to "Bold", and font color to red
Click Update to re-make the Code 39 barcode with new font selected

Print Code 39 with specified text font size in Excel

To customize the Code 39 text font size, try the following steps:

Select the Code 39 barcode you need change text font size.
Uncheck Auto resize barcode text in "Width & Height" group under "Barcode Size" tab
Change the Font size to 9 from "Barcode text style" group in "1D Barcode" tab.
Click Update button to re-generate the Code 39 barcode image with new font size applied

Code 39 Bar Style in Excel

Top

Wide vs narrow bar ratio (N)

Code 39 symbol has two bars, wide bar and narrow bar. You can change the Code 39 wide bar vs narrow bar ratio (N) using Excel Barcode Add-in.

Change the "Wide-narrow ratio (N)" value in "Bar Style" group under "Barcode Size" tab. The valid value is from 2.0 to 3.0.

You can compare the two Code 39 barcodes. Top one's N is 2.0. The botton one is 3.0.

Width of intercharacter gap (I)

Width of intercharacter gap (I) is the gap space between two Code 39 encoded characters bar modules.
The minimum of I is the same as X (bar module). The recommended maximum of I is the 3 times of the X (bar module).

Change the "I" value in "Bar Style" group under "Barcode Size" tab. The valid value is from 1.0 to 3.0 in Excel Barcode Add-in.

Common Asked Questions

What is Code 39 barcode used for?

Code 39, also known as Code 3 of 9, was the first barcode to encode both numbers and letters. It is most commonly used in the inventory, government, military and electronics industries. OnBarcode Excel Barcode add-in provides free Code 39 and Code 39 extension generation freeware.

What is the difference between Code 39 and Code 128 barcodes?

Code 128 requires a checksum. If the Code 128 barcode is damaged, it may still be scannable. Code 39 checksum is optional. If the Code 39 barcode without checksum is damaged, it won't be scannable. Using Excel Barcode freeware, you can create Code 39 with or without checksum character in Excel document.

What is the difference between barcode 39 and barcode 93?

Code 93 is an updated version of Code 39. Code 93 is a higher-density barcode type compared to Code 39. OnBarcode Excel Barcode Generator supports both Code 39 and Code 93 barcodes generation in Microsoft Excel document.

Can Code 39 barcode encode lowercase letters in Excel document?

Code 39 barcode standard version does not support lowercase letters encoding. However Code 39 extension version supports. In Excel document, you can create Code 39 barcode with lowercase text using Excel Barcode Add-in freeware.

What is the minimum size for Code 39?

Code 39 barcodes need meet the following size requirements.

Width of narrow element (X): the mimumum bar width is defined by the application specification
BarCode height: the minimum height is 5.0mm or 15% of symbol width (excluding quiet zones), whichever is greater.

Using Excel barcode software, you can customize the Code 39 barcode width and height through property X and Image height

What is the ratio of narrow to wide bars in Code 39 barcode?

The valid ratio of Code 39 narrow to wide bars is from 1:2 to 1:3. You can apply the Code 39 ratio configure through property Wide-narrow ratio (N) in Excel Barcode add-in "Barcode Settings" pane.

How to generate Code 39 Barcode in Excel w/o download font, Excel formula?