Barcode for Java
- Barcode for Java
  
  Barcode for BIRT Report

.NET Programing Control	.NET Reporting Control
Barcode for ASP.NET Barcode for .NET WinForms	Barcode for Reporting Services Barcode for Crystal Reports Barcode for RDLC Reports
Download Free Trial for .NET

Barcode for Excel

User Guide

Our Customers

Home > Excel Barcode Generator Add-In > Excel Barcode Generation User Guide

Excel Barcode Generation User Guide

Generating & printing 1D, 2D Barcodes in Microsoft Office Excel

Compatible with Microsoft Office Excel 2019, 2016, 2013, 2010, and 2007
Simple and quick to insert barcodes in MS Excel spreadsheet
Create multiple barcodes images with high quality
Directly install & use for linear and two-dimensional barcodes generation
Conforms to latest barcode specifications and industry standards
Supported 1d, 2d barcodes include Code 39, EAN-128 / GS1 128, EAN-13, QR Code, PDF-417, etc
Provide user-friendly interface and guide for adding barcodes in Excel

This page is mainly about how you can use Excel Barcode Generation Plug-In to add barcode images in your Office Excel spreadsheet.

Excel Barcode Add-In - Supported Barcode Symbologies

Excel Barcode Plug-In Generates 1D (Linear) Barcode Types

Codabar Excel
Code 11 Excel
Code 2 of 5 Excel
Code 39 Excel
Code 93 Excel
EAN-8 Excel
EAN-13 Excel
Interleaved 2 of 5 Excel
ITF-14 Excel

Code 128 Excel
EAN 128/GS1 128 Excel
MSI Plessey Excel
Onecode Excel
Planet Excel
Postnet Excel
RM4SCC Excel
UPC-A Excel
UPC-E Excel

Excel Barcode Plug-In Generates 2D (Matrix) Barcode Types

How to Install Add-in

Integration with Office Excel

Close all Excel spreadsheets.
Run the "BarcodeLib.Barcode.Excel.{NNNN}.Addin.Setup.exe" to install. Note: {NNNN} is your Microsoft Office Excel verison, such as 2019, 2016, 2013.

How to Insert a new Barcode on Excel

Choose an Excel cell on Excel document.
In the setting panel, choose your target barcode type and input valid data.
Then, click "Generate" button. Not that, this button will change to be "Update" immediately.
Now, a barcode image is successfully inserted on your targeted cell.

How to Insert a Barcode Linked to a Cell Value

To insert a barcode which update depending on the content of the linked cell, you may need to use the button "Link To Cell".

Choose an existing barcode image and click "Link To Cell" (To undo this, the button "Cancel" should be used).
Select a cell with your target data. After this, the "Link To Cell" button immediately changes to be "Update".
Click "Update", and then this barcode is dynamically linked to the cell.

In addition, generated barcodes can be linked to cells in this way. And all those barcodes can be updated at a time by clicking "Update All Linked Barcodes" button.

How to Create multiple Barcodes from a Cell List in Excel

To create multiple barcodes from a list of cells, please go to downloaded package and open "Excel Barcode User Guide.html" for more details.

How to Insert a Barcode with Specified Image Width and Height

If you need generate barcodes with required image width and height, and also need bar module (X & Y) as max as possible.

Check property "Auto resize"
Set property "Image Width", "Image Height"

How to Create GS1 Compatible QR Code or Data Matrix Barcode

To create GS1 compatible QR Code or Data Matrix barcodes, follow the steps below:

Barcode type should be QR Code or Data Matrix
Under tab "2D Barcode" in property panel, check property "GS1 Compatible Barcode"
In barcode "Data" property, around AI code with "()", and followed by AI data, such as "(02)225(03)33344". Here "02", "03" are the AI code, "225", "33344" is the AI data.

How to Encode Non-printable Chars

To encode non-printable chars (such as char 'TAB'), follow the steps:

Check property "Apply Tilde (~)"
Use 3-digits '~ddd' for non-printable chars. For example, ASCII char [GS] is non-printable, and its decimal value is 29. In barcode data, you need use ~029 for char [GS].

Provides High Quality Java Barcode, Java Barcode Library, Barcode Java, Java Barcode Generator, Java Barcode Generator Library and .NET Barcode Library, ASP.NET Web Barcode Library, C# Barcode Library, VB.NET Barcode Library, .NET Barcode Reader Library, Barcode Generator Software.