Skip to main content
Share Your Experience: Take the 2024 Developer Survey
46 votes
Accepted

Link to a cell in a Google Sheets via URL?

Cells And Ranges Please try: https://docs.google.com/spreadsheets/d/13PuCx8zKUjXvofFYBGzoOYog7UHpvLzCgxMLF9INnr8/edit#gid=0&range=D10 Shorten version for the internal use in Spreadsheet: #gid=0&...
Max Makhrov's user avatar
26 votes

How to get direct link of images on Imgur?

Imgur does not provide a direct link to images any more. Still. You have a couple of alternatives: Alternative 1 Right-click on the image and choose Open Image in New Tab Once the image is opened, ...
marikamitsos's user avatar
  • 12.9k
21 votes

Get share link of multiple files in Google Drive to put in spreadsheet

With a very large number of files (50+), a method without painful clicking is the following: Open the desired Google Drive folder and get its ID in the URL from the browser location bar: https://...
Davide Fiocco's user avatar
19 votes
Accepted

How to find URL of the current sheet

Open menu Tools → Script Editor and paste this code: function getSheetUrl() { var SS = SpreadsheetApp.getActiveSpreadsheet(); var ss = SS.getActiveSheet(); var url = ''; url += SS.getUrl(); ...
Max Makhrov's user avatar
17 votes

Link to a cell in a Google Sheets via URL?

As another user answered, Google finally added a feature to Google Sheets (GS) spreadsheets to allow linking directly to cells. The feature is intended for linking to ranges of cells, but specifying ...
Mr. Lance E Sloan's user avatar
17 votes
Accepted

How to change the default link color in Google Slides?

I had a somewhat similar problem and found the following solution: 1) Open the Master Slide; 2) Select "Colors..." at the top of the Master Slide; 3) At the "Theme colors" dialog (right-hand side ...
Eduardo Batista's user avatar
16 votes
Accepted

Web archive links without header

from "Wikipedia Help:Using the Wayback Machine" : (Source) Specific archive copy Once the target web page has been archived, each of the specific dated archives can be individually ...
ashleedawg's user avatar
9 votes
Accepted

How can one link to a specific portion of an article?

You can create a link directly to that section of the page. It won't hide any page content but it will skip directly to the linked section. Copy section links from the Contents box located at the top ...
Tom Woodward's user avatar
  • 1,852
7 votes
Accepted

How do you add a link to slack bot button?

Try Slack's Link Buttons, which specifically open links in new browser tabs when clicked. { "text": "Test Link Buttons", "channel": "C061EG9SL", "attachments": [ { "...
Adil B's user avatar
  • 304
7 votes
Accepted

How do I add a hyperlink in a Slack channel description?

Slack doesn't give an ability to put formatted text in the channel topic. If you enter the link directly though, it'll be correctly hyperlinked. This can be confirmed from the API documentation page ...
Jai Pandya's user avatar
5 votes

How to link from one Google Document to another

Press Ctrl K in document A at the desired position and instead of typing or pasting in a URL into the dialog box that appears, run a search for document B, select it and click Apply. (Source: Link ...
Michael Hemp's user avatar
5 votes
Accepted

How can I easily link to a bunch of files in my Google Drive from a Google Sheet (in the same account/drive)?

2nd EDIT (following OP's request) "I need a solution that gets me all the way from having a list of filenames (what I have now) to having a list of links I can click on and get to the corresponding ...
marikamitsos's user avatar
  • 12.9k
4 votes

Adding email address to Linktree

It's not actually possible to do that, but there is a work around for that. You can use https://mailxto.com to generate a prefilled email with a shortened URL that can be shared anywhere.
user286983's user avatar
4 votes

How to get a direct link to a post on MeWe?

I'm quite sure you can't do this (I've tried multiple ways) and I think it's intentional -- so that MeWe doesn't have to take down copyrighted videos you might put up because it doesn't know where ...
Dave Dix's user avatar
4 votes

Click link to send a text message in Google Sheets

From the documentation for HYPERLINK: "Only certain link types are allowed. http://, https://, mailto:, aim:, ftp://, gopher://, telnet://, and news:// are permitted; others are explicitly ...
Tedinoz's user avatar
  • 5,721
4 votes

Click link to send a text message in Google Sheets

Tedinoz's answer points out which link types are allowed within HYPERLINK, which made me realize that I can use a permitted https:// link to a simple HTML page with some JavaScript that forwards to an ...
Vincent's user avatar
  • 373
4 votes

How can I prevent Slack from adding previews when I send links in a Slack message?

A simple workaround is to exclude https:// from the links you share. Source (Slack help article): Here are some reasons your link may not expand to show a preview: http:// was not included. Try ...
Shaya Ulman's user avatar
3 votes
Accepted

How to add a hyperlink in Hotmail (live.com)?

The button to insert an hyperlink is in the dropdown menu. Just Click on the V button:
Rubén - Volunteer Moderator -'s user avatar
3 votes

Extract the link text and URL from a hyperlinked cell

The scripts from the other answers do not work when the links are not stored as formulas, they are stored as RichTextValue. This is the a way to get a link from a cell not having a formula in Google ...
Ondra Žižka's user avatar
3 votes

Extract the link text and URL from a hyperlinked cell

Assuming the cell has the hyperlink funciton; Just find and replace =hyperlink to "hyperlink" or "xyz" Then you just have to do some data cleaning to separate them. Try using the split text to ...
Jeet Shah's user avatar
3 votes

Is there a direct link to the latest revision in JSFiddle?

Adding /latest/ to the end of the URL seems to work.
Blaise's user avatar
  • 39
3 votes
Accepted

Space does not get blue underline when linkified in Google documents

The issue has been fixed. Example:
Franck Dernoncourt's user avatar
3 votes

Web archive links without header

As commenter fzbd states, appending if_ (not id_) to the date string works best. http://web.archive.org/web/20200101000208/https://webapps.stackexchange.com/ Header shown http://web.archive.org/web/...
Jan Kyu Peblik's user avatar
3 votes

Add a Hyperlink to a Trello card

I ended up creating a small extension called GTD: Trello Card Links that allows you to put any link on the front of your Trello Cards and make it clickable. I always found it really annoying having to ...
Oneezy's user avatar
  • 163
3 votes

How to change the default link color in Google Slides?

Go to "slide" and then "edit theme". Here, you can choose the master slide at the top. On the right hand side is a theme menu. Select "link" and change the color there....
Amber's user avatar
  • 31
3 votes
Accepted

Can't email a link copied from Facebook

They shorten long URLs, you have nothing to do about that. To copy the link, just right click it and choose Copy link address - you can right click the textual link, or the preview.
arieljannai's user avatar
  • 3,924
3 votes

How do I apply arrayformula on a hyperlink so that I can reference another cell in a different sheet?

You need to wrap your formula with an Arrayformula and generate as many rows as column A in Sheet1 has a value in it: =ARRAYFORMULA(if(len(Sheet1!A2:A), HYPERLINK("https://docs.google.com/...
Marios's user avatar
  • 385
3 votes

How to find a permalink/share-link to an Instagram post?

Answering my own question, because Instagram hid it underneath the "dot-dot-dot" menu, making it non-obvious to users of normal web apps that put the share (a link) button up front and ...
bgoodr's user avatar
  • 1,958
2 votes

How can I make URLs automatically hyperlinked on a web-published Google Docs?

It seems that right now, in 2018, it's the default behavior. The link detection gets triggered when you enter a space or press enter after pasting or writing the URL. So, if you paste a URL that has ...
arieljannai's user avatar
  • 3,924
2 votes

Is there a way to link emails from Google Sheets?

You could use a collaborative inbox, which is a feature of Google Groups for Business that gives multiple persons access to a mailbox. When viewing a message in the collaborative inbox, you could ...
Vidar S. Ramdal's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible