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.
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]
Thank you for letting me knowOriginally Posted by janmorris
You can use Apps Script.
Test Sheet
Please Login or Register to view this content.
It sounds good. But when i click, nothing happens:
Attachment 776530
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
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
Happy to help. Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks