Code 2 of 5 Excel Generator Download, Install & Use
Code 2 of 5, also called Standard 2 of 5 or 2 of 5 Industrial, is a continuous, low-density numeric symbology which has variable data length. It is widely used in photofinishing, warehouse sorting industries and sequentially numbering airline tickets.
Code 2 of 5 Add-In for Excel is widely adopted to draw great quality Code 2 of 5 barcodes in Microsoft Office Excel documents. No barcode fonts and programming skills are required and users can adjust the properties of the created barcodes freely.
With Code 2 of 5 Add-In for Excel, Code 2 of 5 barcode generation becomes as easy as clicking a button. Users can make adjustments for the created barcode images with this barcode generator addin based on applications.
Code 2 of 5 Add-In for Excel Features
MS Excel Version |
Work well with Microsoft Office Excel 2007 and 2010 versions |
Multiple Usage |
- Simple to adjust the wide to narrow bar ratio
- Easy to link a barcode with a cell
|
Encodable Characters |
Numeric digits from 0 to 9 |
Barcode Specification |
All the created barcodes comply with the latest Code 2 of 5 barcode specification |
Quiet Zones |
This add-in adds the quiet zones for Code 2 of 5 automatically |
Human-Readable Text |
Users have the choice of displaying the encoded data in Code 2 of 5 or not |
Code 2 of 5 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 Code 2 of 5 Add-In for Excel
- Download and unzip BizCode Add-In for Microsoft Excel;
- Ensure all Excel documents are closed on your computer;
- Run the setup file "setup.exe" to install this plugin;
- Open a new Excel document and click "Install" in a pop-up window;
- Now a tab named "Add-Ins" is placed in the Excel menu bar.
How to Create Code 2 of 5 Barcode in MS Excel?
- Click "Add-Ins" tab and "Barcode Settings" shows up on the right;
- Select "CODE 2 OF 5" in "Barcode Type" pull-down menu;
- Input valid Code 2 of 5 barcode data in the pane under "Data";
- Click "Generate" button and a required Code 2 of 5 barcode is created;
- Now users can modify the properties of the created barcode;
- Just go to "Barcode Settings" panel and revise the properties;
- Click "Update" to finish the revision.
How to Link a Barcode with a Cell in MS Excel?
- Open a new Excel document on your computer;
- Draw a Code 2 of 5 barcode and click "Link To Cell";
- Select a cell with valid Code 2 of 5 barcode data and click "Update";
- Now the barcode image is linked to the data in the cell;
- Multiple created barcodes linked to cells can be updated all together;
- Ensure all the barcodes are linked to different cells first;
- Modify the data in those cells and click "Update Link To Cell";
- Now all the barcodes are updated according to the revised data in the cells!
How to Draw a Barcode List in MS Excel?
- Start a new Excel document and click "Add-Ins";
- A barcode setting panel appears on the right;
- Choose a list of cells in the document and input valid data in them;
- Select all those cells and choose "CODE 2 OF 5" in "Barcode Type";
- Click "Generate" and a barcode list is created on the Excel document!