Home  >  Article  >  Topics  >  How to generate QR code in excel

How to generate QR code in excel

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-05-11 10:25:3066859browse

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”.

How to generate QR code in excel

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;

How to generate QR code in excel

How to generate QR code in excel

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...

How to generate QR code in excel

How to generate QR code in excel

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;

How to generate QR code in excel

How to generate QR code in excel

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;

How to generate QR code in excel

How to generate QR code in excel

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

How to generate QR code in excel

How to generate QR code in excel

How to generate QR code in excel

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;

How to generate QR code in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn