How to Generate Barcodes in Excel (in 2 simple steps)

In this tutorial, you'll learn how to generate scannable barcodes in Excel in two simple steps. You will also learn how to create random barcodes. A barcode is a machine-readable representation of numbers and characters used to store product information.

By the end of the tutorial, you'll know how to create barcodes in Excel using a barcode font, how to install fonts into Excel, how to generate random barcodes using the RANDBETWEEN function, and more.

📖RESOURCES

🤓SHOP EXCEL DICTIONARY

📩NEWSLETTER

📺SUBSCRIBE

🕰️TIMESTAMPS
'0:00 Intro
'0:23 How to create barcodes
'1:12 How to install a font into Excel
'1:34 How to create random barcodes
'2:21 Wrap up
#excel #exceltips

[aadesh_kale]

Thank you so much for this! I am grown adult and trying to learn Excel from basics, I will watch more of tutorials.

[KatlegoMasego]

Thank you for this. Just created barcodes for my products. Subscribed!

[aliciavanderspuy]

Thank you so much, you have taken away my headache - much appreciated 🙂

[bethclark]

Thank you I created barcodes. It was easy. New subscriber.

[isaiahbundi]

Thanks my dearest..worked perfectly❤....can u nxt please upload on how to make QR codes

[fanofthegame]

I am trying to generate barcodes in the EAN-8 format. The Libre 128 font does not support that. Do you know of a font or an API I can use to get barcodes in the EAN-8 format?

[skizr]

I can't get these to scan with an rf scanner. Why not?

[JBERGALIEN]

For all of viewers out there, the barcode describe here are fictional only to learn what is a barcode, the speaker on the video don't know how to implement 2 important thing first (a category product digit at the beginnig) second (a checksum digit at the end) you will need the 2 extra didits at the front and back of the barcode to be able to scan it with a real scanner. To bad lots of theses so call tutorial are not complete or professional. When someone need a barcode it needed to print on a label and be able to scan the barcode.
this video is only if someone need barcode to appear on screen, to make it fancy. Not pratical at all. BTW, to calculate the category digit and the checksum just google barcode
and this way you can find reliable source detailing all the steps how to create, print, scan the real thing, not just over the top tutorial. hope this will help the video speaker to learn and others on this site who did not received any reply or support from the site.

[kerrimcintyre]

Can I use these barcodes in something like inventora?

[josephinewyatt]

Where do you update on Excel after downloading?

[stephanieholden]

I printed the barcodes but mine won't scan I have the barcodes with the "*"& but still wont work. Does it need to be a certain size or any other setting I should use

[Saleh.Wardak]

How to transfer barcode scaner data to excel userform, thanks

[Barbaros]

I wanna hide the small barcode witch is showing when there is no barcode number, but i can't find the correct code for it. This works fine offline and on my pc with Excel online but if i share this file no one can't see the barcodes. Is this possible in the online version?

[adamwolf]

UGH! Does not work! The barcode font does not display in the list of available options after downloading!

[janadyck]

when i add the formula with brackets and all, then press enter, nothing changes. What am I doing wrong?

[ft]

I followed the instructions does anyone know why my numbers keep changing every time I re-open the spreadsheet. The numbers and barcodes don't lock in.

[juniorsgeneralstore]

I followed everything step by step and it created the barcodes but they will not scan. I can scan any barcode with my scanner expect for barcodes I create on excel :(

[srs-swooz]

At any point are you going to change her vocal fry? Pleeeaaase.