How to Create Barcodes in Excel (The Simple Way)
Before we begin, ensure that the column containing the codes is formatted as ‘Text’ to display codes starting with ‘0’ correctly.
To add brackets to the existing code, follow these steps:
1. Click into the target cell, such as C3.
2. Enter the equal sign, a quotation mark, an opening bracket, and a quotation mark.
3. Add an ampersand and the coordinates of the cell containing the code, for example, B3.
4. Enter another ampersand and the closing brackets in quotation marks, and then hit Enter.
Once the background for the barcode is set, copy the function to the remaining rows using the bottom right corner of the cell.
Next, change the font in the ‘Barcode’ column to ‘IDAutomationHC38M’ to generate the barcode easily.
It’s crucial to check if the ‘IDAutomationHC38M’ font is installed on your computer. If not, you can download it for free from IDAutomation.com. Use the ‘Download Now’ button on the website to obtain the font files.
After downloading, extract the files from the .zip file by right-clicking and selecting ‘Extract All.’ Install the font by clicking on ‘IDAutomation_Code39FreeFont.’
Upon successful installation, you can use the font in various applications, including Excel and Word.
Make sure to check the font list in Excel, where you should find ‘IDAutomationHC39M Free Version.’
If you found this tutorial helpful, please like our video and explore more tutorials on Excel by TechProAdvice. Don’t forget to subscribe to our channel to join the EasyClickers community.
Thank you for watching, and we look forward to seeing you in the next video!“`
Intro
Welcome!
In today’s tutorial, we’re gonna talk step by step through the whole process of how to create barcodes in Excel.
Barcodes are used everywhere and today we’ll see how to create standard barcodes
which will be recognised by any barcode scanner.
Shall we begin?
Hello! And welcome to EasyClick Academy!
My name’s Frank and together with our EasyClick team,
we’re here to make sure you’ll be able to use Excel in a quick and easy way,
thanks to our digestible video tutorials.
A barcode can be generated in Excel in a pretty straightforward way –
based on a code that contains numbers as well as letters.
Let’s have a look at how to do it using these three examples.
First, make sure that the column containing the codes is formatted as ‘Text’,
How to Format the Column Containing the Codes Properly
which is necessary for the correct display of codes beginning with ‘0’.
To make sure the data conversion from a code to the barcode runs smoothly,
we’ll need to add brackets to the existing code, but this needs to be done in a special way.
Here’s how.
How to Add Brackets to the Existing Code
Click into the target cell, the cell where you want to generate the barcode. In our case, it’s C3.
Enter the equal sign, a quotation mark, an opening bracket and a quotation mark again.
Then add an ampersand and right after,
the coordinates of the cell that contains the code we’re converting, which is B3 here.
Enter another ampersand and the closing brackets in quotation marks, and hit Enter. Perfect!
This is our background on which the barcode will be based.
Copy the function to the rest of the rows using the bottom right corner.
How to Change the Font in the Column Barcode to the Font IDAutomationHC38M
What’s left to do is to change the font in the column Barcode to the font ‘IDAutomationHC38M’…
and here we go with the barcode – simple, quick and easy!
This function is dynamic, which means any change in the source code will show on the barcode.
For example, if we change the ‘0’ in B3 to ‘8’, the data in column C will refresh automatically
and a new barcode will be generated based on the changed code.
But before you go ahead to create some barcodes, it might be a good idea to check
whether you’ve got the font which converts simple codes into barcodes installed in your computer.
It’s best to check the font list first. If you can’t find it there, you most probably need to install it.
If this is the case, keep watching!
We’re gonna have a look at how to install the barcode font quickly and for free, so you could use it right now.
How to Install Barcode Font in Excel
‘IDAutomationHC38M’ font can be downloaded free of charge from the website IDAutomation.com
We’ve posted the link to the website in the description below.
This website contains all information about the 39 Barcode Font and using the button ‘Download Now’,
you can download the font into your computer.
The downloaded files then need to be extracted from the .zip file, so use a right-click to select ‘Extract All’.
Open the unzipped folder and install the font by clicking on ‘IDAutomation_Code39FreeFont’.
After the successful installation, you’ll be able to use the font immediately in Excel, Word
or other applications that work with fonts.
Once you’re done, open Excel and check the font list,
you should be able to look up the font as ‘IDAutomationHC39M Free Version’.
Are you ready to create some barcodes?
If you found this tutorial helpful, give us a like and watch other video tutorials by EasyClick Academy.
Learn how to use Excel in a quick and easy way!
Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community.
Hit that Subscribe button and join the EasyClickers!
Thanks for watching and I’ll see you in the next video!