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.

10000+ Copies Already Downloaded

How To Create Barcode Generator Template In Excel

Do you want to create a barcode in excel?

So today, just for you, I will reveal the method to create barcode generator template in excel.

how to create a barcode template in excel featured image

In this post, I will show you how to generate code 39 barcodes.

Code 39 is known as Code 3 of 9 which is the most used barcode and able to scan by every barcode scanner.

Create BarCode Generator Template In Excel

How Code 39 Works?

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.

Steps To Create Barcode Generator in Excel

Just follow these simple steps to generate a barcode.

  • First of all, you have to download this free barcode font.
  • Once you download this font, you have to install it on your system.

Create BarCode Generator Template In Excel Characters

Important Note: This is a free version of the font. You can only use it for educational purpose.
  • In your excel sheet, select the cell in which you want to create the barcode.
  • Enter the value for which you want to create the barcode.
  • Now, just change the font style from your normal font style to “IDAutomationHC39M Free Version”.

Create BarCode Generator Template In Excel Change Font Style

  • As soon as you change your font style text will convert into barcodes.

Create BarCode Generator Template In Excel Enter Code

This font style will simply convert your text into 3 of 9 barcodes. And, you can use it anywhere you want.

Steps To Create Barcode in Word

You can create a 3 of 9 Barcode generator template in word as well. Just follow these simple steps for this.

  • 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 & change the font style to “IDAutomationHC39M Free Version”

Create BarCode Generator Template In Word

Sample File

download sample file to learn about how to create barcode template in excel

Conclusion

This is one of the easiest ways to create barcode in excel. You can use it anywhere you want. And, all you have to do just install a font.

So now, tell me one thing.

Have you ever created a barcode in excel before?

More Tips