Barcode Add-In for Microsoft Excel 2007/2010


Uploaded by TECITSoftware on 10.06.2010

Transcript:
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!