How to create, print Code 128 Barcode in Excel using
Code 128 add-in (no font)?

• Create, insert Code 128 barcodes in Microsoft Excel spreadsheets within a few seconds
• Seamlessly integrate into Microsoft Office Excel 365/2021/2019/2016/2013/2010/2007 on Windows
• Free to download and install barcode generator add-in, no need any barcode font, macro vba script function.
• Easy to generate multiple Code-128 barcodes from a list of cells
• Free barcode add-in freeware downloads with complete user guide included
• Code 128 Add-in may print reliable and professional quality barcodes in Excel
• Industry standards of Code 128 are well pre-configured
• Programming skills and barcode fonts are not required
• High quality Code 128 images are printed even on low-resolution printers

How to create Code 128 barcode in Microsoft Office Excel without font, vba?

1. Free download Excel Code 128 Barcode Generator add-in software
2. Install Code 128 Excel add-in to create Code 128
   images in Microsoft Excel files on Windows
3. Step by Step User Guide

Free Download

[Video] How to download and generate Code 128 barcode in Microsoft Excel?

Top

Code 128 Barcode Add-in 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. You can view the details about barcode generation in Excel here: How to create, print barcode in Excel?

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

Quick to Create, Print Code 128 barcode in Excel

Top

Open Excel Barcode add-in
To convert numbers and text into Code 128 barcode symbol in Excel, please follow the steps below

1. Install Barcode Generator Add-in for Excel on your computer Windows system
2. Create a new Excel file or open an existing Excel document. Go to the Excel software Add-ins tab
3. Open Barcode Settings pane by choosing Create Barcode from the OnBarcode group in the tab "Add-ins"
   

Start insert Code 128 to Excel Cell

1. Select cell C4, where we will create and insert a Code 128 barcode image.
2. Update the Data property value to =LINK(B4). The new Code 128 barcode will encode the cell B4 value.
3. Click Generate button to create barcode.
   
4. Now you will find a Code 128 has been printed on cell C4.

Update Code 128 size & code with covered cell

1. Check "Resize Covered Cell"
2. Click Update button to re-draw the Code 128 barcode.
   Here the barcode add-in will adjust the Code 128 image covered cell C4's width and height to be the same as the Code 128 image's.
   
3. Any value changes on cell B4, the Code 128 barcode on cell C4 will be re-printed automatically.

Start to Install Excel Barcode Add-in

Start using OnBarcode Excel Barcode Generator Add-in in your Excel document now with a free trial.

Start with installing free add-in:

Auto-update Code 128 barcodes

When the OnBarcode Excel Barcode Generator Add-in is open ("Barcode Settings" pane is open in Excel application), any cell values have been modified, the barcode software will automatically update these cells linked barcode images.

Manually update Code 128 barcodes

In the following situations, if the Excel cell's values have been modified, the barcode generator add-in will not update all barcode images automatically.

• The Excel file has been closed, and other 3rd party program has modifed the Excel cell's values.
• The Excel file is open, but the Barcode Add-in is closed.

In the above situations, you can manually update all barcodes in the Excel file.

• Open Excel Barcode Generator Add-in in Excel Application
• Click Update All button to update all barcodes in the Excel document
  
  

Remove Code 128 barcode images

You can easily remove one or more generated Code 128 images in Excel.

• Select the Code 128 images you want to delete
• Click Delete button to remove the barcodes from Excel. Or press delete or backspace from keyboard to delete them.
  
  

Create, print multiple Code 128 barcodes in Excel

Top

It is really an easy job to create, insert bulk/list of Code 128 barcodes on Excel cells.

Here we have prepared one sample Excel document with content inside. We also have created and printed one Code 128 barcode image.


There are 6 rectangle labels inside the Excel file. Each label occupy 5 columns and 7 rows.

For example, the top left label takes the area from Column C to G, Row 6 to 12.

And the text A-1001 is in Cell C7, which is a merged cell, combined from C7 to C11. The target Code 128 barcode area is on Cell E7, which is also a merged cell, combined from Column E to F, from Row 7 to 11

Create, print multiple Code 128 barcodes in Excel

1. Click the generated Code 128 on Cell E7. Now you will find the text "Copy from: Cell [E7] CODE 128" in the "Barcode Settings" pane, which indicates the barcode generator add-in will select the Code 128 barcode on cell E7 as source barcode to paste and duplicate.


2. Hold Ctrl key and select the list of cells to print Code 128, Cell L7, E18, L18, E29, L29


3. Click button Duplicate All
   


4. Now the five new Code 128 barcode images have been generated and inserted to the target Excel cells.
   

You can view more details and tutorials about multiple barcodes generation in Excel here:
How to create multiple barcodes in Excel using Barcode Add-in for Excel freeware?

Code 128 Barcode Data Characters Encoding in Office Excel. No font required.

Top

Code 128, also known as Barcode 128, ANSI/AIM 128, USS Code 128 is a very capable linear barcode of excellent density, high reliability.

Code 128 barcode structure

Code 128 barcode includes the following parts

• Quiet zone
• Start char
• Data characters
• Symbol check char
• Stop char
• Quiet zone

Using OnBarcode Excel Barcode Add-in, you need provide the Code 128 Data characters only. The barcode freeware will automatically calculate and insert other special characters for you.

Code 128 data character set

Code 128 barcode supports the following text string characters

• All 128 Full ASCII characters defined in ISO/IEC 646. See details here: ASCII table
• Extended ASCII characters are also supported. See details here: ISO/IEC 8859-1

Code 128 maximum & minimum text length

The Code 128 specification does not specify the maximum number of characters in a single barcode Code 128 image. However some Code 128 industry standards have limits. For example, GS1-128 (based on Code 128) has maximum 48 characters in one Code 128 barcode.

Code 128 has also not defined minimum data length. However some barcode scanner devices have limits. You need check and update the barcode scanner configuration.

Code 128 Data Code Sets in Excel

Code 128 has defined the following three Code Sets in ISO specification to encode Code 128 data message: Code Set A, Set B, Set C.

In Excel Code 128 generator, you could use barcode type Code 128 A, Code 128 B, Code 128 C to encode each Code Set.

However lots of Code 128 data will include characters from more than one Code sets. To encode these complicated data message, Excel code 128 generator provides a simple solution for you. You could choose barcode type Code 128. The Code 128 generator in Excel will automatically encode the data message with combined Code 128 code sets.

Code 128 Start and Stop characters in Excel

The barcode Code 128 defines 3 Start chars (Start A, B, C) and 1 Stop char. Using Code 128 barcode generator for Excel add-in, you do not need manually key-in Code 128 start and stop chars, OnBarcode Barcode for Excel will automatically insert the right start and stop chars in the correct position in the generated Code 128 barcodes.

Code 128 check digit character in Excel

Each valid Code 128 barcode includes a check digit character, which is based on module 103 algorithm. You can view the details about How to calculate Code 128 check digit with video explained.

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

The Code 128 check character will not be displayed in the barcode Code 128 text label, and will not be transferred by the barcode scanner software and devices.

Code 128 Barcode Image Dimension Size in Excel file using free download Excel barcode add-in

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.

Customize Code 128 barcodes with property settings in Microsoft Excel

Top

Basic Settings

• Barcode Type: choose CODE 128 (Recommended) for Code 128 with Code Sets automatically grouped,
  CODE 128 A for Code 128 with Code Set A,
  CODE 128 B for Code 128 with Code Set B,
  or CODE 128 C for Code 128 with Code Set C,
• Data: Code 128 data to encode. The data here should be compatible with Code 128 supported character sets.

Code 128 Advanced Settings

• Apply tilde (~): If it is checked, the Code 128 barcode generator software allows using the tilde character "~" to specify special characters in the Code 128 input data. For more information, please read the details here:
  How to encode barcode with non-printable characters in Excel document?

Barcode Common Settings

• Code 128 Text Rendering (Human Readable Interpretation) options. You can easily apply the following Code 128 rendered text in Excel document.
  • Display or hide Code 128 text
  • Text font styles
  • Text font size
  • Margin between Code 128 text and Code 128 bar modules
  View details here: How to customize created 1d barcode displayed HRI (barcode text) in Excel
• Code 128 barcode dimension width and height, view details here: Barcode dimension size options in Excel
• Code 128 barcode module colors, you can apply Code 128 bar and space modules color settings:
  • Bar and space colors
  • Transparent background image
  view details here: How to apply barcodes bar and space color settings in Excel?

How to convert ASCII text with non-printing char to Code 128 barcode in Excel

Top

There are few control characters in ASCII and extended ASCII character set are non-printable. To create Code 128 with those non-printable chars in Excel, you need do some extra steps.

To encode non-printable chars in Code 128 in Excel, you need get the non-printable char ASCII value or Extened ASCII value. Then in the Code 128 Data text box, you need add chars in the following format: "~ddd". Here "ddd" is the ASCII value in 3 digits.

Here is an example to generate Code 128 barcode with data "123[CR]111" in Excel. The data "[CR]" is a character for Carriage Return, its ASCII value is 13.

1. Choose Barcode Type as CODE 128
2. Go to tab "1D Barcode", enable property Apply tilde (~)
3. In Data text box, key in 123~013111
4. Press button Update to generate Code 128 with the above settings applied.
   
5. In generated Code 128 barcode text (Human Readable Interpretation in barcode specification) area, it will display the printable characters only.

Start to Download & Install Excel Barcode Generator Add-in

Start using OnBarcode Excel Barcode Generator Add-in in your Excel document now with a free trial.

Start with downloading & installing free barcode add-in: