Barcode for Excel
User Guide
Our Customers
Contact Us Email: support@barcodelib.com
Home > Excel Barcode Generator Add-In > Excel Barcode Generation User Guide
Download Barcode for Excel Trial

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