Hot answers tagged

3

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 of the screen), select "Link"; 4) Pick the desired link color and it is finished...


2

Your first formula worked for me. Perhaps there's something off about the way you've formatted one of the URL's?


2

A method without painful clicking is the following: Open the desired Google Drive folder and get the [ID] in its URL from the browser location bar: https://drive.google.com/drive/u/0/folders/[ID] Open a new Google Sheet and navigate Tools > Script editor. In the new script, put (replace the [ID] in the code): function myFunction() { var ss=...


1

Actually, there is no need to add anything - you already have all you need. Sheet references are handled by GID (Google Sheets' ID of particular sheet). The first sheet is always #gid=0 and any additional sheet gets generated unique ID (like for example: #gid=2089923721) so all you need to do is to navigate to it by changing GID number to correspond with the ...


1

As You can see from the prefix it's JPEG file encoded by base64 binary-to-text encoding scheme. So, it's not a hyperlink but the whole file instead. Technically, You could use this in HTML, CSS, etc to save some extra requests and/or issues with offsite resource not being available anymore. Various browsers and scrapers used to use that just to download ...


1

you need to refer it as an active range like this: ="https://docs.google.com/spreadsheets/d/1J-lBYHVVGjX1e8e_ZpeiNJIywJxfSW9waliWbJ2ICmM/edit#gid=0&range="& ADDRESS(ROW(D1); COLUMN(D1); 4)


1

=HYPERLINK("https://mail.google.com/mail/u/0/"; IMAGE("https://i.stack.imgur.com/XJ2AY.png"; 3)) demo spreadsheet


1

To re-evaluate all the cells as links after you've converted them to text values, run "Find and Replace" and do something silly like "http" to "http". It actually updates the cells and re-evaluates them as URLs.


1

It looks like this feature wasn't around when this question was asked, but things have definitely changed :) source


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