UPC-A Barcode Add-In for Microsoft Excel

In this Excel user guide, you will learn how to create, insert UPC-A barcode images in Microsoft Office Excel files

• Easy to generate a single UPC-A barcode or multiple UPC-A barcodes in Microsoft Excel document
• Support Microsoft Office Excel 365 on Windows, Excel 2021, 2019, 2016, 2010, 2007 versions
• Make and print standard UPC-A barcodes or UPC-A with supplemental 2-digit, or 5-digit code
• Customize generated UPC-A image in Excel with specified image width, height, image resolution, module colors, text font styles
• No font, macro, vba, script programming needed

UPC-A barcode Add-In for Excel is one of our advanced Excel barcode add-ins which has strong functions. It enables users to create and insert a single UPC-A barcode or an UPC-A barcode list on Microsoft Office Excel spreadsheets easily and quickly.



OnBarcode.com provides Excel Barcode Add-in freeware without vba, macro, font for Microsoft Excel as well as other professional & reliable 1D & 2D barcode add-ins for Excel and Word, including Code 39 excel add-in, Code 128 in excel, GS1-128 generator for excel, QR Code generator for excel, Data Matrix for excel, etc.

You can find detailed user guide on How to create, print barcode in Excel?, and Download & Install Barcode Add-in for Excel

UPC-A barcode can encode numeric data from 0 through 9.

A standard UPC-A bar code are grouped by four areas: a number system, a menufacturer code, a product code and a check digit.

Each standard UPC-A barcode totally includes 12 digits (0 through 9). The first 11 digits are data message, and followed by a check digit.

UPC-A may also includes a supplemented barcode with 2 digits or 5 digits.

UPC-A with 2 digits supplemented barcode

UPC-A with 5 digits supplemented barcode

The UPC-A checksum digit is based on a modulo 10 calculation based on the weighted sum of the values of each of the digits in the number system, manufacturer code, and product code.

Using Excel Barcode Generator add-in freeware, you do not need input the last check digit. The barcode software will automatically calculate the UPC-A check digit for you. If your provided UPC-A data includes the 12th digit, the barcode software will ignore it, and calculate the checksum digit based on your first 11 digits. You can learn more about the UPC-A check digit calculator here
How to calculate UPC-A check digit?

• Barcode Type: choose "UPC-A" for UPC-A barcode, "UPC-A +2", or "UPC-A +5" for UPC-A barcode with 2-digit or 5-digit supplemented data.
• Data: UPC-A barcode encoding data. The valid UPC-A data formats is 11 or 12 digits (0-9). If UPC-A barcode includes supplemented barcode, add "+" with supplemented data. For example, UPC-A with 2-digit supplemented data "12345678901+12".

• Bar height: (In Supplement data under tab "1D Barcode" ) This is a multiplicator of the height of the bar module; The default is 0.8 (80% of Y - bar module height).
• Bar space (in px): The space between the UPC-A bar module and the supplement bar. Default is 15 pixel.

• UPC-A rendered text, view the options here: How to customize created 1d barcode displayed HRI (barcode text) in Excel
• UPC-A barcode dimension width and height, find details here: Barcode dimension size options in Excel
• UPC-A bar/space module colors, you can quickly apply UPC-A bar and space modules color settings.
  • Bar and space module colors
  • Image with transparent background
  view details here: How to apply barcodes bar and space color settings in Excel?

1. Open an existing Excel documen to insert UPC-A barcodes.
   


2. Go to Excel app toolbar Add-ins, click button Create Barcode from commands group "OnBarcode". Now you can find the Barcode Settings pane open on the right side of the Excel document.
   


3. In Excel sheet, select cell C4, then change Barcode Type to UPC-A, and click button Generate to insert a UPC-A barcode on the selected cell.
   
   
   You can find a new UPC-A barcode printed on the selected cell "C4".
   


4. Here we will adjust the UPC barcode image width and height.
   
   Resize the the UPC-A barcode to the same width and height as cell "C4".
   
   Click the image again to make sure that the barcode settings Image Width and Image Height have updated the adjusted image size.
   
   Click button Update. Now the resized UPC-A barcode has been printed on the cell "C4".
   


5. Last step, we will link the UPC barcode data message to cell B4, and any numbers change on "B4", the UPC barcode will be re-generated by one click.
   
   Select the barcode image on "C4", click button Link To Cell
   
   
   Select the cell B4 which includes the UPC numbers, click button Update
   


6. Now you will find tha the UPC barcode on "C4" is using the UPC numbers from cell "B4".
   

Now you have created a UPC-A barcode successfully on Excel file. You can also easily create multiple/bulk UPC barcodes with few clicks. View more details here:
How to create multiple barcodes in Excel?