How to create a QR Code for selective data in MS Excel

[@mathtoma7885]

Thank you so much - It's really helpful.

[@SMJTech2020]

I'm glad it was helpful for you

[@nuramohamed6005]

Thank you.. You helped me a lot

[@SMJTech2020]

You are welcome!

[@tristramemerge]

Thank you for this. Do you know what add ins also cater both image and text in QR?

[@SMJTech2020]

Hi Thank you for your comment. There are quite a few add ins for text however, to incorporate image, you'll need to use an online tool as Excel doesn't embed the image inside of its cell therefore, it is not possible to pick it up. However, if you have used IMAGE function within Excel to have the logo inside of the cell, then you can use that selection to generate QR code.

[@tristramemerge]

@@SMJTech2020 i see thank you for the knowledge, planning to have my own personal ID for my students. The plan is scanning there ID and at the same time they can watch the preview to a monitor after scanning to verify attendance. I think this needs a software. 😅

[@SudarshanKarki-n4g]

When I scan your QR code, data appear on the google search bar. Is there a better way of presenting of the data?

[@SMJTech2020]

Thanks for your comment! When using the Google API to generate a QR code, the data is designed to be presented in the search bar by default. For a better user experience, you can modify the data in the QR code to link directly to a webpage, a Google Form, or a file (like a PDF), rather than displaying raw data. This can be done by adjusting the URL or content embedded in the QR code during generation.

[@Kraftkorection]

Hello, what version of MS the you use, mine doesn't have the same interface as yours. Thanks

[@SMJTech2020]

Hi, I'm using MS 365

[@GenanDana]

I want to create a barcode with info shown like company logo product info. Could you help me

[@SMJTech2020]

There's a barcode font which can be used however I'll have to check if there's a possibility of of including logos or any images since they are not usually embedded within a cell in Excel.

[@raogaming3313]

If changes made in cell them can qr code generate automatically

[@SMJTech2020]

Yes

[@scanbocustomerdelightteami2914]

Please let me know how to attach the company logo with the QR code.

[@SMJTech2020]

Sure, I 'll try to cover in my upcoming video.

[@middleeasternmediterranean4477]

What if I have 100 employees? Shall I do it one by one? Can I do it as dragging?? Thanks

[@SMJTech2020]

Hi , you certainly can. I created another video which covers this using another function which allows the QR code to be embedded within the cell. Here is the link which will prove helpful: kzbin.info/www/bejne/imK6gJeFhdl9kK8

[@NoorFatima-lz2zk]

Nice

[@SMJTech2020]

Thanks