UPC-A Barcode Add-In for Microsoft Excel

No barcode font, Excel macro, formula, vba, to create, print 1D barcode images in Excel spreadsheet

Create high quality UPC-A barcode images in Excel spreadsheets with this add-in



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

How to create UPC-A barcodes in Microsoft Excel?

  1. Download UPC-A Barcode for Excel Add-in
  2. Install barcode add-in to create UPC-A barcodes in Excel files
  3. Step by Step Tutorial








[Video] How to make, print UPC-A barcodes in Microsoft Excel files?

Top


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 Data Characters Encoding in Excel

Top

UPC-A data character set

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.





How many digits is UPC-A

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




UPC-A check digit in Excel

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?




UPC-A barcode with options in Microsoft Excel

Top

Basic Settings

  • 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".

UPC-A Supplemented Barcode

  • 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.

Barcode Common Settings









How to convert UPC code to barcode in Excel?

Top
  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?
















OnBarcode is a market-leading provider of barcode imaging generator, reader controls and components for ASP.NET, Windows Forms, WPF, as well Java, Android, iOS (iPhone, iPad) across all major enterprise development platforms. We provides comprehensive tutorials and how-tos for various linear, 2d barcode information, such as C# in ASP.NET, C# .NET, C# Barcode Encoding, C# Barcode Image, VB.NET in ASP.NET, VB.NET Winforms, VB.NET Barcode Encoding. OnBarcode barcode products are supported by RasterEdge ASP.NET Document Viewer, which supports ASP.NET PDF Viewer, ASP.NET MVC Document Viewer, ASP.NET PDF Editor, MVC PDF Viewer. And provide high quality C# Convert PDF to Tiff, C# Convert PDF to Word, C# Convert PDF to HTML, C# Convert PDF to Jpeg images, and their easy and simple documents, like C# PDF SDK, C# extract text from PDF, C# Compress PDF, Print PDF in C# and C# extract image from PDF.
Terms of Use | Privacy Policy
Copyright © OnBarcode.com . All rights reserved.