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

Share this & earn $10
Leila Gharani
Published at : 10 Oct 2021
289230 views
4435
81

Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials

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 screentip
- 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)

⯆ Blog Post & Workbook are here: https://www.xelplus.com/excel-hyperlink/

LINK to VLOOKUP video: https://youtu.be/hwL6KKJP-_I
Excel Basics Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0


★ My Online Excel Courses ► https://courses.xelplus.com
Direct link to Excel VBA Course: https://courses.xelplus.com/p/excel-vba-excel-macros

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

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!

#MsExcel

XelplusVisExcel TutorialsLeila Gharani

satisfying Mud To Build Temple Villa #SHORT

satisfying Mud To Build Temple Villa #SHORT

Clement Attlee asks the public to help renew Britain (1946)

Clement Attlee asks the public to help renew Britain (1946)

How to Pronounce APPRECIATE & APPROPRIATE - American English Pronunciation Lesson

How to Pronounce APPRECIATE & APPROPRIATE - American English Pronunciation Lesson

The Road Gets Blocked: Entering France | Bicycle Touring Europe

The Road Gets Blocked: Entering France | Bicycle Touring Europe

Keeping Up With Gordon Ramsay!  | MasterChef Australia | MasterChef World

Keeping Up With Gordon Ramsay! | MasterChef Australia | MasterChef World

TRUTH (DUBSTEP) - JUNO (aquatic lab)

TRUTH (DUBSTEP) - JUNO (aquatic lab)

Tuero & Netsiah - Bear In Mind (Original Mix)

Tuero & Netsiah - Bear In Mind (Original Mix)

Rik & Ade's BEST BITS from Bottom - Series 1 | Bottom | BBC Comedy Greats

Rik & Ade's BEST BITS from Bottom - Series 1 | Bottom | BBC Comedy Greats

Justin Bieber - Company (Official Music Video)

Justin Bieber - Company (Official Music Video)

Should You Buy an AUDI A7? (Test Drive & Review MK1)

Should You Buy an AUDI A7? (Test Drive & Review MK1)

Tornado Infra Pro - Removing IC for reworking

Tornado Infra Pro - Removing IC for reworking

Helena Paparizou - My Number One (Greece) Live - Eurovision Song Contest 2005

Helena Paparizou - My Number One (Greece) Live - Eurovision Song Contest 2005

A Whimsical RollAcaster - James Acaster on Would I Lie to You?

A Whimsical RollAcaster - James Acaster on Would I Lie to You?

The Style Weekend (Remix)

The Style Weekend (Remix)

SUPER low price goods on 1688.com(More suitable for retailers to bulk purchase)

SUPER low price goods on 1688.com(More suitable for retailers to bulk purchase)

L.O.T.S. Loudspeaker Optimization Techniques for Soundstage!

L.O.T.S. Loudspeaker Optimization Techniques for Soundstage!

Selling Your Backyard Vegetables - Our Most Helpful Tips!

Selling Your Backyard Vegetables - Our Most Helpful Tips!

MKTO - Classic (Lyrics) Ooh girl you're shining like a 5th Avenue diamond (TikTok Song)

MKTO - Classic (Lyrics) Ooh girl you're shining like a 5th Avenue diamond (TikTok Song)

Η δύναμη των σαλιγκαριών στην ενυδάτωση και στην ομορφιά | Love it | 15/10/2021

Η δύναμη των σαλιγκαριών στην ενυδάτωση και στην ομορφιά | Love it | 15/10/2021

My Restoration Will Cause Them To Despise you but Stay In My Presence - Wisdom Wednesdays

My Restoration Will Cause Them To Despise you but Stay In My Presence - Wisdom Wednesdays

Roberto Cacciapaglia - Days of Experience (Official Music Video)

Roberto Cacciapaglia - Days of Experience (Official Music Video)

Nasa's Mars Perseverance Curiosity captured The first fish to appear on the surface is there life?

Nasa's Mars Perseverance Curiosity captured The first fish to appear on the surface is there life?

Thank You Healthcare Workers

Thank You Healthcare Workers

Basic concepts of web applications, how they work and the HTTP protocol

Basic concepts of web applications, how they work and the HTTP protocol

Living with Dementia:  Challenges for staff and caregivers

Living with Dementia: Challenges for staff and caregivers

SEO In 5 Minutes | What Is SEO And How Does It Work | SEO Explained | SEO Tutorial | Simplilearn

SEO In 5 Minutes | What Is SEO And How Does It Work | SEO Explained | SEO Tutorial | Simplilearn

Beyoncé – Be Alive (Original Song from the Motion Picture “King Richard”) (Official Lyric Video)

Beyoncé – Be Alive (Original Song from the Motion Picture “King Richard”) (Official Lyric Video)

Shaneil Muir - Exclusive Lyrics | Strictly Lyrics

Shaneil Muir - Exclusive Lyrics | Strictly Lyrics

The Best Meal Plan To Lose Fat Faster (EAT LIKE THIS!)

The Best Meal Plan To Lose Fat Faster (EAT LIKE THIS!)

Post Malone, Swae Lee - Sunflower (Spider-Man: Into the Spider-Verse)

Post Malone, Swae Lee - Sunflower (Spider-Man: Into the Spider-Verse)

Riot

Riot

Wooden

Wooden

Dayspring mainly music session | Week 3

Dayspring mainly music session | Week 3

How to Design Storage for Bathrooms

How to Design Storage for Bathrooms

100 MYSTERY BUTTONS || Only 1 Will Let you ESCAPE the Box! 100 Mystery Balloons by 123 GO! Food

100 MYSTERY BUTTONS || Only 1 Will Let you ESCAPE the Box! 100 Mystery Balloons by 123 GO! Food

How many meanings of "GO THROUGH"!?!? - Phrasal verbs with "Through"

How many meanings of "GO THROUGH"!?!? - Phrasal verbs with "Through"

Cryptocurrencies: how regulators lost control | FT Film

Cryptocurrencies: how regulators lost control | FT Film

Testing The Cheapest Outdoor WiFi PTZ IP Camera I Could Find - Besder Security Camera Review

Testing The Cheapest Outdoor WiFi PTZ IP Camera I Could Find - Besder Security Camera Review

Describe A Decision You Made With The Help Of Someone | September to January IELTS Cue Card Sample

Describe A Decision You Made With The Help Of Someone | September to January IELTS Cue Card Sample

Do we really need pesticides? - Fernan Pérez-Gálvez

Do we really need pesticides? - Fernan Pérez-Gálvez

Basic English Conversation ideally suited for beginners

Basic English Conversation ideally suited for beginners

73rd Emmys Opening

73rd Emmys Opening

CHRIS BUMSTEAD - FLEX HARD !! Gym Motivation 😤

CHRIS BUMSTEAD - FLEX HARD !! Gym Motivation 😤

What is USPS First Class Mail? Shipping First Class Mail Explained

What is USPS First Class Mail? Shipping First Class Mail Explained

DIY CONCRETE SINK (Part 1 of 2)

DIY CONCRETE SINK (Part 1 of 2)

Comply meaning | Learn English vocabulary | act in accordance with a wish or command | IELTS Vocab

Comply meaning | Learn English vocabulary | act in accordance with a wish or command | IELTS Vocab

Expertise is proud to announce the strategic partnership with ABB.

Expertise is proud to announce the strategic partnership with ABB.

THEY CONTROL OUR RELATIONSHIP FOR 24 HOURS!

THEY CONTROL OUR RELATIONSHIP FOR 24 HOURS!

Transportable Homes NZ | Portable Cabins NZ

Transportable Homes NZ | Portable Cabins NZ