KA.Barcode for Excel
How to Generate Codabar Barcodes in Excel 2016
How to create and print great quality Codabar barcodes in Microsoft Excel

Bulk barcode generator in Excel: how to create, print multiple barcode labels in Microsoft Excel document



  • Entirely integrate into Microsoft Office Excel 2007 and 2010 versions
  • Compatible with the latest Codabar barcode specifications
  • All printers can print the generated Codabar barcode images easily
  • Directly create and draw Codabar barcodes without using barcode fonts
  • This plugin can be used to convert selected cells, rows and columns to barcodes
  • Data of the Codabar images can be linked with Excel cells contents dynamically
  • The check digit in Codabar is generated fully automatically when required
  • Parameters of Codabar are customizable, including barcode size, rotation, etc
  • No programming skills are required in the operation of this professional plugin
Codabar Introduction
Codabar is a common linear barcode, which is also known as CodaBar, Code 2 of 7, USS Codabar, 2 of 7 Code, Rationalised Codabar, NW-7 and USD-4. This barcode type is commonly used in libraries, blood banks and a variety of other information processing applications.
  • Encodable Character Set: numeric digits 0-9, and six symbols (-$:/.+)
  • Barcode Data Length: variable
Codabar Barcode Generation in MS Excel

How to Install KA.Barcode for Excel

  1. 1.
    Close all the Excel documents on your computer
  2. 2.
    Download and unzip "KA.Barcode for Excel Trial"
  3. 3.
    Double click "KA.Barcode for Excel 2007 Add-In" / "KA.Barcode for Excel 2010 Add-In"
  4. 4.
    Open a new Excel document after step 3
  5. 5.
    Now a tab called "Add-Ins" is inserted in the Excel menu bar

How to Draw a Codabar Barcode in Excel

  1. 1.
    Open a new Excel document and activate "Add-Ins" tab in the Excel menu bar
  2. 2.
    Under the Excel menu bar, click "Insert Barcode" and a barcode setting panel pops up on the right
  3. 3.
    Select "Codabar" in the pull-down menu "SYMBOLOGY" and input valid data in the text box of "VALID DATA"
  4. 4.
    If necessary, modify the properties of Codabar in the barcode setting panel
  5. 5.
    Click "Insert" and a required Codabar barcode is created successfully

How to Insert a Codabar Barcode List in Excel

  1. 1.
    Go to "Add-Ins" tab in an Excel document
  2. 2.
    Click "Insert Barcode" under the menu bar of the Excel document
  3. 3.
    After step 2, a barcode setting panel appears on the right
  4. 4.
    Input valid data in a list of cells and select them all
  5. 5.
    Select barcode type "Codabar" in the "SYMBOLOGY" pull-down menu and click "Insert"
  6. 6.
    Now a list of Codabar barcode images are generated in accordance with contents of the cells

How to Link a Codabar Barcode to Cell Contents

  1. 1.
    Generate a Codabar barcode in a new Excel document and click "Link Barcode to Cell"
  2. 2.
    Select a cell with data and click "Update Barcode" (To undo it, click "Cancel")
  3. 3.
    Now the Codabar barcode image is successfully linked to the data in the cell
  4. 4.
    Additionally, it supports to update multiple barcodes which are linked to cells at one time
  5. 5.
    To achieve the function above, ensure all the barcodes are linked to cells first
  6. 6.
    Revise the data in those cells and then select one of those images
  7. 7.
    Click "Update" and all the barcodes are updated successfully
Codabar Featured Settings in Excel
Specially, a few parameters of Codabar need to be noted here. The first one is the parameter of "Wide Bar to Narrow Ratio" which has the function of adjusting the proportion of the wide bar to the narrowest one. Its valid value is a range of 2.0 to 3.0 inclusive. The second one is the parameter of "Start/Stop Char". As each Codabar barcode has four choices of the start or stop characters (A, B, C, D), this parameter is designed for you to choose the start and stop characters according to your demand.