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?
- 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.
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