قالب وردپرس درنا توس
Home / Tips and Tricks / How to Create Excel Barcodes | PC world

How to Create Excel Barcodes | PC world



Can Excel create barcodes? Yes, and it's as easy as downloading the right fonts. You do not have to buy any of these barcode software programs that you can find online, unless you need a more unusual code, such as an ISBN or postal code. For most common barcodes, free fonts are available, for the other paid (at low prices).

There are also many websites that generate barcodes for you that cost nothing (although some ask for donations). My favorites are: Online Barcode Generator, which offers 102 different barcode types (Free Barcode Generator (with 99 different types)) and Barcode Generator.org (with 67 different types). I bet you did not know that there are so many different barcodes.

However, if you prefer to generate your own barcodes in Excel (or Word, PowerPoint, or another program that uses Windows fonts), you can do so as well, and it's really easy.

How to Download Bar Code Fonts

First, you need to access the Internet and download the appropriate fonts. The most commonly used barcodes are:

  • UPC-A and UPC-E codes (Universal Product Code) are used for consumer products (food, household goods, etc.). They are scanned at the point of sale (POS).
  • EAN-13 and EAN-8 codes, ie European article numbers, have a similar purpose to UPC codes.
  • Code128 codes referring to the A 128-character ASCII set is used in logistics for ordering, distribution and transport.
  • Code39 codes, literally code 3 of 9, use 39 digits and characters. These codes are used for the automotive industry, nameplates, inventory and industrial applications.

Here is an example of using these fonts.

. 1 Click Barcode Link to locate and download the free barcode fonts for Code128 and Code 39 (use the font Free 3 of 9 Extended fre3of9x.ttf ).

. 2 Double click on the link Download Code 128 Barcode Font. Click the Save button and then click OK .

. 3 When the Font dialog box opens, click the Install button to add this font to your Windows font folder.

Repeat steps 1 to 3 for the link Download 3 of 9 Barcode Font

  001 Code128 and Code 39 Barcode Fonts Download JD Sartain / IDG Worldwide

Barcode Fonts Code128 and Download Code 39

Click on this Link UPC-A barcode and then on this Link link for the EAN-13 barcode.

. 1 Double-click the button named: Download the UPC-A font (do not click the Start ) button.

. 2 Click the Save button, and then click OK .

. 3 When the Font dialog box opens, click the Install button to add this font to your Windows font folder.

. 4 Repeat steps 1 to 3 for the button: Download the EAN-13 font .

  002 Download the barcode fonts upc a and ean 13 JD Sartain / IDG Worldwide

Download the UPC A- and EAN-13 barcode fonts

NOTE: To verify that the font has been downloaded, open the Fonts folder ( C: Windows Fonts ). Click column Date Modified to sort by the last modified date of the file. The four font files should be displayed at the top of the list.

Enter the barcode numbers in Excel

The rest is even easier. Open a new or existing table. For this exercise, which will show you how the barcode fonts work in Excel, follow these instructions:

1. Enter column heading font name in A1. Enter the column header Barcode in B1.

Enter the following information into cells A3, A6, A9, and A12: Code 39, Code 128, UPC-A and EAN-13 .

In B3 and B6, enter some product names consisting of numbers and text, for example: 1excel11 and 4windows4 . Copy the same text into cells B4 and B7.

Enter 10 numbers in cell B9 and 13 numbers in cell B12. Copy the same names in B10 and B13.

Position the cursor on cell B3 and select font 3 of 9 Extend in the Home Font tab. Click the small arrow in the lower-right corner to display a list of all your system's fonts in the C: Windows Fonts folder, then scroll to the appropriate font and click it.

Move Move the cursor to cell B6 and proceed as described above. However, choose the font labeled Code 128 .

Repeat step 5 for cells B9 and B12, and select Fonts UPC-A and EAN-13 respectively from the list.

Now you can simply enter the barcode numbers and select the appropriate font to get a usable, searchable barcode for the products you are carrying.

  003 Examples of Barcode Fonts in Excel JD Sartain / IDG Worldwide

Examples of Barcode Fonts in Excel

Using the Barcode Add-ins of Excel

If you do not use hundreds of barcodes per week I recommend using one of the free online barcode generators or one of the free barcode fonts listed above. There are add-in programs that you can use in Excel to create these barcode fonts. These are neither free nor cheap. However, all three programs listed below offer free trials.

. 1 TBarCode Office MS Add-In – For a single license, a computer costs $ 104. You can try a free demo using this link.

. 2 Barcode Generator for Excel – A single license costs $ 159.

. 3 ConnectCode Barcode for Excel – The single license for this license is $ 149.

If you want to use one of the add-ins, use these instructions to install the program on your system.

. 1 Select one of the add-in programs from the links above.

. 2 After opening the site, click the Download or Buy Now button.

. 3 Follow the instructions on the screen to download the add-in to your hard drive. Note where the system installs the program (drive, path, etc.).

NOTE: Most programs are smart enough to place the add-in program in the appropriate Excel folder. If this is not the case, you need to know where the program was installed so that you can later tell Excel when you enable the add-in.

. 4 With Excel open, select File> Options> Add-ins .

. 5 If the newly installed add-in does not appear in the list, click the Manage link (bottom of the screen), select Excel Add-Ins from the list and then click on the button Go .

  004 Install Add-Ins JD Sartain / IDG Worldwide

Install Add-Ins

6. When the Add-Ins dialog box appears, highlight the add-in to be activated, and then click OK .

. 7 If your destination add-in is not listed, click the Browse button and navigate to the new add-in folder. Select it and click OK . 19659002] If the add-in is installed and enabled, follow the instructions on the manufacturer's website to use the new program to create, manage, and print your barcodes.


Source link