Free Excel Barcode Font

Using Excel as a barcode formulator and to translate numbers and letters into barcodes can aid in your business’s inventory management and barcode management processes. Learn how to create barcodes in Excel with this step-by-step guide. Included on this page, you’ll learn how to create a barcode in Excel step-by-step, how to generate random barcodes, types of barcodes and barcode fonts, and which versions of Excel support barcode creation.

How to Create a Barcode in Excel 2016

First, you’ll need to download a barcode font. The most common font — and the one we’ll use in this tutorial — is code 39 (more on that in this section of the article). You can download a version of the font from a number of places, including Dafont, Free Barcode Font, ID Automation, or Square Gear.

Once you download the font, follow Microsoft’s instructions on how to install a font for Office to get it working with your version of Excel.Below are a couple of notes about installing fonts:.

You may need to quit and restart Excel for the font to appear in your font list.

How to Generate Random Barcodes in Excel

Not all fonts work perfectly for all OSs and versions of Excel. If one doesn’t operate well, delete it and try another. Code39 has worked best during the research for this article.

Once you install the font, it’s easy to create barcodes in Excel. Simply follow the steps below. Step One: Create two columns in a blank spreadsheet. Title the columns Text and Barcode.

Creating Barcodes in Word and Other Apps

Place the alphanumeric data in the Text column (this is the basis for the barcodes). The barcodes will appear in the Barcode column.

Note: If you want to add a description of each item the barcode applies to, add additional columns to make a table-like layout.

Step Two: Format the cells in the Text column. Select the Text column, then right-click on it.

See how Smartsheet can help you be more effective

Click Format Cells, click Number, click Text. This will prevent larger numbers from displaying in scientific notation as well as preserving leading zeros.

Step Three: Enter the following formula: ="*"&A2&"*" in the first blank row of the Barcode column. In this step, we’re assuming that the cell in the Text column is A2; if not, adjust the formula accordingly. If you there’s no text in the first column, the second column will display two asterisks.

Step Four: Fill the Barcode column down. Step Five: Change the font in the Barcode column. From the font menu, select the downloaded and installed barcode font.

It’s a good idea to use the same font for the header row as you do for the rest of the spreadsheet, but that’s up to you.

Step Six: Enter alphanumeric data into the Text column. The Code 39 font can encode 1-9, A-Z (the font considers uppercase and lowercase the same), the en dash (-), dollar sign ($), percent sign (%) period (.), slash (/), plus (+), and a space.

How to Make a Barcode in Excel

The font also encodes the asterisk (*), which is used as an indicator for the beginning and end of the sequence (this is also why the formula in Step Three adds an asterisk before and after the text entered).

The Barcode row will automatically populate with barcodes. Watch the demo to see how you can more effectively manage your team, projects, and processes with real-time work management in Smartsheet.

While creating barcodes in Excel will work well for many, doing so may not be scalable.

However, the process is an easy and inexpensive way to do the following: .

Print product numbers or UPC codes. Produce a product catalog or product list. Track stocked items. All of these capabilities are extremely useful in inventory management.

You can use the RANDBETWEEN Excel function for barcodes that require random numbers. Follow the steps below to automatically create random numbers for barcodes.

Note: If you changed the column to text format (see Step Two in the Creating a Barcode in Excel section), change it back to General.

Enter the RANDBETWEEN Excel function. In the first cell of the Text column, enter =RANDBETWEEN(X,Y), where X is the lowest value and Y the highest.

For example, =RANDBETWEEN(100,500) will generate random numbers between 100 and 500.

Looking forward to a career as a Business Analyst? Check out the Business Analytics Certification Training with Excel and get certified toda

What Versions of Excel Can Make Barcodes?

Fill down the row to generate random barcode numbers. Each cell will have a random number in the specified range. The 2010, 2013, and 2016 versions of Microsoft Excels can make barcodes. Some older versions may also be able to make barcodes with a supported add-in.

This includes those released in 2003 and 2007. In addition to Code 39, there are a number of other barcodes available, including the following: . Code 128: This code is generally used for shipping and supply chain labels. It can encode the same set of characters as Code 39 (though uppercase and lowercase letters can appear differently). There is no length restriction. UPC/EAN: This is the barcode most people are familiar with because it’s used for product barcodes.

UPC stands for Universal Product Code; EAN for European Article Numbering. The barcode is also known as UPC-A and is restricted to 12 characters. I2of5: This is a two row barcode that’s used on rolls of 35mm film, and to label some cartons.

Comments are closed.