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?



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?

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










  • Completely compatible with Microsoft Office Excel 365, 2021, 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

[Video]: How to download, 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.

Code 39 barcode data characters encoding using C#

Top

Code 39 standard mode

Code 39 barcode standard mode mainly includes digits (0-9), uppercase letter (A-Z) and several special characters. View details at What characters does the Code 39 barcode standard data mode include?
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 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.



Show and hide Code 39 check digit character in HRI

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.



Show and hide Code 39 barcode Start/stop characters

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.

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.

How to make, generate Code 39 Barcodes into Microsoft Excel document?

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
OnBarcode is a market-leading provider of barcode imaging generator, reader controls and components for ASP.NET, Windows Forms, WPF, as well Java, Android, iOS (iPhone, iPad) across all major enterprise development platforms. We provides comprehensive tutorials and how-tos for various linear, 2d barcode information, such as C# in ASP.NET, C# .NET, C# Barcode Encoding, C# Barcode Image, VB.NET in ASP.NET, VB.NET Winforms, VB.NET Barcode Encoding. OnBarcode barcode products are supported by RasterEdge ASP.NET Document Viewer, which supports ASP.NET PDF Viewer, ASP.NET MVC Document Viewer, ASP.NET PDF Editor, MVC PDF Viewer. And provide high quality C# Convert PDF to Tiff, C# Convert PDF to Word, C# Convert PDF to HTML, C# Convert PDF to Jpeg images, and their easy and simple documents, like C# PDF SDK, C# extract text from PDF, C# Compress PDF, Print PDF in C# and C# extract image from PDF.
Terms of Use | Privacy Policy
Copyright © OnBarcode.com . All rights reserved.