This article illustrates how to use the code 39 barcode font for excel. Barcodes are extensively used worldwide and have a wide range of applications. For example, a barcode can be generated for the price of a grocery product. Now if the barcode is printed on the packet of the product, then the store employee can use a barcode scanner to prepare the bill quickly because she doesn’t have to type the price value. You can use the code 39 barcode font to generate barcodes in excel. Follow the article to learn how to do that.
You can download the code 39 barcode font from here.
Download Practice Workbook
Steps to Use Code 39 Barcode Font for Excel
Follow the steps below to generate barcodes using the code 39 barcode font for excel.
📌 Step 1: Download a Suitable Code 39 Barcode Font
- First, close all of your office applications. Then download the code 39 barcode font using the download link above. Next, open the downloaded zip file.
📌 Step 2: Install the Code 39 Barcode Font
- Then, open the file with the .ttf extension.
- Next, click on Install to install the font.
📌 Step 3: Apply the Code 39 Barcode Font
- Now open Excel and select the cell or range from which you want to create the barcode. Then type Libre Barcode 39 as the font type. Alternatively, you can scroll down and select that.
- After that, the barcode will be generated. Next, change the font size and adjust the row and column heights. But, you won’t be able to read these barcodes using a barcode reader/scanner because the barcode reader won’t be able to detect the starting and ending points.
📌 Step 4: Format Dataset for Scannable Barcode
- Now enter the following formula in cell C5 to fix this issue. Then drag the fill handle icon to copy the formula to the cells below. After that, you will get the following result. The asterisks (*) define the starting and ending points for the barcode reader to read the code.
📌 Step 5: Generate Machine-Readable Barcodes
- Then, select the range C5:C10 instead and apply the Libre Barcode 39 font. After that, you can read the barcodes using a barcode scanner.
Things to Remember
- Don’t forget to use asterisks (*) before and after the text/number from which you want to generate the barcode. Otherwise, you won’t be able to read the barcode using a reader.
- You can download and install any other code 39 barcode font (ID Automation Code 39 Barcode Font) with premium features for a better experience. In that case, you need to apply that particular font type instead.
- You can print the sheet to check if the barcodes work.
Now you know how to use the code 39 barcode font in excel to generate readable barcodes. Do you have any further queries or suggestions? Please let us know using the comment section below. You can also visit our ExcelDemy blog to explore more about excel. Stay with us and keep learning.