Excel
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

1

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

2

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

Barcode, Excel

3

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

4

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

5

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

Barcode, Excel

6

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

7

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

Barcode, Excel

8

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

Barcode, Excel

9

Click the Insert Barcode button.

Barcode, Excel

10

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

Barcode, Excel

11

To further adjust the barcode, activate the design mode.

Barcode, Excel

12

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

Barcode, Excel

13

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

Barcode, Excel

14

Done!

Barcode, Excel


| Home | Shop | Download | E-Mail | Privacy Policy | Imprint | Version 6.5.0
Copyright ©
Frank HornActiveBarcode Generator
Web design: szBubble 3.1.12.318
Copyright © Frank Horn
&
Lars SchenkActiveBarcode Object
Web- & server component
Command line
Copyright © 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 >