How to Add Barcode Font in Excel (Installation and Application)

Basically, a barcode is a bunch of lines and spaces that represent some machine-readable information. From grocery store products to confidential information, barcodes have a broader range of applications. The objective of this tutorial is to explain barcodes in detail, add barcode font in Excel, and generate a couple of barcodes in detail.

What Are Excel Barcode Fonts?

Generally, barcodes look like black bars and white spaces and store machine-readable information. With the addition of Barcode, Microsoft Excel has some minor additions, such as a new font.

Different Barcode Fonts

The Excel program can generate a variety of barcodes, such as:

  • Code 128
  • Code 39
  • UPC-E
  • QR
  • Postnet
  • UPC/ EAN
  • I2of5
  • Intelligent Mail

If you want to create a barcode in Excel, you need to ensure that you have the proper barcode fonts. These will not be included by default. The best way to accomplish this is to walk through each step step-by-step.

If the barcode font is not available in Excel, then you might be able to get one for free. You can now install a barcode font in Excel using the following instructions.

Step 1: Downloading a Suitable Barcode Font Package

The internet is full of websites that sell and distribute barcode font software, both for free and for a fee. One of the highly recommended ones is 3 of 9 Barcode TrueType.

Please download a suitable barcode font package.

Step 2: Running the Setup File and Installing

Run the setup file included in the download package by double-clicking on the file. A 3 of 9 Barcode (True Type) dialog box will appear.

Install Font for Barcode in Excel

Now, click on the Install button to install the font, as shown below.

Install Font for Barcode in Excel

Read More: How to Create Barcode Without Font in Excel 

Step 3: Inserting Barcode Font in Excel

Now, we will see how to use these fonts to create barcodes successfully.


  • Create an empty table by opening Microsoft Excel.

  • Let’s start with the first column and enter the data there. Data types are generally general by default. Excel implicitly converts the data based on your input. Excel will implicitly convert general data to float if you enter float data.

For your own safety, you should manually assign the column data type as text, since this helps you create barcodes.

  • Now, write down a few random numbers of 8 digits into the cells (B5:B10) of the Number column. These numbers will be transformed into barcode fonts.

  • You can create barcodes in Excel using a variety of formulas. Below are two straightforward methods you can use. It would help if you wrote the formula below in the adjacent cell to your input. Here, the input column is B.



The Formula for Barcode in Excel

  • To apply the same formula to all cells below, drag down the formula after writing it.

The Formula for Barcode in Excel

Here is the result after dragging.

The Formula for Barcode in Excel

  • Now select the cells of the Barcode column as shown in the following image.

  • From the fonts menu drop-down, choose the barcode font you want to use for the resultant column, in my case column C.

The Formula for Barcode in Excel

  • This will result in the following final table.

The Formula for Barcode in Excel

Read More: How to Generate Barcode Numbers in Excel 

Download Practice Workbook

You can download the following practice workbook that we have used to prepare this article


In this tutorial, I have discussed barcodes in detail, and how to add barcode font in Excel and generate a couple of barcodes in detail. I hope you found this article helpful. Please, drop comments, suggestions, or queries if you have any in the comment section below.

Related Articles

<< Go Back to Barcode in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Hafizul Islam
Hafizul Islam

Hafizul Islam is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF