How to Create Barcodes in Excel with a Given Size
BizCode Add-in for Microsoft Excel is an Excel add-in that allows users to easily add and display barcode Microsoft Office Excel 2007 and Microsoft Office Excel 2010. BizCode Add-in for Microsoft Excel supports 20+ linear barcode symbologies, including Codabar, Code 39, Code 128, EAN, GS1 128, Intelligent Mail, Interleaves 2 of 5, ISBN, ISSN, ITF-14, UPC-E, etc. 2D barcodes such as QR Code, Data Matrix, and PDF-417 are supported as well.
Rich barcode options are provided to implement barcode size customization including bar size, image size and margin width. Here is a tutorial about how to create barcodes in Microsoft Office Excel with given size.
Compatibility & Requirements
Environment Compatibility
- Microsoft Windows XP /7/ Vista - Windows Installer 3.1, - VSTO 3.0 Runtime SP1, - .NET Framework 3.5 SP1 |
Microsoft Office
- Microsoft Office Excel Workbook 2007 - Microsoft Office Excel Workbook 2010 |
Compatibility & Test Environment
Compatible Operating Systems
- Microsoft Windows 7 - Windows Server 2008 - Windows Vista - Windows Server 2003 - Windows XP |
Test Environment:
-Microsoft Office Excel Workbook 2007 |
How to Create Barcodes in Excel with Fixed Bar Width
- Download BizCode Add-In for Microsoft Excel and unzip;
- Closed your Excel and run the Setup file;
- Click the "next" button and the add-in will be installed successfully in four steps;
- Open your Office Excel, you will find the barcode encoding add-in under the "Add-ins" tab;
- In "Barcode Setting Panel", choose "Barcode Type" to your target symbology and input data;
- In "Barcode Size" Panel, disable the AutoSize function;
- Give value to "Bar width (X)";
- Click "Generate".
How to Create Barcodes in Excel with Given Image Size
- Download BizCode Add-In for Microsoft Excel and unzip;
- Closed your Excel and run the Setup file;
- Click the "next" button and the add-in will be installed successfully in four steps;
- Open your Office Excel, you will find the barcode encoding add-in under the "Add-ins" tab;
- In "Barcode Setting Panel", choose "Barcode Type" to your target symbology and input data;
- In "Barcode Size" Panel, check "AutoResize" to enable the AutoResize function;
- Give value to "Image width";
- Click "Generate".