How to Create a Barcode in MS Excel and Word

Date:2019-9-5 Author:Cordelia

When you buy something in a supermarket, you must notice that there’s a barcode on the back of each product. By identifying the barcode, you can get a lot of information such as the manufacturer, name, date, price and so on. Barcodes are now widely used to identify all kinds of information of a wide variety of items. So how are barcodes created? In fact, you don’t need to download any third-party software. Office programs such as Excel and Word can simply generate barcodes for you.

How to Create a Barcode in Excel

1. To create barcodes in Excel, you can create 2 columns at first. One for barcode number and another for the generated barcode.

How to Create a Barcode in MS Excel and Word

2. Switch to Developer tab, click Insert in Controls.

How to Create a Barcode in MS Excel and Word

3. Select the icon of More Controls at the lower-right bottom of the menu.

How to Create a Barcode in MS Excel and Word

4. Select Microsoft BarCode Control 16.0 in the popping out window, and click OK to implement it.

How to Create a Barcode in MS Excel and Word

5. You mouse will become a small back cross then. Drag it in the cell to generate a barcode.

How to Create a Barcode in MS Excel and Word

6. Right-click the barcode and choose Microsoft BarCode Control 16.0 ObjectProperties in the menu.

How to Create a Barcode in MS Excel and Word

7. You can change the style of barcode here according to your need. Click ApplyOK to confirm the setting.

How to Create a Barcode in MS Excel and Word

8. Then click Properties in the right-click menu.

How to Create a Barcode in MS Excel and Word

9. Input A2, which is the cell you entered the barcode number, in the textbox of LinkedCell. Then click the close button to quit the Properties window.

How to Create a Barcode in MS Excel and Word

Now the barcode is generated correctly.

How to Create a Barcode in MS Excel and Word

How to Create a Barcode in Word

1. Switch to Developer tab, click Legacy ToolsMore Controls.

How to Create a Barcode in MS Excel and Word

2. Select Microsoft Barcode Control 16.0 and hit OK to insert a barcode in your document.

How to Create a Barcode in MS Excel and Word

3. Right-click the generated barcode and choose Microsoft BarCode Control 16.0 ObjectProperties to adjust the barcode style.

How to Create a Barcode in MS Excel and Word

4. Then choose Properties in the right-click menu.

How to Create a Barcode in MS Excel and Word

5. Enter the barcode number in the textbox of Value. Then click the close button to quit the Properties window.

How to Create a Barcode in MS Excel and Word

6. Now the barcode is correctly generated in Word as you need.

How to Create a Barcode in MS Excel and Word

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

4 responses to “How to Create a Barcode in MS Excel and Word”

  1. Tom says:

    The Microsoft Barcode Control 16.0 is not available in the pull down in Microsoft 365. Is it available to install/upgrade?

  2. sen says:

    Hi
    Can’t find Microsoft Barcode control in my excel vba references.where to find it?I use excel 2016.

    • Sandra says:

      Go to Developer in the top toolbar and you can find an Insert Controls option, and click on the arrow behind Insert then choose the last one, More Controls.

Leave a Reply to Sandra Cancel reply

Your email address will not be published. Required fields are marked *