KA.Barcode for Excel
How to Create Code 128 Barcode for MS Excel
How to draw and print high-quality Code 128 barcodes in Microsoft Excel
  • Easily generate, insert Code 128 linear barcode images in Microsoft Excel 2007/2010 spreadsheets
  • Embedding dynamic linear & 2D barcodes, such as Word EAN-13, .NET Data Matrix, .NET ITF-14, PDF417 Excel, in your applications
  • Compatible with Windows 7, Windows Server 2008, Windows Vista, Windows XP, etc.
  • Create and embed high-quality Code 128A, Code 128B, Code 128C in Microsoft 2007 & 2010
  • Simple to adjust Code 128 barcode settings like module width, image width, height, orientation, etc.
  • Support Code 128 resolution adjustments to go with all printers
  • Complete user manual Java barcode generation, C# barcode generation & Excel barcode sample provided
  • Checksum digit automatically is added for Code 128 as specified in specifications
Code 128 Introduction
Code 128, also named as ANSI/AIM 128, ANSI/AIM Code 128, USS Code 128, Uniform Symbology Specification Code 128, Code 128 Code Set A, Code 128 Code Set B, Code 128 Code Set C, Code 128A, Code 128B, Code 128C, is a self-checking linear bar code which encodes 128 ISO/IEC 646 characters.
Code 128 Encodable Character Set:
  • Code 128 A (Code Set A): 0-9, A-Z, and special characters
  • Code 128 B (Code Set B): 0-9, A-Z, a-z, and special characters
  • Code 128 C (Code Set C): numeric digit pairs 00-99 and three special characters
  • KA provides Code 128Auto to allow encoding of the above data types with automatic shifting among three code sets.
Code 128 symbol length is variable.
Code 128 Generation in Excel

How to Install KA.Barcode for Excel

  1. 1.
    Make sure all Microsoft Office Excel spreadsheets are closed
  2. 2.
    Download and unzip the KA.Barcode for Excel addin evaluation package
  3. 3.
    Run "KA.Barcode for Excel 2007 Add-In" or "KA.Barcode for Excel 2010 Add-In" setup file
  4. 4.
    Open a new Excel spreadsheet and click "Install" in the pop-up window

How to Insert Code 128 Barcode in MS Excel

  1. 1.
    Go to "Add-Ins" tab, click "Insert Barcode", and a barcode setting panel appears on the right side
  2. 2.
    Choose a cell, select "Code128" barcode symbology, and enter valid data
  3. 3.
    Change barcode property default values, and then click "Insert" button
  4. 4.
    After that, you can make adjustment for the inserted barcode images, and click "Update"

How to Generate Code 128 List in Excel

  1. 1.
    Move to "Add-Ins" tab, and click "Insert Barcode" to activate the barcode setting panel
  2. 2.
    Choose a list of cells with target data, or select a list of cells and input valid data
  3. 3.
    Then choose "Code128Auto" barcode type in the "SYMBOLOGY" pull-down menu
  4. 4.
    Click "Insert". Now, all the selected cells are turned into Code 128 barcode images

How to Link Barcode to Cell in MS Excel

  1. 1.
    Open an Excel spreadsheet, generate a Code 128 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 Code 128 image is successfully linked to the data in the cell
  4. 4.
    You can also link multiple images to cells and revise the linked data
  5. 5.
    Then choose one linked Code 128 images and click "Update"
  6. 6.
    Now all the linked Code 128 images will be updated to the revised data in selected cells
Code 128 Barcode Featured Settings in Excel
To meet more requirements in every walk of life, Code 128 was developed to contain three unique data character code sets: code set A, B and C. Users can choose different barcode type in "SYMBOLOGY" pull-down menu according to concrete demands.
In addition, Code 128 is available to be used by GS1 system using "Apply Tilde Function". This function is designed for Code 128 to encode some special characters and Application Identifiers (AI). After that, click "Update".