How to Use a Barcode Font for Excel: A Complete 2026 Guide to Generating Scannable Codes

To use a barcode font for Excel, download a TrueType font (TTF) like Code 39, install it on your computer, and apply it to your data cells. For Code 39 specifically, you must wrap your text in asterisks (e.g., *12345*) so scanners recognize where to start and stop reading.

Quick Start: How to Install and Use a Barcode Font for Excel

Generating barcodes in Microsoft Excel starts with getting a compatible TrueType Font (TTF) file. Think of a barcode font as a way to treat bars just like text characters, which makes bulk generation much faster than using graphical generators. Once you install the font on Windows or macOS, it shows up in your Excel font menu right next to Arial or Calibri.

The most important technical step is the Asterisk (*) Start/Stop Characters rule. Scanners need to know exactly where a code begins and ends to process the data. You’ll need to add an asterisk to the front and back of your data—turning 12345 into *12345*—either manually or with a quick formula. Without these “quiet zone” markers, your scanner simply won’t decode the bars.

To apply the style, highlight the cells with your asterisk-enclosed data and switch the font in the Excel Ribbon to your barcode font name. As Matt Welch points out: “I thought I’d donate it to the world… It is suitable for scanning even at fairly small point sizes.”

Why Code 39 (Code 3 of 9) is the Best Choice for Beginners

Code 39 (Code 3 of 9) remains the go-to for simple barcoding because you don’t have to deal with complex check-digit math. It handles uppercase letters (A-Z), numbers (0-9), and symbols like the dollar sign ($) or percentage (%). It’s a self-checking system, which makes it reliable for tracking office inventory or files without needing extra encoding software.

Modern Solutions for Excel 365 and Cloud Users

If your team uses Office 365 or Excel for the Web, standard TTF installs can be tricky. Cloud versions of Excel don’t always show locally installed fonts to every user. A solid workaround is Libre Barcode 39, found on Google Fonts. It’s an open-source, web-friendly option that helps barcodes display correctly across different devices.

In larger setups, simple font files often aren’t enough to keep data accurate at high speeds. Industrial Usage by Fortune 500 companies usually involves professional font packages with built-in add-ins. These tools make sure barcodes stay scannable even when you’re sharing spreadsheets across different departments or cloud folders.

If your IT policy blocks you from installing new fonts, you might try API streaming. This method pulls the barcode into the cell as an image from an external service. It bypasses the need for a barcode font for Excel while keeping your data synced in real-time.

How to Automate Bulk Conversion with VBA Macros & Formulas?

Manual entry is a headache if you have thousands of rows. You can automate the “Asterisk Rule” with a basic formula: in cell B2, type ="*"&A2&"*" to wrap the data from A2 automatically. This ensures every entry is ready for the barcode font before you even apply the style.

Printer resolution also plays a big role in whether your codes actually work. According to IDAutomation, if you’re using a 300 DPI printer, stick to font sizes in multiples of 4 (like 12, 16, or 20pt). This helps the bars align perfectly with the printer’s pixels. Off-standard sizes can cause blurring—known as anti-aliasing—which makes the code unreadable to scanners.

For tougher formats like Code 128, you’ll need to enable the Developer Tab and check your Macro Security Settings. Go to File > Options > Trust Center > Trust Center Settings > Macro Settings and choose “Disable all macros with notification.” This lets you run the VBA scripts required to calculate checksums—something a simple font can’t do on its own.

Code 39 vs. Code 128: Which Symbology Should You Choose?

Choosing between Code 39 (Code 3 of 9) and Code 128 mostly comes down to how much space you have. Code 39 is “plug-and-play” and very easy to use, but it creates wide barcodes. If you’re trying to fit a long string of text onto a tiny label, a Code 39 barcode might end up too long to scan.

Code 128 is a higher-density option that supports the full ASCII 128 character set and takes up much less room. The catch? You can’t just type and change the font. It requires a “Check Digit”—a bit of math embedded in the string. You’ll need a professional encoder or a VBA macro to turn your raw data into the specific string that the font displays as bars.

FAQ

Why is my barcode not scanning in Excel?

The most likely culprit is a missing start/stop asterisk (*). Also, check your size; scanners usually need the font to be at least 24-36pt. Finally, check your printer settings. IDAutomation suggests using font sizes in multiples of 4 for 300 DPI printers to prevent scaling issues that break the code.

Can I generate QR codes or Code 128 using only fonts?

Not exactly. You can’t make QR codes or Code 128 by just switching the font face. These formats need a “checksum” or “check digit” calculation first. To get them working in Excel, use a VBA macro or a dedicated Add-in to encode your data into a special string before applying the barcode font.

How do I install barcode fonts on a Mac for Excel?

On macOS, download your TTF file and open the “Font Book” app. Drag the file into your library to install it. You’ll need to restart Excel completely for the font to show up in your list. The same asterisk rules for Code 39 apply on Mac just as they do on Windows.

Conclusion

Using a barcode font for Excel is likely the fastest way to turn a basic spreadsheet into a functional tracking tool. Once you get the “Asterisk Rule” down for Code 39 or set up a VBA encoder for Code 128, you can produce labels at scale without buying expensive software.

Start by downloading a reliable font like “Free 3 of 9” and test a few rows using the ="*"&A2&"*" formula. Once your scanner picks up the test code, you’re ready to roll it out across your whole database.