UPC-A Barcode Add-In for Microsoft Excel 365

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

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
   

OnBarcode Excel Barcode Generator add-in provides 30+ options to customize generated barcodes in Excel file.

Below is the basic steps to customize an existing UPC-A barcode image in Excel.

1. Select a UPC-A barcode image to customize
2. Change the options in "Barcode Settings" pane
3. Click Update button on "Barcode Settings" pane to apply the barcode customization
   

Here we will show you a simple demo to customize UPC-A bar module colors in Excel application.

1. Select the UPC-A barcode image in cell B2
2. Change the Fore color to red in "Color" group under "Barcode Size" tab
3. Click Update button. Now you can see the customization applied on the UPC-A barcode image.
   

When the barcode add-in is open in Excel application, any cell value changes, the linked UPC-A barcode will be automatically updated.

You can see the details about barcodes update automatically and manually here:
How to create and update barcodes automatically and manually in Excel?

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 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 GS1 business message, and followed by a check digit.

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

Using OnBarcode Excel Barcode add-in freeware, you may provide 11 digits or 12 digits for "Data" property for the main UPC-A barcode. To generate the UPC-A images below, you can provide the following text string to Data property.

• 12345678912+12 (11 digits) or 123456789128+12 (12 digits) for the first UPC-A barcode
• 12345678912+12345 (11 digits) or 123456789128+12345 (12 digits) for the second UPC-A barcode

UPC-A barcode with two-digit add-on

UPC-A barcode with five-digit add-on

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?

Note: the following tutorial is for old version of Excel Barcode Add-in (Version 10) only.

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?