Learn how to create links in Google Sheets. We'll use the conventional way & HYPERLINK function methods. #googlesheets #tutorial
Пікірлер: 76
@eshaborana77467 күн бұрын
It was super easy and very helpful thank you
@user-qk1br3me7e19 күн бұрын
Thanks, it was very helpful!
@jayasri-ft8040 Жыл бұрын
You are always rock around the developers and trainers
@ExcelGoogleSheets Жыл бұрын
👍
@richardthemagician8991 Жыл бұрын
Always solid gold. I did not know I could link to specific tabs. That will save a lot of time.
@Allen-L-Canada Жыл бұрын
I wonder how does this feature help you. Could you give some examples?
@richardthemagician8991 Жыл бұрын
@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.
@Allen-L-Canada Жыл бұрын
@@richardthemagician8991 thanks for sharing!
@Allen-L-Canada Жыл бұрын
@@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.
@ExcelGoogleSheets Жыл бұрын
@richardthemagician8991 Thank you!
@drama_on_fire6 ай бұрын
This video was very helpful. Thank you sir
@aparamio12 Жыл бұрын
I love all your tutorials, thank you so much. You teach wonderfully. The "problem" that I have found with the hyperlink function is that if I use the Query function to filter data in another sheet, the links stop working. Only the label text appears, as plain text.
@TomWien Жыл бұрын
Awesome 👍
@ExcelGoogleSheets Жыл бұрын
👍
@siddharthjain6629 Жыл бұрын
You are doing a great job sirji
@AlexM-ym7kd Жыл бұрын
You have such great a way to teach that it is so easy to understand. Thanks! I was wondering, could you make a video on Materialize CSS? You went into it in your 14-part series on web apps about 4 years ago and it was great. Thank you!!
@SilvioBritoCarlos Жыл бұрын
Muito bom seus vídeos obrigado por se esforçar gastar o seu tempo para trazer conhecimentos sou do Brasil e gosto
@ExcelGoogleSheets Жыл бұрын
👍
@Electric-Bob Жыл бұрын
Teacher...as always, Good Information - Very Well Presented! As a Side Note... the Simple Formula I started out designing has turned into a Monster and will not work as presented in your Invoice Tutorial!?!?
@ExcelGoogleSheets Жыл бұрын
Hard to say without seeing an actual example/
@Electric-Bob Жыл бұрын
@@ExcelGoogleSheets Teacher... what is the Best Way to do that?
@joaopedrobohrer6241 Жыл бұрын
É o melhor canal entre todos para aprender sobre Google Sheets.
@gelanikl8825 Жыл бұрын
Hello First, thank you for your ideas, which have benefited me a lot
@ExcelGoogleSheets Жыл бұрын
👍
@demodrift8605 Жыл бұрын
Thanks a lot for all the knowledge over this time. Ps: Could you teach us how to clear a cell when filling another one? E.g., if you fill the cell "A1", then "B3" will be erased and vice-versa.
@bhadawang10 ай бұрын
Thank You, I'll subscribe
@luminehomeschoolersofpitts996127 күн бұрын
Thanks for your helpful videos! I've watched several but still having trouble finding a solution to what I'm looking for, so, I'm wondering if you can answer a question for me. I'm trying to link Spreadsheets and import cells that have hyperlinks. I can't get the hyperlinks to transfer, only the text shows up. Is there a way around this? What am I missing?
@ExcelGoogleSheets27 күн бұрын
No way other then maybe using scripts instead of formulas.
@4funrc11 Жыл бұрын
Wonderful! 👍 How do I import/link Spot Prices for metals, Sliver, Gold, etc.? Tia!😊
@melaniethebroker4 ай бұрын
This was a great video but the only thing it didn't show is how do you point to different parts of the sheet not just a range. I couldn't find the command
@AlyssaSilva-xq8yoАй бұрын
4:44 Hyperlink Formula (Table) 6:00
@chandrasekhardabbiru9087 Жыл бұрын
Excellent Lecture!
@ExcelGoogleSheets Жыл бұрын
👍
@damian4601 Жыл бұрын
video idea: new google sheets functions in 2023 ToRow, ToCol, ChooseRows, ChooseCols, WrapRows, WrapCols, VStack, HStack, MarginOfError, EpochToDate, Let. (I know some of them like Let is already covered in your previous videos)
@TheTramos00 Жыл бұрын
Please when are you going to continue showing us more examples of LET() LAMBDA() REDUCE() MAP() etc. working all together. Thanks!
@CorkyBallasdancewithme4 ай бұрын
is there a way to highlite 10 links and automatically import them into a google sheet, thanks for the video : )
@ali5t4ir8 ай бұрын
You are a GENIUS Thank You!
@mbrenne7210 ай бұрын
Thank you for this great video. In your first example where you created an external link, is there a way to then have that link appear in a separate field? At the 1:00 mark, you create the field that says "Click Here" and it has a link but that link isn't visible. I want to be able to show the link in G2 without having to retype the entire link. Possible?
@yehudagoldberg8577 Жыл бұрын
Thanks for all the helpul tutorials! I vaugly remember you showing how to define a function in a way so that it doesn't show up as an option on the trigger menu. (this function was only to be used by other functions). Can you remind me how that's done? I know this question is unrelated to this video but I'm not sure where else I can ask it. Thanks again!
@ExcelGoogleSheets Жыл бұрын
Add underscore after function name and that's it. function tryme_(){ return null }
@yehudagoldberg8577 Жыл бұрын
@@ExcelGoogleSheets Thank you!
@ajadsingh1652 Жыл бұрын
I have questions for you about google app script at the same different people using I want live update like google sheet. Is it possible ?.
@Endarire Жыл бұрын
How to change the default link color for all links in a Google Sheet? I've tried other guides but they didn't work for me. I ask since I've manually colored many links in a file and I'd rather not anymore. Thankee!
@Allen-L-Canada Жыл бұрын
What would be some practical usages of internal links?
@Heliuage Жыл бұрын
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
@LotfyKozman Жыл бұрын
It would be great if Google Sheets could offer a way to link files together, just like Power Pivot does. With this feature, users would be able to easily combine data from multiple sheets, making it easier to build complex reports and gain insights from their data.
@richardthemagician8991 Жыл бұрын
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.
@Heliuage Жыл бұрын
you can use function importrange
@ExcelGoogleSheets Жыл бұрын
Google's alternatives are Google Looker Studio and Big Query. Google Looker Studio is Power Pivot, Big Query is Power Query.
@LotfyKozman Жыл бұрын
@@richardthemagician8991 Link data completely differ than importing sheets or ranges.
@richardthemagician8991 Жыл бұрын
@@LotfyKozman I guess I'm fuzzy on the lingo. What does "link data" mean?
@tongvang72411 ай бұрын
But what about when you sort them? How do you automate the links to update?
@markuswinter-cdps3008 Жыл бұрын
Thanks, as always, for your videos!! I'm having trouble creating a link on a cell that is the result of a formula. I want the result to be the link to a tab/cell. Is this not possible? Thanks.
@markuswinter-cdps3008 Жыл бұрын
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.
@markuswinter-cdps3008 Жыл бұрын
Disregard. Figured it out.
@tridsonline Жыл бұрын
👍🏻 Great video, but very frustrating to see how much is missing from Google Sheets for Android!
@ExcelGoogleSheets Жыл бұрын
I don't think that going to change much until they figure out a way to monetize those Android users.
@designkatta Жыл бұрын
Hi 👋 I have master sheet with first name and last name data... I want to create another sheet and i wish when I put last name it's automatically get full name. Please guide what I do.....
Secondly, I hope you can help me in print a page in the Google Sheet using script edittor and thank you
@ExcelGoogleSheets Жыл бұрын
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.
@gelanikl8825 Жыл бұрын
@@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
@gelanikl8825 Жыл бұрын
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
@Allen-L-Canada Жыл бұрын
Could I make a link to point to a certain Tab of another Google Sheet?
@ExcelGoogleSheets Жыл бұрын
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.
@Allen-L-Canada Жыл бұрын
@@ExcelGoogleSheets thanks.
@Allen-L-Canada Жыл бұрын
@@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.
@ExcelGoogleSheets Жыл бұрын
Use HYPERLINK function. Although technically it will still be text.
@Allen-L-Canada Жыл бұрын
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