Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
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.
And, the bad news is:
There is no plan of Microsoft to add any option like this.
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.
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.
Just follow these simple steps.
Important Note: This is a free version of the font. You can only use it for educational purpose.
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.
You can create a 3 of 9 barcode in word as well by using following steps.
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.