Generate Barcodes in Excel with TechnoRiver Barcode Font

The TechnoRiver Barcode technology is implemented using TrueType fonts, and as such, allows barcodes to be treated as text in Excel and many other applications. This results in many advantages compared with graphics-based barcodes. For example, you could simultaneously change the size of multiple barcodes in a column of cells by selecting them and changing the font size.

TechnoRiver Barcode Font includes a complete set of Excel formulas for generating barcodes in Excel easily. These formulas will convert a raw data string into a format suitable for a barcode font.

Installing the Barcode Font Excel Formulas

For Excel 2002 / 2003

1. Launch Microsoft Excel.
2. Go to Tools > Add-Ins from the menu.
3. Click on the Browse button.
4. Navigate to the "formulas" directory ("C:\Program Files (x86)\TechnoRiver\Barcode Fonts\formulas")
5. Select the "TechnoRiverBarcodeFonts.xla" Add-In file
6. Click on the OK button to install the add-in. You should be able see the dialog as below.

   

For Excel 2007 / 2010

1. Launch Microsoft Excel.
2. Click on the Office Icon button or the File menu.

   

3. Click on Excel Options.
4. In the Excel Options dialog, click the Add-Ins item.
5. Locate and click the Go... button.
6. The the Add-In dialog will appear. Click on the Browse button.
7. Navigate to the "formulas" directory ("C:\Program Files (x86)\TechnoRiver\Barcode Fonts\formulas")
8. Select the "TechnoRiverBarcodeFonts.xla" Add-In file
9. Click on the OK button to install the Add-In. You should be able see the dialog above.

Excel Security Settings

If you are having problems running TechnoRiver Excel Formulas, make sure you have setup Excel Security Settings properly.

1. Launch Microsoft Excel.
2. Click on Tools > Macro > Security (For Excel 2007 / 2010, Macro Security is located in the Developer Tab of the Ribbon.)
3. Set the security level to Medium

Using the Excel Formulas

Example Code 39 Barcode

1. Make sure the TechnoRiver Barcode Font package and Barcode Font Excel Add-In are properly installed as described above.
2. Launch Microsoft Excel.
3. In your Excel spreadsheet, key in the data "12345678" in cell A2.
4. The barcode will be created and placed in the adjacent column.
5. In cell B2, key in "=TechnoRiverCode39(A2)", and press the Enter key.
6. You will see the string "*12345678*" generated in cell B2.
7. Change the font of cell B2 to FontCode39H3. You can repeat the steps above for cell A3 and A4.

The example above shows the encodation of a Code 39 barcode. The TechnoRiver Font package includes many other formulas and fonts for different barcode symbologies. The table below provides a complete list.

Complete List of Barcode Excel Formulas

Back to TechnoRiver Barcode Font