How to use excel to generate QR code images How to generate QR code images in excel

Creating QR codes is a piece of cake. Nowadays, QR codes have been widely used in our daily lives, and it brings us a lot of convenience. If you want to easily generate QR codes, Excel will be your right assistant. PHP editor Zimo specially compiled detailed steps to show you the convenience of generating QR codes in Excel. Continue reading to easily master this practical skill and make QR codes add convenience to your work and life.

1. First, copy the link and title that need to generate the QR code to cell A2B2 in the table.

2. Click [Options] in the [File] tab.

3. Open the [excel options] dialog box, click Customize, select [Development Tools] and add it to the custom ribbon on the right.

4. Click the [Development Tools] tab, click [Insert] in the control function group, and select [Other Controls] in the lower right corner.

5. Open [Other Controls], select [Microsoft BarCode Control 16.0] and click OK.

6. At this time, our mouse turns into a thin cross, and drags the square at cell C2 to generate the barcode.

7. Select the newly inserted barcode, right-click and select [Properties] to open the [Properties] dialog box. Click the More button on the right side of the custom bar to open the [Property Page] dialog box, set the style to [11-QR Code], and then confirm.

8. Enter A2 (the cell where the article link address is located) in the Linkedcell column.

9. After completion, we will see a QR code appearing in cell C2. If you need to view this tutorial, just scan the code with your mobile phone.

10. Finally, you can hide column A, leaving only the tutorial name and QR code column.

The above is the detailed content of How to use excel to generate QR code images How to generate QR code images in excel. For more information, please follow other related articles on the PHP Chinese website!