Browsing through one of the online forums I noticed someone asking “How to create barcodes in Excel?”. Among many answers he got, the most popular were:
- install additional font(s)
- use conditional formatting
- use VBA
- use Word mailing functions to get data from Excel and generate barcodes in Word
I digged a bit into all of them and learned a few things here and there, but still was asking myself: is it possible to create barcodes in Excel without VBA, without installing fonts, without passing through other apps (eg. Word)?
And the answer is: YES, we can create barcodes directly in Excel, using only built-in features, but that requires some preparation.
Here is how.