Code 128 Barcode Add-In for Microsoft Excel

No barcode Code 128 font, Excel macro, formula, vba, to create, print Code 128 images in Excel spreadsheet

Insert Code 128 barcodes into your Excel spreadsheet using Excel Code 128 barcode generator

In this Excel Code 128 user guide, you will learn how to generate, print high quality Code 128 barcode images in Microsoft Office Excel document.

Code 128 encode character set: Full ASCII and Extended ASCII
Code 128 barcode image dimension size
Code 128 special character encoding
Code 128 for GS1 data message encoding
Support latest version of Office Excel on Windows

How to create Code 128 barcode images in Office Excel document

Download Excel Code 128 Barcode Generator software
Install Excel addon to create Code 128 images in Microsoft Excel files
Step by Step Tutorial

ON THIS PAGE:

Overview
Introduction
Code 128 Data Characters Encoding
Code 128 Barcode Dimension Size
How to create Code 128 Barcode in Microsoft Excel

Seamlessly integrate into Microsoft Office Excel 2019/2016/2013/2010/2007
Easy to install barcode add-in, no need any barcode font, macro vba script.
Easy to generate multiple Code-128 barcodes from a list of cells
Free barcode addin software downloads. Complete demo source code included.
Insert Code 128 barcodes in Excel spreadsheets within a few seconds
Code 128 Add-in may print reliable and professional quality barcodes in Excel
Industry standards of Code 128 are well pre-configured
No specifications of Code 128 are necessary for any users
Programming skills and barcode fonts are not required
Automatically compute and add the check digit of Code 128
High quality Code 128 images are printed even on low-resolution printers

A quick video tutorial for making, printing Code 128 in Excel

Top

Summy:

Install & uninstall barcode Excel add-in
Quick to create a Code 128 barcode
How to generate a valid Code 128 barcode data
How to create Code 128 image by using selected cell data
How to create a high resolution Code 128 image for printing
How to generate list of Code 128 barcodes in Excel

Code 128 Barcode Addin is designed by OnBarcode.com to draw Code 128 barcode images for MS Excel spreadsheet. This barcode generator is able to link barcodes to cell-contents. Besides, the generated barcode images using this add-in do comply with GS1, ISO/IEC specifications.

OnBarcode.com provides Barcode (not font) Excel Generator Add In for Excel as well as other professional & reliable 1D & 2D barcode add-ins for Excel and Word, including Code 39 excel addin, GS1 128 excel addin, UPC-A barcode addin for excel, QR Code generator for excel, etc.

Easily and efficiently insert Code 128 barcode images in Microsoft Office Excel spreadsheets.
Both single Code 128 barcode and Code 128 barcode lists can be created easily and fast in Excel workbooks.
Article lists or catalogues may be produced using our barcode generator addin without any effort.
All selected cells may be converted into Code 128 barcodes and the barcode data can be automatically updated with the excel cell contents.
Parameters of Code 128, such as barcode size, barcode types, rotation etc, may be adjusted or modulated to meet required specifications.
Thermal printers support allows creation of high quality Code 128 barcode images for Excel.
Excel Code 128 Barcode add-in can be compatible with Microsoft Excel Office 2016, 2013, 2010 and 2007.

Code 128 Barcode Data Characters Encoding in Office Excel

Top

Code 128 data character set

Code 128 barcode supports the following data characters

All 128 Full ASCII characters defined in ISO/IEC 646
Extended ASCII characters are also supported.

Code 128 Data Code Sets in Excel

Code 128 will use the following three Code Sets to encode Code 128 data message.

Code Sets A
Code Sets B
Code Sets C

Each Code 128 data message will use one or more Code Sets.

If you do not know how to use the Code Set correctly, you can choose Auto select mode. In Excel Barcode Generator addon property panel, choose value "CODE 128" for property "Barcode Type".

Code 128 Function characters in Excel

Code 128 Function Characters (FNC) define instructions to the bar code reading device to allow for special operations and applications.

FNC1: It is for GS1 system. You will find more information about GS1-128 barcode in Excel
FNC2: It is for message append.
FNC3: It instructs the bar code reader to interpret the data from the symbol containing the FNC3 character as instructions for initialization or reprogramming of the bar code reader.
FNC4: It is used to represent an extended character set (byte values 128 to 255 in ISO/IEC 8859-1 by default)

Using Excel Code 128 barcode generator, you do not need input function characters. Our barcode software will automatically encode them for you.

Code 128 check digit character in Excel

Code 128 barcode includes a mandatory check digit character, which is based on module 103.

The Code 128 check digit will not be displayed in the human readable interpretation (barcode text), and it will not be returned by the barcode decoder also.

In Excel barcode generator library, the property "Add checksum char" under tab "1D Barcode" is not appliable for Code 128. The library will automatically calculate and create a check digit character before the Stop character.

Code 128 Barcode Image Dimension Size in Excel file

Top

Using Excel Code 128 barcode generator Add-in, you can apply the following properties for Code 128 image dimension size.

Unit of Measure. You can choose PIXEL, CM or INCH.
DPI. Image resolution
Bar width (X): Width of narrow element. The mimumum bar width is defined by the application specification
Bar height (Y): Bar module height.
Image width. Code 128 image width
Image height. Code 128 image height
Left margin, Right margin: Quiet zone. the minimum width of quiet zone is 10X.
Top margin, Bottom margin: Quiet zone.
Text margin: Space between bar and text below

You can view the Code 128 Barcode Size Calculator here.

Create Code 128 Barcode into MS Excel

Top

How to Generate Code 128 Barcode for Excel

Start with a new excel workbook to activate the task panel. Choose "CODE 128" that enables the encodable characters automatically to be changed from one code set to another. And type specified data. Then click "Generate" to create the corresponding Code 128 barcode image.

How to Configure Code 128 in Excel

After the generation of Code 128 images, users may move the cursor to "Barcode size" and "1D Barcode". Modulate the width, height, margins, etc. And GS1 Application Identifiers and some special characters can be encoded by checking "Apply title (~)" enables. And then click "Update".

How to Create Code 128 Barcode List in Excel

The Excel Barcode Add-In is used to create not only a single Code 128 barcode image, but also Code 128 barcode lists or tables. Select a column or row of data cells, choose "CODE 128", and then click "Generate".

How to Link Code 128 to Cell for Excel

The "Link To Cell" is a useful barcoding feature of our Excel Barcode Add-In. Open a new Excel spreadsheet to generate a Code 128 image. Then click "Link To Cell" (Undo it, click "Cancel"). Chose a cell with data, and then click "Update".

In addition, this button is also used to create dynamic Code 128 barcode images which will be automatically updated whenever the contents of cells are changed.

More details will be represented by OnBarcode.com with Integration Tutorial for Office Excel Barcode Generator.

Barcode Types Supported by Excel Barcode Generator

Top

1D / Linear Barcodes

2D / Matrix Barcodes: Data Matrix, PDF417, QR Code