Home » How to generate a barcode in Excel

How to generate a barcode in Excel

This tip shows you how to generate a barcode in Excel that will enable you to track stock, sales, purchases or fixed assets.
Applies To: Microsoft® Excel® for Windows 2010, 2013, and 2016.
Excel has no built-in functionality to generate a barcode.  However, this is easily achievable by simply downloading and installing a font.

This tip will enable you to generate a barcode in Excel by using 39 barcodes.  Code 39, or Code 3 of 9 as it is sometimes referred to, is the most used barcode and is scannable by every barcode scanner.  It can encode 26 upper-case letters, 10 digits and 7 special characters.
To generate a barcode, follow these steps:
Download and install the free barcode font from idautomation. This is a fully-functional, freeware font.  Please refer to the free product section of their license agreement for additional information.
Once the font has been installed, select the cell in which you want to generate the barcode.
Enter the value for the barcode.
Change the font from your standard font style to “IDAutomationHC39M Free Version”.

Once the font has been changed, the text will be converted into a barcode.
This is an easy way to not only generate a barcode, but also one that can be printed and scanned.
The post How to generate a barcode in Excel appeared first on Sage Intelligence.

Powered by WPeMatico