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;
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!