How to Create Barcode in Excel (3 Easy Methods)

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.

Steps:

  • 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.

Apply IDAHC39M Font to Create Barcode in Excel

  • Now go to the Home tab and then the Number option.
  • Here, set the format to Text.

Apply IDAHC39M Font to Create Barcode in Excel

  • After that, type the following formula in cell C5:
=”(”&B5&”)”

Apply IDAHC39M Font to Create Barcode in Excel

  • 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.

Read More: How to Use Code 39 Barcode Font for Excel (with Easy Steps)


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.

Steps:

  • To begin with, select cell B5 and type the following formula:
=RANDBETWEEN(1000,10000)
  • Note that, you can set any numbers for the range.

Create Barcode in Excel for Random Number

  • Now, press Enter and you will get a random number within the set range.
  • After this, type the following formula in cell C5:
=”(”&B5&”)”
  • Press Enter.

Create Barcode in Excel for Random Number

  • 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.

Read More: How to Generate Barcode Numbers in Excel (with Easy Steps)


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.

Steps:

  • 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.

Insert Barcode Using Excel TBarCode Add-In

  • In addition to this, set the Size to ‘Fixed Module Width’.
  • Last but not least, hit the ‘Insert Barcode’ button.

Insert Barcode Using Excel TBarCode Add-In

  • Finally, you should get your barcode in your set format.

Read More: How to Generate Code 128 Barcode Font for Excel (With Easy Steps)


Conclusion

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.


Related Articles

Nazmul Hossain Shovon

Nazmul Hossain Shovon

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo