Home  >  Article  >  Topics  >  How to batch generate QR codes in Excel

How to batch generate QR codes in Excel

藏色散人
藏色散人Original
2020-03-04 09:08:0312368browse

How to batch generate QR codes in Excel

How to generate QR codes in batches in excel

As shown below, column A contains some data, and now I want to It quickly generates QR codes.

How to batch generate QR codes in Excel

Recommended: "excel tutorial"

Select the data cell area in column A to create a QR code

How to batch generate QR codes in Excel

Click [Picture Tool] (Excel plug-in, Baidu can learn the detailed download and installation method, this article will not describe it in detail here)

How to batch generate QR codes in Excel

Click [Batch Generation] in the QR code menu

How to batch generate QR codes in Excel

Click the box behind [Save to area] (you can adjust the QR code pixels and other contents through settings, such as It is recommended to keep the default settings if there are no special requirements)

How to batch generate QR codes in Excel

Select the cell range B2:B7, and then click [OK]

How to batch generate QR codes in Excel

Finally click [OK] to complete

How to batch generate QR codes in Excel

The completed effect is as shown in the figure below

How to batch generate QR codes in Excel

The above is the detailed content of How to batch generate QR codes 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