Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»How to Find and Edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

Asmi DhakalBy Asmi DhakalJanuary 23, 2023
How to Find and edit Hyperlinks on Excel

Hyperlinks are usually easy to find due to the special formatting that Excel applies to them. However, if you’re dealing with a shared workbook where a user may have cleared formatting, you will visibly have nothing to locate and edit them. Similarly, if your workbook does contain an address but has removed linking, Excel will not use special formatting for it.

Excel, unfortunately, does not provide a list of hyperlinks like it does to find external links. You can still use a few workarounds to locate hyperlinks in bigger worksheets in Excel.

Table of Contents

  • Use the Find and Replace Tool
  • Use Cell Styles
  • Place Your Cursor
  • How to Edit Hyperlink Formatting?

Use the Find and Replace Tool

If you’re dealing with a larger spreadsheet, locating each hyperlink could be tiring. You can use the Find and Replace tool in Excel to locate hyperlinks through either their text format, or you can use terms such as “.com” if your hyperlinks aren’t linked.

  1. Open your workbook and use Ctrl + F.
  2. From the pop-up, head to Replace the select Options >>.
    Find and Replace Options
  3. Next to Find what, select the Format button.
    Find Format Excel
  4. Select Choose Format From Cell.
    Choose Format From Cell Excel
  5. Click on one of your cells with a hyperlink to copy the format.
  6. To replace hyperlinks, next to Replace With,
  • Enter the replacement value.
  • Or, select Format to replace the cell formatting.
  1. Select Replace All to make changes. If you want to simply locate the values, click Find All.
    Replace Excel

You can skip steps 3, 4, and 5 if you haven’t linked your address. Next to Find what, simply enter .com or www. to uniquely locate your address.

Use Cell Styles

Hyperlink Style Excel

You can use Cell Styles in the Home tab to identify if the cell you’ve selected is a hyperlink. When you have a cell selected, the Hyperlink option gets selected in the window. This is for all text containing hyperlinks even if they do not have the special formatting applied to them.

Once you identify a hyperlink, right-click on the cell and select Edit Hyperlink (Ctrl + K). You can make several changes in your hyperlink from the Edit Hyperlink window.

Edit Hyperlink Excel
  • Text to display: Enter a text you want Excel to display instead of the address.
  • Look in: If you’re inserting an internal document, navigate to the location from the window below. The folder your destination file is stored will appear in this section.
  • Address: If you’re embedding hyperlinks from the web, enter the address in this section.
  • Link to: Select one of the options that best fit your hyperlink’s description.
  • Bookmark: If you wish to redirect a text to a bookmark in your worksheet, select the Bookmark button then choose your bookmark.

Place Your Cursor

Find hyperlinks in Excel

Your cursor will shift to a pointer when you place it on a hyperlink. You can hover your cursor over each cell to determine if they’re a hyperlink. Once the cursor changes into a pointer, select the cell and use Ctrl + K to open the Edit Hyperlink window.

How to Edit Hyperlink Formatting?

Many users may opt to remove the hyperlink format from their documents when it does not match the document’s overall aesthetic. If you relate, you can simply change the format style so you do not lose the accessibility of immediately locating hyperlinks.

  1. On the Home tab, select the fly-out menu in the Styles section.
  2. Right-click on Hyperlink and choose Modify.
    Modify Hyperlinks Excel
  3. Click the Format button.
    Custom Style Format Excel
  4. Create a custom format from each of the tabs in the Format Cells window.
    Format Cell Excel
  5. Select OK > OK to confirm changes.
how-to
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
how to set print area in excel

How to Set Print Area in Excel

January 5, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
what-does-collate-mean-on-a-printer

What Does Collate Mean on a Printer?

March 31, 2023
usb-vs-pcie-wifi

USB Vs PCIe Wi-Fi—Which One is Better?

March 31, 2023
how often to replace laptop

How Often Should You Replace a Laptop

March 29, 2023
You may also like
computer suddenly slow

Why is My Computer Suddenly Slow? 11 Ways to Fix It

March 31, 2023
HTTP-Error-431

How to Fix HTTP Error 431

March 31, 2023
scheduled task reboot

How to Create a Reboot Scheduled Task in Windows

March 31, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday, editor@technewstoday.com | Tech Central Pvt. Ltd.

Type above and press Enter to search. Press Esc to cancel.