In this tutorial, I am going to show you 3 easy methods of how to create a barcode in Excel. Barcodes can really help you to manage product inventory properly for your business. With the help of Excel, you can generate any type of barcode in a short time.
Download Practice Workbook
You can download the practice workbook from here.
3 Easy Methods to Create Barcode in Excel
To follow along, you need to download a font and install an add-in for Excel to create a barcode. I will take you through the steps below.
1. Apply IDAHC39M Font to Create Barcode in Excel
For this method, to create a barcode we need to download and install the IDAHC39M Font. Let us see how we can do that.
- First of all, download the IDAHC39M font and install it.
- Then restart MS Excel and the font will be added.
- Now, select cell B5 and enter any number for your barcode.
- Now go to the Home tab and then the Number option.
- Here, set the format to Text.
- After that, type the following formula in cell C5:
- At this time, you should get the following results.
- Now, navigate to the Home tab and click on the Font dropdown.
- Find the font IDAHC39M and select it.
- After that, you should get your desired barcode.
- Finally, drag the Fill handle to copy the format to other cells.
2. Create Barcode in Excel for Random Number
If you need to generate any random barcode in Excel, this method can help you with that. Using the RANDBETWEEN function, you can specify a range of numbers and generate random numbers. Then you can easily convert them into barcodes. Follow the steps below to do this.
- To begin with, select cell B5 and type the following formula:
- Note that, you can set any numbers for the range.
- Now, press Enter and you will get a random number within the set range.
- After this, type the following formula in cell C5:
- Press Enter.
- Now as shown before, set the font to IDAHC39M and hit Enter.
- Subsequently, you will get a random barcode.
- Finally, simply click and drag the Fill Handle for both cells.
- This way you can create multiple rows of random barcodes.
3. Insert Barcode Using Excel TBarCode Add-In
For this method, you have to install the TBarCode add-in. This can be done in a few steps which I will show you in a moment. Note that the barcode generated in this method will be an image. Also, you can set a barcode type of your choice. Let’s jump right into it.
- Firstly, download the latest version of the TBarCode Add-In.
- After downloading, simply install the Add-in on your computer.
- Then, restart your computer. The add-in will be linked to MS Excel.
- Now, open Excel, and you should see the Add-ins tab activated.
- Go to the Add-ins tab and click the TBarCode Panel.
- After that, set a barcode type and enter your number in the Data field.
- In addition to this, set the Size to ‘Fixed Module Width’.
- Last but not least, hit the ‘Insert Barcode’ button.
- Finally, you should get your barcode in your set format.
I hope that you followed all the above steps with me and were able to create a barcode in Excel. You can use the explained methods to generate as many barcodes as required. You can also create your own product catalogs and lists. To learn more Excel techniques, follow our ExcelDemy website. If you have any queries, please let me know in the comments.