Create Barcodes in Excel With Just One Click
Use the Excel Barcode Add-In from TBarCode Office and create single bar codes and barcode lists or bar code labels fast, reliable and in professional quality.
- Insert Barcode
- TEC-IT Website
- Help
Barcode
TBarCode Office▾ ✕
Barcode
Data
Size
Fixed Module Width- Module Width
- 0.339
- Width
- 38.894
- Height
- 25.929
- Size in
- mm
Automatically Link to Cell
Insert Barcode- Barcode SettingsOptions
- Select all BarcodesLicense
- Refresh all BarcodesAbout
Creating Barcodes with Microsoft Excel made Easy!
Article lists or catalogues are produced easily: All selected cells (e.g. all UPC numbers in an Excel column) are converted into the required barcodes with a single click.
Working with TBarCode Office is fun. Even more advanced bar-coding tasks, like dynamically linking barcodes with the content of your spreadsheet, are supported as well. Whenever the content of the linked cell is changed, the barcode is updated automatically.
This barcode add-in focuses on easy operation but still provides control of all barcode parameters (barcode type, height/width, module width, check digits, etc.).
Test the barcode add-in for Microsoft Excel for free!
How To Insert a Barcode into Microsoft Excel
To insert bar codes into a Microsoft Excel document please follow these steps:
- Switch to the Add-Ins tab.
- Open the TBarCode Panel.
- Position the mouse cursor in a cell.
- Select the barcode type (e.g. UPC/EAN, Code-128, QR code...).
- Enter the barcode data or use the default data for the selected barcode.
- Adjust the size of the barcode (width, height, module width etc).
- Click the button Insert Barcode. Finished!
How to Create a Barcode List
- Open the Excel spreadsheet with the barcode data (e.g. a list with article numbers) or create your own list.
- Open the TBarCode Panel.
- Mark the cells with the barcode data.
- Select the barcode type (e.g. UPC/EAN, GS1-128, QR code...).
- Click the button Insert Barcode. Finished!
How to Link Barcodes to Cell Contents
- Open the Excel spreadsheet.
- Open the TBarCode Panel.
- Select the barcode type (e.g. UPC/EAN, QR code...).
- Mark the required barcode with the mouse.
- Click "Link to Cell".
- Mark the required cell.
- Finished! Whenever the cell content changes, the barcode is updated.
Insert Barcodes into Excel
The first part of the video demonstrates how to create a single barcode in Excel. 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. In the second part of the video you learn how to create multiple bar codes (list) in Excel with a single click.