(415) 246-0101
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.
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:
Under the Text column, place your links; these are the destinations for your QR codes.
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]&"")
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.
If you found this blog helpful, consider giving us a call at (415) 246-0101 to see how we can help your business make better use of the tools it already has at its disposal.
About the author
When he is not helping businesses with their IT needs, Daniel is in the computer lab. Testing new tech solutions that can be added to the tool belt. If you ever have any tech or business question, Daniel is ready to help you find the answer.
Mobile? Grab this Article!
Tag Cloud
Comments