Home

About Us

IT Services

Understanding IT

News & Events

Blog

Support

Contact Us

Blog
  • Register

Texas Professional IT Services LLC Blog

Texas Professional IT Services LLC has been serving the Baytown area since 1995, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: How to Use Excel to Create QR Codes

Tip of the Week: How to Use Excel to Create QR Codes

QR codes are a popular way to direct individuals to specific web pages, like your business’ website. You can make them with relative ease, so there’s no excuse not to use them. Today, we’ll go over how you can make them in Microsoft Excel, a tool your business already probably uses to some extent.

Start By Building a Table

Your first step is to build a table in Excel. Use the Insert menu to find the option for Table. Make one with two columns, then rename Column1 as Text and Column2 as QR Code.

Your end result should look like this:

Populate Your Table with Links

Under the Text column, place your links; these are the destinations for your QR codes.

Add a Formula

Once you’re ready, select the top empty space in the QR Code column. You’ll then paste the following into the formula tab:

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

Look, You Have a QR Code!

In the column, you should see QR codes for each of the links in the appropriate cell. We’ve edited our screenshot to show you a bit more clearly what’s going on, but all codes will direct to the corresponding link. You can copy them from this spreadsheet and use them anywhere you’d like.

Pretty Simple, Right?

If you found this blog helpful, consider giving us a call at (832) 514-6260 to see how we can help your business make better use of the tools it already has at its disposal.

How Backup Has Gotten Better and Better in Recent ...
How to Share Your Screen in Meet, Teams, and Zoom
 

Comments

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

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Latest News & Events

Texas Professional IT Services LLC is proud to announce the launch of our new website at http://www.texproit.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 ser...

Contact Us

Learn more about what Texas Professional IT Services LLC can do for your business.

Call Us Today
Call us today
(832) 514-6260

1209 Decker Dr.
STE 202

Baytown, Texas 77520