Code 39, known as Alpha 39, Code 3 of 9, USD-3, Type 39 as well, was invented by Intermec Co. in 1974. It is linear low-density barcode symbology and generally used by American Department of Defense.
Barcode Add-In for MS-Excel provides an easy way for users to integrate and insert Code 39 barcodes and other 30+ linear, postal and 2D barcodes in your Microsoft Office Excel. Code 39 Extension barcodes may also be generated with this barcode add-in for Word.
With Code 39 Add-In for Excel, adjustable sizing options help you get ideal barcode size images as required barcode size field in Excel Workbook. Besides, Code 39 barcode image properties can be easily configured in Excel with rotation, resolution, bar alignment, etc. Here is a detailed guide for making Code 39 barcodes in Excel; more specific guides please see:
encoding Code 39 & Code 39 Extension barcode,
customizing Code 39 & Code 39 Extension barcode image, and
resizing Code 39 & Code 39 Extension barcode.
Code 39 Add-In for Excel Features
| Encodable Characters | Support to encode:
- Numeric data: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9
- Uppercase letters: A - Z
- Seven special characters: -, $, :, /, ., +, space |
| Code 39 Extension Encodable Characters | Support to encode Standard ASCII characters 0-127 (default: ISO/IEC 646) |
| MS-Excel Version | Support Code 39 generation in Microsoft Office Excel 2007 and Microsoft Office Excel 2010 |
| Easy to Install | Easy installation Code 39 Barcode Creator Add-in on Microsoft Office Excel Workbook within a few mouse clicks |
| Size Adjustments | Fully sizing controls available for resizing Code 39 barcode size through module width, wide/narrow ratio, rotation, colors, fonts, alignment etc. |
| Human-Readable Text | The encoded characters in Code 39 is able to be displayed for human reading or not in the MS Office Excel spreadsheets |
Code 39 Add-In for Excel Requirements
Windows OS & .NET Compatible with Microsoft Windows 7/XP/Vista, Windows Installer 3.1, VSTO 3.0 Runtime sp1, and .NET Framework 3.5 sp1. | Microsoft Office Compatible with Microsoft Office Excel Workbook 2007; Microsoft Office Excel Workbook 2010. |
Install Code 39 Add-In for Excel
- Download BizCode Add-In for Microsoft Exceland unzip;
- Closed your Excel and Run the Setup file;
- Open your Office Excel, you will Excel barcode add-in has been installed successfully!
How to Generate Code 39 Barcode in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "Code 39";
- Input some data - "CODE 39" in "Data";
- Click "Generate"; then a Code 39 barcode occurs in your Excel Workbook.
How to Generate Code 39 Extension Barcode in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "Code 39EX";
- Input some data - "Code 39" in "Data";
- Click "Generate"; then a Code 39 Extension barcode occurs in your Excel Workbook.
How to Link cell with a Code 39 Barcode in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "Code 39";
- Input some data - "CODE 39" in "Data";
- Click "Generate"; then a Code 39 barcode occurs in your Excel Workbook.
- Click on a cell with data and click "Link to Cell";
- Click "Update"; then a Code 39 barcode occurs in the cell you choose.
How to Generate Multiple Code 39 Barcodes in Different Cells?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "Code 39";
- Input some data - "Code 39" in "Data"; click "Generate"; then a Code 39 barcode occurs in your Excel Workbook;
- Click on a cell with data and click "Link to Cell";
- Click "Generate"; then a Code 39 barcode occurs in cell you choose;
- Change the data in the cell you choose and click "Update Link to Cell";
- Click "Update"; then a different Code 39 barcode occurs.
How to Generate Code 39 Barcode list in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "Code 39";
- Input some data in all the cells that you want to convert to barcodes;
- Select all the cells that you want to convert to barcodes and click "Link to Cell";
- Click "Generate"; then a list of Code 39 barcodes occurs in cell you choose.
