Use the barcode Add-In

How to embed a barcode into a sheet with a form using the Add-In
Excel 365, 2019, 2016, 2013, 2010


In this example, we show you how to use the Excel Add-In to integrate a barcode into a form and link it to a data cell. The starting point is an invoice form in which the invoice number is to be inserted as a barcode.

Barcode, Excel


To do this, switch to the tab "ActiveBarcode".

Barcode, Excel


In the left area of this menu you can configure the barcode. First select the barcode symbology. In this example we use code 128.

Barcode, Excel


Now select the position at which the barcode is to be created. Since this position is not directly next to the cell, we select "Free position".

Barcode, Excel


In addition, set the desired size and select whether you want the plain text line to be displayed or not.

Barcode, Excel


Under "Option/Settings", check the option "Link barcode to cell" and activate it if necessary. This links the barcode to the cell, i.e. the barcode always changes according to the cell contents.

Barcode, Excel


Under "Barcode/Cell", activate the option "Set barcode size to independently". This makes use of the height and width values.

Barcode, Excel


Now select the cell in your table that you want to link. In this example, it is the invoice numbers cell.

Barcode, Excel


Click the Insert Barcode button.

Barcode, Excel


The barcode is inserted in the selected size in the middle of the worksheet.

Barcode, Excel


To further adjust the barcode, activate the design mode.

Barcode, Excel


Activate the barcode by clicking on it once. Now you can move the barcode to the final position.

Barcode, Excel


You can also change the properties of the barcode, e. g. reduce the font of the plain text line.

Barcode, Excel



Barcode, Excel

| Home | Shop | Download | Email | Privacy policy | Imprint | Version 6.8.0
Copyright © Frank Horn & Lars Schenk
All trademarks and product names mentioned are the property of their respective owners.

We use cookies to provide you with the best experience and functionality on our website. By using our site you agree to this. read more >