Barcode Add-In for Microsoft Excel (All Versions)

http://tec-it.com - This tutorial video shows you how to print barcodes with Excel 2007, Excel 2010, Excel 2013 and Excel 2016. Just try it yourself with the demo software downloads available on http://www.tec-it.com .

Video auf Deutsch: http://www.youtube.com/watch?v=V_LG40...

With TBarCode Office, TEC-IT's barcode add-in for Microsoft Excel, you create bar-coded workbooks and spread-sheets with just a few clicks. This barcode add-in integrates seamlessly into Microsoft Excel 2007 and higher. Barcode labels and bar-code lists are printed easily.

In the first part of this tutorial video you learn how to create a single barcode. If required the barcode can be linked to a spreadsheet cell. Dynamic bar-codes, which are updated automatically, are implemented easily with this cell-linking feature.

Instructions on how to create bar-code lists or tables with a single click are shown in the second part of this tutorial. This convenient feature of TBarCode Office allows you to convert multiple cells in an Excel spreadsheet into bar-codes.

TBarCode Office is the ideal bar code extension for linear, GS1 and 2D bar-code printing! This flexible bar code add-in supports more than 100 different barcodes. Among them are linear and 2D barcodes like Code128, Code39, EAN, UPC, EAN128, Data Matrix, QR Code, PDF417, Aztec Code, GS1 DataBar.

---

Closed Caption:

In this video you learn how to use TEC-IT's barcode add-in TBarCode Office with Microsoft Excel.
This barcode add-in integrates seamlessly into Excel.
Creating linear barcodes, postal codes, GS1 DataBar and 2D barcodes is just a matter of seconds!
After TBarCode Office is installed, start Microsoft Excel.
Activate the Add-Ins tab in the ribbon and open the TBarCode Panel by clicking on the icon.
Inserting a barcode is really easy.
Just enter some barcode data,
then select the cell which should be converted into a barcode.
TBarCode Office automatically uses the cell data as barcode content.
Select the required barcode type, in this example an EAN13 bar code.
And click Insert Barcode, the barcode is inserted immediately!
You can choose between three different sizing modes:
Fit into Bounding Box: The barcode is always drawn in the size of the bounding box.
The module width adapts to the amount of data.
Fixed Module Width: The width of the barcode is adjusted to the amount of data to be encoded.
And Fit to Cell draws the barcode in the size of the selected cell.
The inserted barcode contains static data.
But how to create a barcode which updates automatically?
TBarCode Office offers a very convenient Cell-Linking feature.
Select the barcode which should be linked.
Click Link to Cell.
And then select the cell of interest.
And that's all!
Whenever the content of the linked cell is changed, the barcode is updated automatically.
Now I show you how to create a list of barcodes with a single click!
I open a new spreadsheet with some data.
Mark the cells which should be converted to barcodes.
Select the required barcode type.
This option let's you create one barcode per cell.
Here you can choose whether you want to encode the data as is or if you want to link the barcodes with the cells.
And with this option empty cells will be ignored by default.
Click Insert Barcode again.
And here you go!
I've created a list of barcodes with just one operation.
I hope this video was helpful and I encourage you to check out TBarCode Office for yourself. Thanks for watching!