👍

I wonder how does this feature help you. Could you give some examples?

@Allen Lee I didn't know I could link directly to a spreadsheet tab. That's very helpful with my organization. I run my entire business through Google Docs and Google Sheets. Which means I have a lot of them. I have one master spreadsheet with links to all my other sheets. Think of it like having a homepage so I can navigate easily and quickly to the sheets I need. The issue I was having was whenever I would open the link, it would take me to whatever's have I was on last in that sheet. Sometimes, the tab it opens 2 is all the way to the right, which is just a mild inconvenience. Add that up with other mild inconveniences, and it becomes a big hassle. And sometimes I need to share sheet with a client but they only need to see a specific tab. This saves the trouble of having to instruct them to find the tab that pertains to them. And in general, this KZfaqr creates fantastic, easy-to-follow tutorials. So I just wanted to give him a nice compliment on top of saying how useful this one was to me.

@@richardthemagician8991 thanks for sharing!

@@richardthemagician8991 Inspired by your idea, I am adding a "Menu" tab as my first tab in my frequently used Google Sheets. Here I build a navigation menu with tab names (or descriptions), and then insert links for those names. This way I can navigate my 40 some tabs in the spreadsheet much easier.

@richardthemagician8991 Thank you!

👍

👍

Hard to say without seeing an actual example/

@@ExcelGoogleSheets Teacher... what is the Best Way to do that?

👍

No way other then maybe using scripts instead of formulas.

👍

Add underscore after function name and that's it. function tryme_(){ return null }

@@ExcelGoogleSheets Thank you!

for example in a1 you can add link moving you to the first not empty row (dynamically) in column a, row a1 is locked since it usually has titles of columns very handy if you have a big sheet

I'm curious. What do you mean by link files together? I believe you can already do exactly what you described with Google Sheets. I combine data from multiple sheets all the time to create complex record-keeping.

you can use function importrange

Google's alternatives are Google Looker Studio and Big Query. Google Looker Studio is Power Pivot, Big Query is Power Query.

@@richardthemagician8991 Link data completely differ than importing sheets or ranges.

@@LotfyKozman I guess I'm fuzzy on the lingo. What does "link data" mean?

What would be the Google Sheets equivalent of this Excel formula: =IF(J2=0,"",HYPERLINK("#SPCodes!A"&MATCH(J2,SPCodes!$A:$A,0),J2))? I can't make it work in Sheets.

Disregard. Figured it out.

I don't think that going to change much until they figure out a way to monetize those Android users.

kzfaq.info/get/bejne/odpoobir3rHOXXU.html kzfaq.info/get/bejne/obieodef3rrLdok.html

The only way to print with script is to use some third party API that allows to print on your printer. You won't be able to replicate clicking on the print button.

@@ExcelGoogleSheets okay Can you please upload a video for us in the way of your smart ideas that explains the process of using the script editor in printing, with the addition of some useful ideas that always fascinate us with them, thank you

Hello I apologize for the inconvenience, but I hope you can help me with what you mentioned about printing via the API Because as you know, the person with experience surrounds you with many benefits when designing something unlike the novice Thank you for your kind review of this article

Yes. Copy the link the same way I did by the end of this video and use that as a link in your other sheet.

@@ExcelGoogleSheets thanks.

@@ExcelGoogleSheets Also, I found that I can't insert a cell with a number in it, only date value or text value can be inserted with a link. How do I get around that? I am trying to do it so when I click the cell with number, it tasks me to the where the number comes from.

Use HYPERLINK function. Although technically it will still be text.

But the cell already have a numeric value in it. I can’t replace it with a hyperlink formula. For example I have a value of 0.08 in the cell. I want to be able to click it and jump to the external sheet’s tab, from where I got the value @@ExcelGoogleSheets