How to create barcode in Excel

This tutorial is aimed at generating barcode equivalent of a alphanumeric number into an Excel cell. There are different types of Barcodes, such as

EAN 13,
EAN 8,
UPC A,
UPC E,
Code 128,
 ITF 14 and
Code 39.

 The first step is to decide on the right Barcode type to create (or print) depending on requirement. In this tutorial, Code 128 standard is used for illustration. Once the barcode type is decided, download the TrueType font file from google. TrueType font file is similar to a notepad file with ".ttf" extension.

After downloading the file, copy the file to "C:\Windows\Fonts" of your windows installation directory. Now, open the file copied and click on Installation as shown in the picture.

Now, open new Excel workbook select any cell type any alpha numeric number and then change the font type to Code128 from the drop down of font style as shown below.

This will generate the barcode equivalent of a number.