First , you need to install BizCode Add-in for Microsoft Excel.
And here is the steps to generate barcodes in excel.
http://www.businessrefinery.com/exce...generator.html

1,Create a new Excel Workbook and activate Barcode Add-In for Excel;
2,Go to "Barcode Setting Panel", select "Barcode Type";
3,Input some data in "Data";
4,Click "Generate"; then a barcode occurs in your Excel Workbook.

It's easy to control and customize its properties.