People who track stock, sales, and purchases in Excel often ask me “how can we generate a barcode in Excel?”. Well, in Excel there is no default option to generate a barcode. Cookie 5 1 3 – protect your online privacy.
And, the bad news is: There is no plan of Microsoft to add any option like this.
The best website for free high-quality Wasp 128 fonts, with 7 free Wasp 128 fonts for immediate download, and 6 professional Wasp 128 fonts for the best price on the Web. Microsoft Office Code 39 Barcode Tutorial. The Code 39 font is the easiest barcode symbology to use in Microsoft Office. Creating the barcode is as simple as appending the data with the start and stop characters of an asterisk (.) or exclamation point (!). Fontware - Barcode characters are superimposed on each other using Wasp fonts in a PowerPoint presentation Fontware - How to create a Code 39 barcode without the toolbar Fontware - How to write an Excel macro to automate the creation of serial number barcodes without requiring the user to select the barcode font.
But here is the good news: You can generate a barcode in Excel by installing a font.
So today, just for you, I’d like to reveal the method to generate a barcode in Excel by using 39 barcodes. So let’s get started.
What is Code 39?
Code 39 is known as Code 3 of 9 which is the most used barcode and able to scan by every barcode scanner. In this code, every single character has 5 bars and 4 spaces in total 9 characters. Out of total 9 characters, 3 characters are always wide. It can encode 26 uppercase letters, 10 digits and 7 special characters.
Quick Note: It’s one of those Excel Tricks that can help to get better at Basic Excel Skills.
Steps to Add a Barcode Font/Generate in Excel
Just follow these simple steps.
- First of all, you have to download this free barcode font from idautomation.
- Once you download this font, next you need to install it on your system.
Important Note: This is a free version of the font. You can only use it for educational purpose.
- Now, from your worksheet, select the cell in which you want to create a barcode.
- Enter the value for which you want to create the barcode.
- Just change the font style from your normal font style to “IDAutomationHC39M Free Version”.
As soon as you change your font style text will convert into a barcode.
This font style will simply convert your text into 3 of 9 barcodes. And, you can use it anywhere you want.
Steps to Create a Barcode in Word
You can create a 3 of 9 barcode in word as well by using following steps.
- Once you install the font in your system, you can call it from any of your office app.
- Just type the text for which you want to create a code.
- Select that text and change the font style to “IDAutomationHC39M Free Version”.
That’s the whole story about barcode.
And, you know this is one of the easiest ways to create barcode in Excel/Word.
You can generate as well as print these barcodes and you can also create a separate template for this as well.
I hope this tip will help you track your stock effectively.
Now tell me one thing. Have you ever tried to create a barcode in Excel? Do you know any other method for this? Please share with me in the comment section, I’d love to hear from you.
And, please don't forget to share this tips with your friends.
Wasp Barcode Font
Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.