41
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&...
- 335
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, ...
- 12.6k
20
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://...
- 486
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();
...
- 335
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 ...
16
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 ...
- 176
14
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 ...
- 293
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 ...
- 1,844
8
votes
Accepted
How does one find the http://go.microsoft.com/fwlink/?LinkId=XXX for an MSDN page?
You can't. We use shortlinks like that internally and the recommendation applies to internal products only (e.g. a page changes the URL, we don't need to update the product and just update the ...
- 196
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": [
{
"...
- 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 ...
- 745
6
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 ...
- 12.6k
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 ...
- 51
4
votes
Accepted
Cannot link to an image from Blogger to Google Drive
That is the link to the Google Drive image viewer, rather than a link to the image itself. If you check the URL for the image when you visit that link, you get an URL like:
blob:https%3A//drive....
- 52.3k
4
votes
Extract the link text and URL from a hyperlinked cell
Short answer
Use a custom function.
NOTE
Nowadays Google Sheets have two ways to have links in a cell:
by using the HYPERLINK function and
by using rich text feature for cell content formatting.
...
- 44.6k
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.
- 41
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 ...
- 41
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 ...
- 5,530
3
votes
Automatic rewriting of dead links on Wikipedia
The simplest way to solve this would be to use AutoWikiBrowser, a semi-automated MediaWiki editor. Guidelines and instructions are available (but may vary depending on which language version of ...
- 376
3
votes
Accepted
Space does not get blue underline when linkified in Google documents
The issue has been fixed.
Example:
- 17.3k
3
votes
Is there a direct link to the latest revision in JSFiddle?
Adding /latest/ to the end of the URL seems to work.
- 39
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 ...
- 163
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 ...
- 31
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:
- 44.6k
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.
- 3,884
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/...
- 385
3
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 ...
- 353
Only top scored, non community-wiki answers of a minimum length are eligible