KA.Barcode for Excel
How to Generate UPC-E Barcodes in Excel
How to draw and print great quality UPC-E barcode images in Microsoft Office Excel
  • Integrate seamlessly into Microsoft Excel 2007 and 2010 versions
  • Pre-configure UPC-E barcodes in accordance with the latest UPC-E barcode specification
  • The created UPC-E barcodes can be printed by all printers
  • Insert high quality UPC-E barcodes quickly and easily in Excel
  • Support Add-On barcode creation for UPC-E barcode in Excel
  • Parameters of the created UPC-E barcodes are available to be adjusted
  • UPC-E barcode data can be linked with Excel cell contents dynamically
  • Easily convert an entire column or row of data into UPC-E barcodes
  • Automatically add the checksum digit for the UPC-E barcodes in this plugin
  • No barcode fonts and programming skills are needed in barcode generation
UPC-E Introduction
UPC-E is a short version of UPC symbol, always starting with a zero. It is suited for identifying products in small packages. The data length of UPC-E is fixed: 6 digits, excluding a number system and a check digit.

Encodable Character Set:
  • numeric characters 0-9: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9
UPC-E Generation in Excel

How to Install KA.Barcode for Excel

  1. 1.
    Ensure all the Excel documents are closed before installation
  2. 2.
    Download "KA.Barcode for Excel Trial" and unzip it
  3. 3.
    Double click "KA.Barcode for Excel 2007 Add-In.exe" / "KA.Barcode for Excel 2010 Add-In.exe"
  4. 4.
    Open a new Excel document on your computer
  5. 5.
    Now "Add-Ins" is placed in the Excel menu bar

How to Draw an UPC-E Barcode in Excel

  1. 1.
    Open an Excel document and Switch to "Add-Ins"
  2. 2.
    Click "Insert Barcode" below the menu bar and a barcode setting panel appears on the right
  3. 3.
    Select "UPCE" in "SYMBOLOGY" pull-down menu
  4. 4.
    Type valid data in "VALID DATA". You can take "123456" as an example
  5. 5.
    (Optional) Revise the parameters of the barcode, like rotation, font, etc
  6. 6.
    Click "Insert" in the barcode setting panel
  7. 7.
    Now an UPC-E barcode is successfully generated

How to Insert an UPC-E Supplement 2 or 5 Barcode

  1. 1.
    Click "Add-Ins" tab in the menu bar of a new Excel document
  2. 2.
    Click "Insert Barcode" and a barcode setting panel pops up on the right
  3. 3.
    Select "UPCE Sup2" or "UPCE Sup5 in "SYMBOLOGY" pull-down menu
  4. 4.
    Input valid data excluding supplement data in "VALID DATA"
  5. 5.
    Type valid supplement data in "Supplement Data" under "Special Properties"
  6. 6.
    Click "Insert" and the generation of an UPC-E Supplement 2 or 5 barcode is finished

How to Create an UPC-E List in Excel

  1. 1.
    Activate "Add-Ins" tab in an Excel document
  2. 2.
    Below the menu bar, Click "Insert Barcode" and a barcode setting panel shows up on the right
  3. 3.
    Type valid data in a list of cells and select them all
  4. 4.
    Choose barcode type "UPCE" in "SYMBOLOGY" pull-down menu
  5. 5.
    Click "Insert" and all the cells in the list are converted into a list of UPC-E barcode images

How to Link UPC-E Barcode to Cell Contents

  1. 1.
    Click "Add-Ins" -> "Create Barcode". You can see a barcode setting panel on the right
  2. 2.
    Select "UPCE" in "SYMBOLOGY" and input "123456" in "VALID DATA" as an example
  3. 3.
    Click "Insert" in the barcode setting panel
  4. 4.
    Select the created UPC-E barcode and activate "Link Barcode to Cell"
  5. 5.
    Choose a cell with valid data and then click "Update Barcode"
  6. 6.
    Now the UPC-E image is completely linked to the data in the cell
Additionally, several UPC-E barcodes which are linked to different cells can be updated all together. The steps in detail are as follows: firstly, you should make sure all the barcodes are linked to different cells. Then, modify the data in the cells and select one of those barcode images. Then click "Update". Now, you can see all the UPC-E images are updated in accordance with the corresponding revised data in the cells.