How to Generate UPC-A in Excel
UPC, short for Unites Product Code, is generally used in USA and Canada, widely used in many fields. UPC is a linear barcode with a fixed-length. There are 5 types of UPC barcode and UPC-A is used for representing common goods.
UPC-A Add-In for Excel is an easy-to-use barcode generating add-in that enables you to generate, create UPC-A barcodes directly within Microsoft Excel documents, including MS-Excel 2007 and MS-Excel 2010. It also supports to insert supplementary EAN-2 and EAN-5 add-on barcodes in your Microsoft Excel documents.
UPC-A Add-In for Excel provides several methods to create UPC-A barcodes or barcode lists with specified size, image quality, and human-readable text in Excel cells. Here is a detailed guide for making UPC-A barcodes in Excel; more specific guides please see:
user manual for UPC-A data encoding,
user manual for UPC-A image setting, and
user manual for UPC-A size setting.
UPC-A Add-In for Excel Features
Encodable Characters | Support to encode: - 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 |
Supplementary Barcode | Support to encode supplementary barcode EAN-2 & EAN-5 barcode for UPC-A barcodes |
Barcode Specification | Support to generate & create accurate UPC-A barcodes according to GS1 General Specification (Version 8) |
Easy to use | Generate UPC-A barcode with a few clicks. Require no programming knowledge or barcode font |
Adjustable Barcode | Freely adjust UPC-A barcode image, including module width, bar/space ratio, rotation, colors, fonts, alignment etc. |
Check Digit | Automatically add and display check digit for UPC-A barcode data string |
UPC-A Add-In for Excel Requirements
Windows OS & .NET Compatible with Microsoft Windows 7/XP/Vista, Windows Installer 3.1, VSTO 3.0 Runtime sp1, and .NET Framework 3.5 sp1. | Microsoft Office Compatible with Microsoft Office Excel Workbook 2007; Microsoft Office Excel Workbook 2010. |
Install UPC-A Add-In for Excel
- Download BizCode Add-In for Microsoft Excel and unzip;
- Closed your Excel and Run the Setup file;
- Open your Office Excel, you will Excel barcode add-in has been installed successfully!
How to Generate UPC-A Barcode in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "UPC-A";
- Input some data - "12345678901" in "Data";
- Click "Generate"; then a UPC-A barcode occurs in your Excel Workbook.
How to Generate UPC-A Barcode with 2 & 5 digits Add-On in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "UPC-A+5";
- Input some data - "12345678901" in "Data";
- Click "Generate"; then a UPC-A barcode occurs in your Excel Workbook;
- Go to "Linear Barcode" and input "56497" in "Supplement Data";
- Click "Upgrade"; then a UPC-A+5 barcode occurs in your Excel Workbook.
How to Link cell with a UPC-A Barcode in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "UPC-A";
- Input some data - "12345678901" in "Data";
- Click "Generate"; then a UPC-A barcode occurs in your Excel Workbook;
- Click on a cell with data and click "Link to Cell";
- Click "Update"; then a UPC-A barcode occurs in the cell you choose.
How to Generate Multiple UPC-A Barcodes in Different Cells?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "UPC-A";
- Input some data - "12345678901" in "Data"; click "Generate"; then a UPC-A barcode occurs in your Excel Workbook;
- Click on a cell with data and click "Link to Cell";
- Click "Generate"; then a UPC-A barcode occurs in the cell you choose;
- Change the data in the cell you choose and click "Update Link to Cell";
- Click "Update"; then a different UPC-A barcode occurs.
How to Generate UPC-A Barcode list in MS-Excel?
- Create a new Excel Workbook and activate BizCode Add-In for Microsoft Excel;
- Go to "Barcode Setting Panel" and choose "Barcode Type" to "UPC-A";
- Input some data in all the cells that you want to convert to barcodes;
- Select all the cells that you want to convert to barcodes and click "Link to Cell";
- Click "Generate"; then a list of UPC-A barcodes occurs in cell you choose.