Method: First click "Development Tools" - "Insert" - "Other Controls"; then select "Microsoft Barcode", hold down the left mouse button and drag in the cell; then right-click the barcode and select "Properties" ”, click the customized three-dot icon and change it to “11-QR”; finally enter “A1” in “linked”.
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
First open the Excel office software, then create a new blank workbook, and then click "Development Tools" - "Insert" in the cell toolbar, as shown below;
Click the triangle drop-down button below Insert, and then select the "Other Controls" option at the end, and then the dialog box shown in Figure 2 will pop up...
In this dialog box, we select the "Microsoft Barcode Control 15.0" item, then hold down the left mouse button and click anywhere in the cell. Drag the position to create a barcode as shown below;
But we don’t need a barcode, we need to convert it to 2D next code, select the barcode, then right-click "Properties", and then a new dialog box as shown in Figure 2 will pop up;
## in In this dialog box, click the three-dot icon behind Customize, change the style to "11 -QR code", and then click OK to close the dialog box; Finally, still in this dialog box, we enter A1 after linkedCell, and then we will find that the barcode we made before is converted into the QR code image in the picture below. Yes, you can open it by scanning the QR code;The above is the detailed content of How to generate QR code in excel. For more information, please follow other related articles on the PHP Chinese website!