Barcode Generator Excel Add-In User Guide

Generate, create 1d and 2d barcode images in Microsoft Office Excel

Install, or integrate barcode add-in on MS Office Excel and generate barcodes on Office Excel documents



In this Excel barcode generation user guide, you will learn how to generate, print high quality barcode images in Microsoft Office Excel document.

  • Create, insert 20+ linear and 2D barcode images in Excel worksheet
  • High dpi barcode raster images for document printing
  • Easy to generate a single barcode from Excel cell data, or create bulk of barcode image list from a template
  • Easy to customize the barcode dimension size (width and height)
  • No font, VBA, Macro programming required
  • Support latest version of Office Excel on Windows

How to create, print barcodes in Office Excel document

  1. Download Barcode Generator Excel Add-in software
  2. Install Excel add in to create barcode images in Microsoft Excel files
  3. Step by Step Tutorial














  • Easy to integrate this barcode add-in with your Microsoft Office Excel
  • Require no programming skills and barcode specifications knowledge base
  • Support inserting a single and batch barcodes on Excel 2016/2013/2010/2007 cells
  • Guarantee high print quality barcode generation, complying with GS1, ISO/IEC specifications
  • Create linear (1D) barcodes like Code 39, EAN, UPC, GS1 128, Interleaved 2 of 5, Postal Codes, etc
  • Embed matrix 2D barcodes in Excel, such as QR Code, Data Matrix, PDF 417
  • Flexible barcode dimension support allows adjusting various barcode size properties
  • Automatic check digit calculation support with this barcode add-in for Excel
Office Excel Barcode Encoder Add-In is a reliable and professional barcode generator for Microsoft Excel 2016/2013/2010/2007. This tutorial displays how to integrate barcode generation and printing features into Microsoft Office Excel and how to generate static and dynamic barcodes on your Excel spreadsheets.

Compatibility

Top

Operating Systems Compatibility:

  • Microsoft Windows 11
  • Microsoft Windows 10
  • Microsoft Windows 8
  • Microsoft Windows 7
  • Microsoft Windows Server 2008
  • Microsoft Windows Vista
  • Microsoft Windows Server 2003
  • Microsoft Windows XP
  • Microsoft Windows 2000

Microsoft Office Excel Versions Compatibility:

  • Microsoft Office Excel 365 on Windows
  • Microsoft Office Excel 2021
  • Microsoft Office Excel 2019
  • Microsoft Office Excel 2016
  • Microsoft Office Excel 2013
  • Microsoft Office Excel 2010
  • Microsoft Office Excel 2007

Install the OnBarcode Barcode for Excel software

Top
  1. Close all Excel spreadsheets.

  2. Run the "OnBarcode.Barcode.Excel.2021.Addin.Setup.exe" to install.

  3. If you need Excel Macro, run the "OnBarcode.Barcode.Excel.2021.Addin.Developer.Setup.exe" to install.

  4. Now, you may find OnBarcode Excel Barcode Add-In under the "Add-Ins" tab. If not, please do as follows:

    • Click "Office Button" > "Excel Options" > "Trust Center" > "Trust Center Settings..."> "Add-ins". Then, undo "Disable all Application Add-ins (may impair functionality)" and click "OK".
    • Now, switch to "Add-Ins" > "COM Add-ins" (from the "manage" pull-down menu) > "Go".
    • In the pop-up window, select "OnBarcode Excel 2021 AddIn" and click "OK".
  5. Now, the Excel Barcode Add-In is successfully integrated under "Add-Ins" tab.


How to create a barcode in Excel sheet?

Top
  • Select a 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 created on the cell.

To customize the generated barcode, please select it and adjust its property in the setting panel. Then, click "Update". Also, you can remove the generated barcode images by clicking "Delete" button.


How to create barcode with specific Excel cell data?

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

  • Choose the inserted 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 Link To Cell" button.


How to create bulk barcodes from list of numbers, text in Excel?

Top
Using OnBarcode Excel Barcode Generator add-in, you can easily create multiple barcodes from list of text, numbers in Excel.

View step by step details at: How to generate bulk barcodes in Excel document.




How to draw barcode with specified area in Excel document?

Top
Using Barcode for Excel add-in, you can easily generate the barcode in specified area in Excel sheet.

  1. Select a cell to insert barcode. The generated barcode image left top corner is the same position of the selected cell's left top corner. You can also drag the barcode image, and place any where on the Excel sheet.


  2. To set the barcode with specified image width and height, please apply the following settings:

    Check option "Auto resize"
    Set option "Image width" to value 500 pixels.
    Set option "Image height" to value 350 pxiels.



Now you know it is a simple task to create, draw barcode with target position and specified width, height in Excel document.

There are more options to customize the generated barcode image dimension size, such as text size, text margin, barcode images. You can view the details here:
How to generate barcodes with specified image size (width, height) in Excel?


















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.