Geekers - What are Barcodes? Barcode is a code that consists of a collection of optical data in the form of thin and thick lines containing information about a particular product/goods.
The data contained in the barcode can only be known by using a device called a barcode scanner. From the results of scanning the barcode, data regarding the name, brand, price and so on will be known. You must have seen this tool when shopping at the supermarket.
But now barcodes are also often used for ID in nametags at school, campus, company or other events. Of course we should be able to make our own barcode for the benefit of the event we are going to make.
How to Make Barcodes in Microsoft Excel
In fact, there are many barcode maker applications. But, without using an application we can also make it, namely by using Microsoft Excel. Can you use Microsoft Excel? You can. Then, how?
Well, this time I will share about how to make barcodes in Microsoft Excel very easily. how do? Just follow the steps below.
1. First, please download the Free 3 of 9 font first. Because it's usually not available by default on your laptop / PC. Please download it on the internet, you can click here. Then, select "Download" on the Free 3 of 9 font. As shown below.
how to create barcodes in Microsoft Excel 2010 how to create barcodes in Microsoft Excel 2010
2. Then, if you have downloaded it, please extract the file. As in the picture below.
how to make barcodes in Microsoft Excel how to make barcodes in Microsoft Excel
3. Then, please copy the Free 3 of 9 font file to "This PC > Local Disk (C:) > Windows > Fonts". As in the picture below.
paste fonts paste fonts
4. So, the font file will be with other font types. As in the picture below.
fonts fonts
5. Then, please search for and open Microsoft Excel on your laptop / PC. As in the picture below.
how to create barcodes in Microsoft Excel 2013 how to create barcodes in Microsoft Excel 2013
6. Then, please create a table containing "Code and Barcode" to make it easier to see the results. And please fill in the code you want. But it should be noted, when you write a number code you must surround it using the symbol (*). As in the picture below. Because if you do not use the symbol (*), the code will not be readable.
fill in the code fill in the code
7. Then, please go to the Barcode section to write the formula. Please enter =A2. As in the picture below. You can also just click on the A2 box.
how to make barcodes in Microsoft Excel how to make barcodes in Microsoft Excel
8. So, the contents of the barcode box will be the same as the box next to it. As in the picture below.
formula result formula result
9. Then, please block the barcode box and please change the font form to Free 3 of 9. Then, the results of the barcode code will appear. As in the picture below.
how to create barcodes in Microsoft Excel 2019 how to create barcodes in Microsoft Excel 2019
10. Done. The barcode code will appear according to the code entered.
Well, how? The method is quite easy and very simple, right? Now we can make our own barcode code without having to download other additional applications.
We only use Microsoft Excel, where this application is definitely on each of our laptops / PCs. So, we don't need to spend internet quota to download other applications.
That's how to easily make barcodes in Microsoft Excel that you can try. If this article can help you, please share it with your friends so they also know how to easily make barcodes in Microsoft Excel.
RELATED TUTORIALS
* How to Create Ordered List of Dates in Excel
* How to Hide Columns or Rows in Microsoft Excel
* How to Change the Color of Lines or Gridlines in Microsoft Excel
* How to Color the Tab Sheet in Microsoft Excel