ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature)

Find out all the different ways you can add hyperlinks to your Excel files. This improves workbook navigation and makes your Excel reports more user friendly.

We cover:
- How to Add an Excel hyperlink to a web page, another sheet, another folder or another cell
- How to create and email with hyperlink
- How to add a friendly hyperlink name and add a screen tip
- Add a hyperlink to a shape or an icon (create a button for your hyperlink)
- How to remove a hyperlink
- How to add multiple hyperlinks to different worksheets in one go
- How to change the color of the hyperlink or visited links
- Create dynamic hyperlinks with the HYPERLINK Function
- Use VLOOKUP to return a hyperlink (get a clickable link as a result of a lookup formula)

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel

[zhandostursynov]

Leila, I have been learning Excel from your channel for 2 years, and I must say that you are the best in teaching it! It is just a respect message from Kazakhstan! Wish you good luck and happiness in life, you contribute to world a lot!

[ExcelForFreelancers]

Always amazing. Thanks for sharing. You are a true leader Leila.

[lisainnewarknj]

There is a reason you are so popular. You make difficult a walk in the park. All the best, Lisa.

[thairtalib]

I wonder, who is better than you ?
You always present it as perfect .
Thanks, Leila 🌷 .

[willm]

And this guys is the reason why I keep buying her courses . Awesome stuff Leila 🙌🏿

[robertrumfelt]

I could not find out how to change the default font for hyperlinks until this video (4:53). Thank you, Leila!!!

[robertrumfelt]

Wait, you did it again!

I needed an INDEX and MATCH result to display a hyperlink found on a different worksheet. Without the proper syntax, the hyperlink is not carried over. As you explain at 7:07, by adding "=HYPERLINK(...." to the syntax, it now works. Your are amazing in that you not only know Excel inside and out, you explain things so succinctly. 5 stars from me!!!

[shironmania]

This time a roller coaster on hyperlink....truly awesome for those even to those aware of hyperlinks utilities

[bluegear]

literally jumping with joy. this is going to help and save me so much time.

[sarfarajkureshi]

Mam you are excel Queen, what a surprise you give in every video, it's very interesting and valuable. Love you...

[DrMeowWoof]

Thank you for the video I had spent 20 odd minutes trying to understand excels help. Your video showed it in a minute

[Deedington]

Every video is full of punch and well delivered!! Great work Leila!!

[gintomino]

Best in youtube. Her pleasant tone and pacing are on point and made it enjoyable while learning.

[wayneedmondson]

Hi Leila.. great tips on using hyperlinks, the hyperlink formula, drop-down hyperlinks, the back button trick.. super stuff! Thanks for sharing your know how and creativity. Thumbs up!

[Scott]

So I have hosted training classes at work for co-workers to learn Excel. I think I did alright, though I am not very inexperienced with teaching and I have resorted to developing interactive workbooks to help them develop themselves when they have the opportunity/free time, . In one of my documents, I have links to several sites that provide examples & explanations for every type of formula, but I feel that your videos are far more effective at explaining how each function works. So I will be including links to your videos in my files. I just want to say thank you, because even as my employer sees me as a pro with Excel, you have proven that I still have so much more to learn. Keep up the great work and I will do what I can to support/promote your channel.

[TheVission-ovqk]

Thanks leila i want to learn from u more regarding this hyperlinks

[tuyoexcelypowerbi]

Thanks for taking your time to prepare the videos.

[kamelgameel]

Leila, Although I knew that I have good experience with links your videos are still adding a lot to my Excel knowledge
Congratulations for this video, your presentation style still the best I've ever seen
Waiting for the next video :)

[brendanl]

Regarding the instructions on how to add a hyperlink to a single cell. What if the rows/columns are constantly being added to and you don’t want to continuously update the hyperlink?

[vafkeshav]

Hi Leila, your teachings are very crystal clear and very detailed. It's helping me a lot in learning. Good job. Keep it up.