I find Google Sheets to be an amazing tool for organizing projects – the endless rows and columns allow me to track and rank things as I please. (You should see my Byzantine spreadsheet for my family’s personal finances.)
Until recently, however, I ran into a major limitation that irritated my organizational brain. If I wanted to add hyperlinks to a cell, I could just link an entire cell instead of linking the individual words within it. This meant, for example, that if I wanted to keep track of interesting personal finance links in my spreadsheet, I would have to create individual cells to each of these hyperlinks, which could quickly fill a lot more cells than I̵
But earlier this summer, as I was looking for a great story, I must have subconsciously noticed that something had changed. I was finally able to connect all the things I wanted into a single cell, allowing myself to pack even more organization in my handmade spreadsheets. The feature was so good – and it felt so natural – that I immediately switched to using it as if it had always been there and didn’t think much more about it.
But today, another Verge the staff also noted the change with enthusiasm and shared it The Verge’s Slack as PSA. And then my publisher realized that he, like me, started using it without even thinking about it. It’s just that useful.
Sure, my colleagues and I may be a little late to the hyperlink party. I found a Google support thread discussing the new feature on May 7th and a YouTube tutorial posted the same day. But maybe the feature reached my colleagues and I a little later than in May, as Google sometimes rolls out features over time.
We thought we’d share our shared discovery of the feature with you, dear Verge reader, so you can start creating hyperlinks for all things.