How To Quickly Remove Hyperlinks in Excel
In this quick excel tutorial I’ll show you how you can remove hyperlink in excel. Whenever you click on a hyperlink, you’ll be redirected to the website automatically. But sometimes we don’t want it. That’s why in this tutorial I’ll demonstrate how you can remove hyperlink in the quickest way. Also, I want to keep the hyperlink formatting. So, follow the below procedure to remove hyperlink and keep the blue font and underline.
Follow the instructions below to remove hyperlink and keep the formatting.
Step 1: Select the data range where you want
Step 2: Under the home tab click on clear dropdown.
Step 3: Click on Clear Hyperlink
Done. This is how you can quickly remove hyperlink and keep the hyperlink formatting.
#Remove #Hyperlink

Thanks for watching.
————————————————————————————————————-
Support the channel with as low as $5
https://www.patreon.com/excel10tutorial
————————————————————————————————————-
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG *Become a member and enjoy exclusive perks while supporting the channel you love!*
https://www.youtube.com/@Excel10tutorial/join

Please take the opportunity to connect and share this video with your friends and family if you find it useful.