How to create barcode in Excel without VBA

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.

Continue reading