Detailed Tutorial on How to Make Barcode by Excel (How to Make Barcode by Excel)

How to make barcode in Excel
Step 1: Add a development tool tab
Click File>Options>User defined Ribbon; Check Development Tool in the main tab.
How does Excel make barcodes (how does Excel make barcodes)
Step 2: Call out the Microsoft BarCode control
Click the Development Tool tab, Insert - Other Controls
Click Microsoft BarCode Control in the Other Controls dialog box, and click OK.
How does Excel make barcodes (how does Excel make barcodes)
At this time, the mouse changes to a "+" shape. Drag the mouse to draw a B2 cell size rectangle according to actual needs. Release the mouse to automatically generate a barcode.
How does Excel make barcodes (how does Excel make barcodes)
Step 3: Set the barcode
Right click the barcode, select Microsoft BarCode Control 15.0 Object from the pop-up shortcut menu, and click Properties.
How does Excel make barcodes (how does Excel make barcodes)
Select a style in the pop-up attribute dialog box, such as 7-code-128.
How does Excel make barcodes (how does Excel make barcodes)
Right click the barcode, select Attribute, and enter A2 in the Linkecell column of the pop-up Attribute dialog box.
How does Excel make barcodes (how does Excel make barcodes)