Excel Video: How to Create a QR Code in Excel (Free and Simple)
In this video tutorial, we’ll be having a look at how to create a QR code in Excel in a free and simple way.
What is QR Code?
It is a machine-readable code consisting of an array of black and white squares, typically used for storing URLs or other information for reading by the camera on a smartphone.
If you’d like to create QR codes in Excel, first you’ll need to install a handy add-in which will enable you to do so.
And this is easier than you might think.
Click on the Insert tab, find the group ‘Add-ins’ and click on the option ‘Get Add-ins’.
You’ll see a library of features where you can use the option ‘Search’ to look for the ‘QR4Office’ add-in.
Now just confirm your choice by clicking on ‘Add’, and you’re all set!
On the right-hand side of the screen, QR4Office will open a pane which you can use to create your own QR codes.
How to Create a QR Code
Up here you can choose whether you want to create a QR code from a URL address, email or telephone or you can select any other item on the list. We’re gonna use the URL address, so we’ll go for the option ‘https://’ and we’ll type in ‘www.leadleapconsult.com’.
Now you can pick a colour for the generated QR code here or the background colour here. But for now, we’ll keep the colours as they are.
This slider here helps you set the right size of the QR code you need. The current size is displayed in pixels above the QR code.
Once everything’s been set, just click on the button ‘Insert’ down here and that’s it! Here’s your QR code all ready to be moved where you need it.
Is the video helpful?
Drop your comment
Do you want to learn Data Analytics using Excel, Power BI and SQL?
Kindly join our October Cohort. It is 5 weeks program (Weekend classes)
Call us on 08062468296 to register
Choose Lead-Leap Data Analytics School
Watch video HOW TO GENERATE QR CODE IN EXCEL online without registration, duration hours minute second in high quality. This video was added by user Akerele Oluwasogo (Mr Excel) 01 January 1970, don't forget to share it with your friends and acquaintances, it has been viewed on our site 132 once and liked it 4 people.