Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Create A Barcode in Microsoft Excel?

Date:2021-3-19 Author:Sandra

When we go shopping, we can always see the barcode of the product. Do you know how these barcodes are made? Today the author will teach you how to make commodity barcodes in Microsoft Excel. However, the product code needs to be obtained by applying to the relevant department. The author here is just teaching you how to generate a barcode from the code.

Step1: Let’s open an Excel Worksheet, and enter the barcode number.

How to Create A Barcode in Microsoft Excel?

Step2: Click [Developer]→[Insert]→[More Controls]

How to Create A Barcode in Microsoft Excel?

Step3: We choose [Microsoft BarCode Control 16.0] in the More Controls window.

How to Create A Barcode in Microsoft Excel?

Step4: Now, you can find that the cursor becomes a cross, and you can insert the barcode in the cell.

How to Create A Barcode in Microsoft Excel?
How to Create A Barcode in Microsoft Excel?

Step5: We right-Click the barcode and choose [Microsoft BarCode Control 16.0 Object] →[Properties]→[7-Code-128 ]

How to Create A Barcode in Microsoft Excel?
How to Create A Barcode in Microsoft Excel?
How to Create A Barcode in Microsoft Excel?

Step6: Now we right-click the barcode again, and choose [Properties], and enter “a2” in the [LinkedCell]

How to Create A Barcode in Microsoft Excel?
How to Create A Barcode in Microsoft Excel?
How to Create A Barcode in Microsoft Excel?

Wow, You get the perfect barcode now. Isn’t this interesting? Quickly open an Excel and have a try!

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

Leave a Reply

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