Barcode Generator in Excel add in Freeware

How to Generate ITF-14 Barcodes in Excel

How to draw and print high quality ITF-14 barcode images in Microsoft Office Excel

Barcode Generator for Excel add-in > How to generate barcode in Excel? > Create ITF-14 barcodes in Excel

How to create, print barcode ITF-14 in Microsoft Excel

Fully integrate ITF-14 Barcode Add-In into Microsoft Excel 2007/2010
Generate accurate ITF-14 barcodes according to standards of GS1 system
Allow easy generation of barcodes by simply clicking several buttons
Need no barcode fonts and programming skills in this professional plugin
Various ITF-14 barcode properties are available to be adjusted by users
Quickly change an entire column or row containing data into barcodes
ITF-14 barcode data can be linked with Excel cell contents dynamically
Automatically add the check digit and quiet zones in barcode generation
The created ITF-14 barcodes are compatible with all printers and scanners

This guide uses a guided, structured approach to help you master ITF-14 barcode generation in Excel. Whether you're a beginner or need a quick reference, you can follow these steps to create professional, scannable ITF-14 barcodes with ease. We'll use simple explanations and clear Excel operations to make every step straightforward.

Quick Start: Generate Your First ITF-14 Barcode in Excel

Creating an ITF-14 barcode is fast and simple with the KeepAutomation Excel Add-in. You can complete the entire process in just a few clicks. Let's get started.

In your Excel spreadsheet, click cell B2 to select it. You will see a blue border around the cell when it is selected.
Ensure cell B2 contains 13 numeric digits. For example, you can enter "1234567890123" if the cell is empty.
First, let's clarify the key term: ITF-14 (Interleaved 2 of 5-14) is a fixed 14-digit linear barcode, commonly used for packaging and logistics (think of it as a "shipping label ID" for products). You can provide 13 data digits (the add-in will automatically calculate the 14th check digit) or 14 digits (with the last digit being the check sum).
In the "Barcode Settings" pane (right side of the window), confirm the "Basic Settings" tab is selected. It is the first tab at the top of the pane.
Locate the "Barcode Type" dropdown menu, which is near the top of the "Basic Settings" tab, just below the pane's title.
Click the "Barcode Type" dropdown and scroll through the list to select "ITF-14".
Find the "Data" text box directly below the "Barcode Type" dropdown. Delete any default text in this box, then enter =LINK(B2) to link the barcode to the data in cell B2. This link works like a simple formula. If the data in B2 changes, the barcode will update too (when the "Barcode Settings" pane is open).
Locate the green "Generate" button at the bottom of the "Barcode Settings" pane. It is positioned between the gray "Update" button (left) and the red "Delete" button (right), with white text that reads "Generate".
Click the "Generate" button to create the ITF-14 barcode.

Note: If the "Generate" button is grayed out, check two things:

Ensure cell B2 is selected (it should have a blue border).
Confirm "ITF-14" is selected in the "Barcode Type" dropdown (not another barcode type like Code 128).

Customize ITF-14 Bearer Bars in Excel

Bearer bars are an important part of ITF-14 barcodes. First, let's clarify: Bearer bars (surrounding horizontal and vertical bars) are thick lines that frame the ITF-14 barcode, improving scanning reliability (like a "frame" that helps scanners read the barcode more easily).

Bearer bars are typically recommended for ITF-14 barcodes. If you don't use them, scanning accuracy may decrease. For ITF-14 barcodes printed on labels, you may sometimes see only horizontal bearer bars (along the top and bottom). The KeepAutomation Excel ITF-14 Barcode Generator automatically adds all four bearer bars (horizontal and vertical) to your barcodes. You can easily adjust the bearer bar width to suit your needs. We'll use the ITF-14 barcode you created in cell B2 earlier.

In the "Barcode Settings" pane, click the "Barcode Size" tab. It is the second tab, directly next to the "Basic Settings" tab.
Locate the "Bar Style" group near the middle of the "Barcode Size" tab. This group is clearly labeled and contains settings related to the barcode's appearance, including bearer bars.
Find the "Bearer bar (Horizontal)" and "Bearer bar (Vertical)" input boxes within the "Bar Style" group. These boxes are labeled with their respective names, making them easy to identify.
Enter "2" in both input boxes to set the bearer bar width to 2 pixels. You can use other values if needed. For example, "1" for thinner bars or "3" for thicker bars.
Locate the gray "Update" button at the bottom of the "Barcode Settings" pane. It is positioned between the green "Generate" button (left) and the red "Delete" button (right), with white text that reads "Update".
Click the "Update" button to apply the new bearer bar settings.

Note: If you only want horizontal bearer bars, you can set the "Bearer bar (Vertical)" value to "0". Similarly, set "Bearer bar (Horizontal)" to "0" for only vertical bearer bars.

ITF-14 Introduction

ITF-14 (or ITF) is a variant of the Interleaved 2 of 5 barcode with its specification defined by GS1. It is used widely to create the Shipping Container Symbol and mark cartons & palettes. The data string length of ITF-14 barcode is fixed (13 digits in total, excluding a check digit).

code 39 barcode word 2010, code 128 font for word 2010, how to create qr code and barcode in ms excel, code 128 b excel, excel ean 13 check digit calculation, free 3 of 9 barcode font excel, upc-a font for excel, how to use excel barcode font, how to add barcode in word

ITF-14 Encodable Character Set:

Ten numeric digits from 0 to 9: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9

ITF-14 Generation in Excel

How to Install KA.Barcode for Excel

1.
Before installation, close all the Excel documents
2.
Download "KA.Barcode for Excel Trial" and unzip it
3.
Double click "KA.Barcode for Excel 2007 Add-In.exe" / "KA.Barcode for Excel 2010 Add-In.exe"
4.
Open a new Excel document on your computer
5.
Now you can see "Add-Ins" in the Excel menu bar

barcode scanner c# source code, java barcode, how to print barcode in asp.net c#, vb net barcode printing code, barcode scanner c#, barcode generator project source code in vb.net

How to Draw an ITF-14 Barcode in Excel

1.
Activate "Add-Ins" tab and click "Insert Barcode" under the Excel menu bar
2.
A barcode setting panel appears on the right after step 1
3.
Select "ITF14" in the "SYMBOLOGY" pull-down menu
4.
Input "1234567890123" in "VALID DATA" as an example
5.
(Optional) Adjust the parameters of the barcode in the barcode setting panel
6.
Click "Insert" and an ITF-14 barcode is successfully generated

How to Create an ITF-14 Barcode List in Excel

1.
Open a new Excel document on your computer
2.
Under "Add-Ins" button, activate "Insert Barcode"
3.
Choose a list of cells and input valid ITF-14 barcode data
4.
Select all those cells and Choose "ITF14" in "SYMBOLOGY" pull-down menu
5.
Click "Insert" in the barcode setting panel
6.
Now corresponding ITF-14 images are created in accordance with the cells contents

How to Link an ITF-14 Barcode to Cell Contents

1.
Create an ITF-14 barcode in an Excel document and click "Link Barcode to Cell"
2.
Next, select a cell with valid data and click "Update Barcode"
3.
After step 2, the ITF-14 barcode is linked to the cell contents successfully
4.
Additionally, several ITF-14 barcodes linked to cells can be updated at one time
5.
To achieve this function, you must make sure all the barcodes are linked to cells
6.
Modify the contents in those cells and then select one of the barcodes
7.
Click "Update" and all the barcodes are updated

ITF-14 Featured Settings in Excel

Each ITF-14 barcode image has Bearer Bars which are mandatory unless it is not technically feasible to apply them. This special parameter of ITF-14 barcodes in this plugin is as follows:

"Bearer bar (Horizontal)": This is a special parameter of ITF-14 which indicates the width of the barcode horizontal bearer bars.
"Bearer bar (Vertical)": This is a special parameter of ITF-14 that indicates the width of the barcode vertical bearer bars.

The Bearer Bars aim to equalize the pressure exerted by the printing plate over the whole surface of the symbol and to raise reading reliability by helping to reduce the probability of misreads or short scans.

If printing plates are needed in barcodes printing, the nominal Bearer Bars with a constant thickness of 4.8 millimetres must completely surround the barcode image (including its Quiet Zones) and butt directly against the top and bottom of the bars of the barcode.

If printing plates are not required in barcodes printing, the Bearer Bars with a minimum thickness of twice the width of a narrow bar are needed only at the top and bottom of the symbol, butting directly against the top and bottom of the symbol bars. What's more, printing the vertical sections of the Bearer Bar is not mandatory in this case.

Additionally, the parameter of "Wide Bar to Narrow Ratio" is used to adjust the proportion of the wide bar to the narrowest one. Its valid value is a range of 2.0 to 3.0 inclusive.