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.
Download Practice Workbook
You can download the following practice workbook that we have used to prepare this article
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/ EAN
- Intelligent Mail
Steps to Add Barcode Font in Excel
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: Download 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: Run Setup File and Install
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.
Now, click on the Install button to install the font, as shown below.
How to a Create Barcode with Barcode-Font
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.
- To apply the same formula to all cells below, drag down the formula after writing it.
Here is the result after dragging.
- 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.
- This will result in the following final table.
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. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.
- How to Use Barcode Scanner for Inventory in Excel (with Easy Steps)
- How to Use Barcode Scanner in Excel (2 Suitable Ways)
- Barcode Scanner Entry to Excel Database with Timestamp (3 Basic Cases)
- How to Generate Code 128 Barcode Font for Excel (With Easy Steps)
- How to Use Code 39 Barcode Font for Excel (with Easy Steps)
- How to Print Barcode Labels in Excel (with 4 Easy Steps)