+ Reply to Thread
Results 1 to 10 of 10

Googlesheets - Clickable shortcut to line

  1. #1
    Registered User
    Join Date
    04-22-2015
    Location
    Iceland
    MS-Off Ver
    2019
    Posts
    33

    Googlesheets - Clickable shortcut to line

    Hi,

    I want to make several shortcuts all on line 2 to several points across the sheet

    I want to click on "100" (A2) and after the click the sheet will display line 100

    I want to click on "200" (B2) and after the click the sheet will display line 200

    ...



    I tried this way:

    eU5h6Kp.png





    But with this solution i have to click also after on this box:


    https://i.imgur.com/rPNpayR.png




    Anyone knows one direct way?



    https://docs.google.com/spreadsheets...it?usp=sharing
    Last edited by Web-Man; 04-12-2022 at 10:38 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    797

    Re: Googlesheets - Clickable shortcut to line

    if by "shortcut" you mean a "hyperlink", the way Google Sheets works is that you must click the link in the window that pops, there is no way to make a link that when you click it jumps directly without the popup window.

    as a side note, please do not post images on other sites for users to click, many forum members will refuse to click that type of link... the forum has feature for you to add an image directly in your post so you should use it.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Registered User
    Join Date
    04-22-2015
    Location
    Iceland
    MS-Off Ver
    2019
    Posts
    33

    Re: Googlesheets - Clickable shortcut to line

    Quote Originally Posted by janmorris View Post
    if by "shortcut" you mean a "hyperlink", the way Google Sheets works is that you must click the link in the window that pops, there is no way to make a link that when you click it jumps directly without the popup window.

    as a side note, please do not post images on other sites for users to click, many forum members will refuse to click that type of link... the forum has feature for you to add an image directly in your post so you should use it.
    Thank you for letting me know

  4. #4
    Valued Forum Contributor unit285's Avatar
    Join Date
    10-29-2015
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    349

    Re: Googlesheets - Clickable shortcut to line

    You can use Apps Script.

    Please Login or Register  to view this content.
    Test Sheet

  5. #5
    Registered User
    Join Date
    04-22-2015
    Location
    Iceland
    MS-Off Ver
    2019
    Posts
    33

    Re: Googlesheets - Clickable shortcut to line

    Quote Originally Posted by unit285 View Post
    You can use Apps Script.

    Please Login or Register  to view this content.
    Test Sheet
    It sounds good. But when i click, nothing happens:

    Attachment 776530

  6. #6
    Valued Forum Contributor unit285's Avatar
    Join Date
    10-29-2015
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    349

    Re: Googlesheets - Clickable shortcut to line

    You will need to trust the project before the link will work.. the arrow shape is the button.

  7. #7
    Registered User
    Join Date
    04-22-2015
    Location
    Iceland
    MS-Off Ver
    2019
    Posts
    33

    Re: Googlesheets - Clickable shortcut to line

    Quote Originally Posted by unit285 View Post
    You will need to trust the project before the link will work.. the arrow shape is the button.
    Oh, in that case i requested permission

    Attachment 776531

  8. #8
    Valued Forum Contributor unit285's Avatar
    Join Date
    10-29-2015
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    349

    Re: Googlesheets - Clickable shortcut to line

    Shared the sheet. When you first run the script it will make you go thru the steps of trusting it because it's unverified.. you can see the script in the editor if you go to Extensions then Apps Script

  9. #9
    Registered User
    Join Date
    04-22-2015
    Location
    Iceland
    MS-Off Ver
    2019
    Posts
    33

    Re: Googlesheets - Clickable shortcut to line

    Quote Originally Posted by unit285 View Post
    Shared the sheet. When you first run the script it will make you go thru the steps of trusting it because it's unverified.. you can see the script in the editor if you go to Extensions then Apps Script
    Perfect, thank you so mutch

  10. #10
    Valued Forum Contributor unit285's Avatar
    Join Date
    10-29-2015
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    349

    Re: Googlesheets - Clickable shortcut to line

    Happy to help. Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. GoogleSheets: Stock average price
    By Antrr3 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 12
    Last Post: 04-20-2021, 02:11 AM
  2. [SOLVED] Summary of names on Excel and GoogleSheets.
    By sirdon in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 05-19-2020, 09:24 PM
  3. Connecting two googlesheets like workbooks
    By ImranBhatti in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 02-01-2020, 12:21 PM
  4. [MOVED] Connecting two googlesheets like workbooks
    By ImranBhatti in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-01-2020, 11:45 AM
  5. Drop down box not clickable or right clickable
    By jceg316 in forum Excel General
    Replies: 3
    Last Post: 01-09-2015, 09:23 AM
  6. Replies: 1
    Last Post: 08-02-2014, 06:14 PM
  7. shortcut with command line switch probs
    By solotoo in forum Excel General
    Replies: 1
    Last Post: 11-11-2005, 11:50 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1