We can also use the barcode in Excel formula to generate a barcode. Once we choose the specific barcode and increase the font size, the output will be: Let us select Code 128 for the example table. Step 3: Then, select the cell range C2:C11 and choose the required barcode font from the font list in the Home tab. Then, using the fill handle, copy the formula in cells C3:C11. So, copy the product IDs into column C by first selecting the cell C2 and entering the below formula: Step 2: Next, let us show the barcodes in column C. In the Format Cells window, choose the Category as Text in the Number tab. Please Note: The Text format ensures large numbers are not displayed in scientific notation, and the values containing leading zeros remain unchanged.Īlternatively, we can select the required data, right-click to open the context menu and choose the Format Cells option. If they are not, select them and set the Number Format as Text using the Text option from its drop-down list. Step 1: First, select the codes in column B and check their format using the Number Format option in the Home tab. Suppose we want to create the barcodes for the product IDs in column B. Thus, when scanning, the machine can read barcode in Excel we generated for each code in our source table.įor example, consider the below table containing a list of products and their unique IDs or codes. Select them and choose the required barcode font from the font list in the Home.When we create the source data, ensure the codes as barcodes are in Text.How To Generate/Create A Barcode In Excel?Īfter we install the specific barcode fonts on our computer, here is how we can generate a barcode in Excel. We can now use the barcode in Excel feature. Once installed, we will have to save and close our workbook, if it is open, and then open it again to view the barcode fonts in the font list in the Home tab. It will show us the different barcode fonts we can use in our Excel applications. Likewise, we can download and install the required barcode fonts from the website.Ĭlick the link pointed out in the image below. Step 4: Then, click the Install button in Code 128 (TrueType) window (highlighted in the above image).Īnd once installed, the button will grey out. ttf file.ĭouble-click on it to run the setup file for installing the particular barcode font on our computer. Step 3: The code_128.zip file will have a.
zip file in our Downloads folder immediately after downloading. Click on Download (highlighted in the above image) to download the package on our computer. Step 2: Next, the search result will show the Code 128 font software. Step 1: To begin with, open the site and enter the barcode font Code128 in the search box. But, first, let us see the steps to install the barcode font Code 128 from the above website. Suppose we want to use Code 128 to create barcode in Excel. We can find several websites offering free and paid barcode fonts, and is one such site where we can download various fonts for free.