UPC-A Barcode Add-In for Microsoft Excel 365

Before you can start to create, insert UPC-A barcodes in Excel document, you need download and install barcode add-in first, and open the Barcode Generator Add-in in the Excel application.

1. OnBarcode Excel Barcode Add-In under the Excel "Add-Ins" tab
   
2. Press Create Barcode command to open "Barcode Settings" pane on the right side of the Excel application
   
   
   Now you can start to create, insert UPC-A barcode images to Excel cells using Excel Barcode Generator Add-in.

It is an easy job to create UPC-A barcode in selected cell in Excel.

1. Prepare a Excel file with data 12345678901 on cell A2.
   Here we will create a UPC-A barcode on cell B2 using the cell A2 value.
   
2. Select cell B2
3. Change Data text box value to =LINK(A2) on "Barcode Settings" pane.
4. Click Generate button to create and print UPC-A barcode on cell B2
   
5. Now a UPC-A barcode with data from cell A2 value has been printed on cell B2 in Excel document
   

If you do not need the printed UPC-A barcodes any more, you can select the UPC-A image and click Delete button on "Barcode Settings" pane to remove it.

You can also select the UPC-A barcode images, and press delete or backspace to delete them.

Here will instruct how to create bulk of UPC-A barcodes encoding list of cell' values.

We have prepared a sample Excel document, with list of UPC-A codes on column B, and we will create UPC-A barcode images on column C with few clicks.

1. Select the created UPC-A barcode on cell C4. Here you will find the following information on the "Barcode Settings" pane.
   
   
   Now you can start to create multiple UPC-A barcodes, and all these barcodes will have the same barcode properties as UPC-A barcode on cell C4.
2. Select multiple cells from C5 to C7
3. Click Duplicate All button to create all UPC-A barcodes in the selected cells.
   
4. You will find the printed UPC-A barcode images from cell C5 to cell C7, and their encoding data are using cell C5 to cell C7's values.
   

UPC-A may include a two-digit or five-digit add-on symbol.

Using Excel Barcode Generator Add-in, you can append the UPC-A data with add-on data, and using + to seperate them. For example, 12345678901+12. Here 12345678901 is the UPC-A data, and 12 is the add-on data.

Here we will demonstrate how to create UPC-A barcode with two-digit add-on code in Excel file.

1. In cell A2, input cell value 12345678901+12
2. Select cell B2, and change the Data value to =LINK(A2)
3. Choose "UPC-A +2" from Barcode Type drop down list
4. Click Generate button to create, make UPC-A barcode in cell B2
   
5. A UPC-A with two digits add-on barcode has been created and printed on cell B2, and the barcode data is using cell A2 value.
   Any changes on cell A2, the UPC-A barcode will be updated automatically.
   

Excel Barcode Generator add-in provides several barcode options to customize UPC-A add-on barcodes.

You will find the options from EAN / UPC group in "1D Barcode" tab.


You will find more information about EAN/UPC add-on barcode customization here:
How to create, print EAN-13, UPC-A add-on barcodes in Excel?

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

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?