Making Barcode in Microsoft Excel

Making Barcode in Microsoft Excel

Table of Contents

Some examples, how to create barcodes in Microsoft Excel without programming with ActiveX-based version of StrokeScribe barcode generator.

For automatic/bulk barcode placement and VBA-based examples, see the related tutorials.

Requirements

These examples are compatible with all Microsoft Excel versions, starting from Excel 2007.

The barcode generator is not compatible with the online version of Office.

Barcode Ribbon Add-in for Microsoft Excel

You can use our Ribbon Add-in to automate barcode placement in Excel. The add-in is a helper to simplify the ActiveX placement on a worksheet.

Inserting barcode in Excel with Ribbon add-in

Inserting Barcode in Excel as an Active Document

The easiest method but provides less customization. It allows to choose a barcode type and enter the data to encode in the barcode. If you need more customization, see the ActiveX-based example below.

Barcodes inserted as Active Documents are not designed for VBA automation.

1. Switch to the Insert tab on the Excel Ribbon and click Object:

Inserting a barcode object from Ribbon

2. Look for and select the StrokeScribe Document, then press the OK button. The barcode will appear on the worksheet.

A list of available OLE objects in Excel

3. Right-click the barcode object and select StrokeScribe Control Object->Properties from the context menu:

Barcode object context menu in Microsoft Excel

4. Select the desired barcode type and enter some text to encode in the barcode as shown on the picture:

Barcode properties dialog in Microsoft Excel

How to Remove a Border Around the Barcode

To remove the border around the barcode, right-click the barcode object and select Format Control from the context menu. Switch to the Colors and Lines and set the line color to No Line as shown on the picture:

How to remove a border around the barcode in Microsoft Excel
Facebook X Bluesky Youtube Contacts

© 2025 StrokeScribe. All rights reserved. Use of any portion of this site constitutes acceptance of our Terms of Use and Privacy Policy. The website material may not be reproduced, except with the prior written permission.