My Hack to Create Hyperlinked Cells in Google Sheets iOS Using the Mail App

Hi, everyone!  This is Lara Hammock with the Marble Jar channel and in today's video, I'll show you how I quickly and easily create hyperlinked cells in the mobile version of Google Sheets using the iOS Mail app.

I'm aware that this is a niche issue, but I use this hack all the time, so I thought I'd share the trick I use.  Here's the thing.  It's super easy to create a hyperlinked cell in Google Sheets from a computer.  While on the cell you want to link, just hit Command + K on a Mac and Control + K on a PC, paste in the URL and hit apply and you've got a nice hyperlinked cell that brings up a link to the website when you click on or hover over the cell.

The problem is that it's more involved for the mobile version of Google Sheets.  In fact, it really requires you to write a somewhat complicated formula that involves too much cutting and pasting and quote marks for my taste. 

SO, here's my trick.  Before I show you this, you should know that sometimes you can luck out and paste a hyperlinked piece of text directly into Google Sheets with the link formatting intact. In other words, I can copy this linked text here and paste it directly into Google Sheets like this. So, even though there is some reformatting to do to get it to look like the rest of the text, you can hover over the cell and the link is there!

However, there are times when this doesn’t work.  In these occasions, I use this hack.
  • First, I copy the url of the website that i want to link google sheets too.
  • Then, I go to the iOS mail app, start a new email, and paste this url into the body of the mail message.  You can see that the mail app makes the url into a clickable link. 
  • Okay, now that I have this pasted in. I position my cursor somewhere in the URL and type in the text but I want to appear in the cell. In this case, “Lesson 3”.  This is going to look like a mess for a second.
  • Once I have done this, I simply copy this hyperlink text and paste it into Google Sheets.
  • And Voila!  You can see that the hyperlink is still there -- easy and quick hyperlinked text without having to deal with a complicated formula. 

Let me know what you think! Comments are always appreciated and thanks for watching.

Comments

Post a Comment

Popular posts from this blog

Pros and Cons of the Headway App

Image
Hi, everyone.  This is Lara Hammock from the Marble Jar channel and in today's video, I'll share my thoughts on the non-fiction book summary app -- Headway. I'm read a lot of non-fiction books and yet -- there will always books I never get to -- my eyes are always bigger than my stomach when it comes to reading.  And here is the thing -- some books are worth reading every single word of, but some books I can live with just an overall summary.  I would say probably most books fall into the latter category.  So, that's where non-fiction book summary apps come in.  They give you about a 15 minute summary of a book.  This can help you determine whether you want to read more or whether that bare bones synopsis was enough.  A while back, I had a subscription to Blinkist, but recently I was approached by Headway to take a look at their app, so I'm going to give you my thoughts.  First off,  I love the concept.  Take a 300 to 500 page book, boil...
Read more

Review of Toshl Personal Finance and Budgeting App

Image
Hi, everyone. This is Lara Hammock from the Marble Jar channel, and in today’s video I will review the Toshl personal finance and budget app.  This is part of a series where I give you my thoughts on a variety of budgeting apps. Toshl is a European app — it appears to be based in Slovenia.  It’s free version has limited the number of accounts and budget items that you can add. The pro version for two dollars a month has unlimited accounts and budget items, but does not include linked banking accounts. For five dollars per month, you can upgrade to the Medici level which allows for linked financial accounts. Toshl is available for iOS, android, and has a Web app. It syncs across all of the platforms by pulling data from the cloud. Linking accounts was quite easy. It even asked whether I wanted to import past transactions or for importing to start today. After having reviewed a number of these apps, I’m always interested in how the developers have chosen to set up the screens. T...
Read more

The Subtle Differences Between Sweet, Nice, & Kind

Hi, everyone!  This is Lara Hammock from the Marble Jar channel and in today's video, I'll talk about the distinction that I often make about three words: Sweet, Nice, and Kind.  And why it's important to know the difference. Here are three words that are often used interchangeably: sweet, nice, and kind.  But I think there are important distinctions between them that can help to decide how we want to be in the world.  In my family -- based on the distinctions I will discuss in a bit -- my husband is sweet, nice, and kind; my daughter is sweet and kind, I'm only kind, and my son used to be none of the above, but is growing into himself as an adult who is both sweet and kind. So, let's go through them: Sweet - I think of sweet as more of a temperament.  It describes someone who is pleasant and easy to be around.  Generally this temperament is not dominant or pushy, but is gentle and lovable.  This disposition is shared by most of the early Disney princ...
Read more