126 Monroe Turnpike, Trumbull, Connecticut 06611 sales@netsynergy.com

Blog

Network Synergy Blog

Network Synergy has been serving the Trumbull area since 1988, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: How to Create QR Codes in Microsoft Excel

Tip of the Week: How to Create QR Codes in Microsoft Excel

QR codes are a handy way to direct someone to the right place online, like your business’ website, but did you know that they are also pretty easy to make? Let’s go over how you can whip up your own with the help of Microsoft Excel.

First, You Need to Build a Table

In Excel, you’ll want to create a table. Under the Insert menu, select Table and make one with two columns. Rename Column1 as Text and Column2 as QR Code.

The result should look like this:

Next, You Populate It With Your Links

In the Text column, paste the links for which you want to generate a QR code.

Then, You Add the Formula

Then, selecting the top empty space in the QR Code column, paste in the following formula: 

=IMAGE("https://api.qrserver.com/v1/create-qr-code/?size=150x150&data="&[@Text]&"")

Finally, You Have Your QR Code

This will generate a QR code for each link in the corresponding cell. While we have edited the screenshot somewhat to show you the result more clearly, all of these codes will direct to the associated link, and can be copied and used elsewhere.

It’s Really That Simple!

Stick around for more handy tips and discussions about numerous IT topics and happenings. To learn more about what we can do to assist your business with its IT directly, contact us at (203) 261-2201.

3 Applications of Modern IT and How Today’s Busine...
Building a Plan for Business Mobility
 

Comments

No comments made yet. Be the first to submit a comment
Guest
Already Registered? Login Here
Guest
Sunday, 16 March 2025

Captcha Image

Contact us

Learn more about what Network Synergy can do for your business.

Network Synergy
126 Monroe Turnpike
Trumbull, Connecticut 06611

Network Synergy Corporation BBB Business Review

Best IT Managed Service Providers in Bridgeport aicpa logo net syn

News & Updates

Network Synergy is proud to announce the launch of our new website at www.netsynergy.com. The goal of the new website is to make it easier for our existing clients to submit and manage support requests, and provide more information about our services for ...

Copyright 2025 Network Synergy. All Rights Reserved.