How to create Barcodes in Excel.

70 / 100

Creating barcodes in Excel can be done using barcode fonts or an add-in. Here are the steps to create barcodes using both methods:

Table of Contents

Download and Install a Barcode Font:
- Search for a free barcode font online, such as IDAutomation’s Free Code 39 Barcode Font or similar.
- Download and install the font on your computer.
Open Excel:
- Open Excel and create a new workbook or open an existing one.
Enter Data:
- Type the data you want to convert into a barcode in a cell.
Format the Cell with Barcode Font:
- Select the cell containing the data.
- Change the font of the cell to the barcode font you installed. This will convert the data into a barcode.

Install a Barcode Add-In:
- Search for a barcode add-in for Excel. Many barcode software companies offer free or paid add-ins.
- Download and install the add-in following the provided instructions.
Open Excel and Access the Add-In:
- Open Excel and go to the “Add-Ins” tab or the tab where the barcode add-in is located.
Enter Data and Generate Barcode:
- Enter the data you want to convert into a barcode in a cell.
- Use the add-in to convert the data into a barcode. The specific steps will depend on the add-in, but usually, you select the cell and choose the barcode type from the add-in’s menu.

Download and Install the Font:
- Download from a site like IDAutomation, and install the font.
Enter Data in Excel:
- Enter your data in a cell (e.g., “12345” in cell A1).
Format the Cell:
- Select the cell with the data.
- Change the font to the installed barcode font (e.g., “IDAutomationHC39M”).
Add Start and Stop Characters:
- Code 39 requires an asterisk (*) at the beginning and end of the data. Enter the data in another cell with asterisks (e.g., “12345“).
- Change the font of this new cell to the barcode font.