Excel links, or hyperlinks, are useful for connecting your spreadsheets to external websites, documents, or other parts of your workbook. Here's how to find them:
1. Identifying Existing Hyperlinks
- Visual Inspection: Hyperlinks in Excel typically appear as underlined blue text. Hover your mouse over the text to see the full URL in a tooltip.
- Hyperlink Button: Click the "Hyperlink" button in the "Insert" tab on the ribbon. This will highlight all existing hyperlinks in your workbook.
- "Go To Special" Feature: Press Ctrl+G (or Command+G on a Mac) to open the "Go To" dialog box. Select "Special" and then choose "Hyperlinks" to select all hyperlinks in your workbook.
2. Finding Broken Hyperlinks
- "Edit Links" Feature: Click the "Hyperlink" button in the "Insert" tab and then choose "Edit Links" from the dropdown menu. This will display a list of all hyperlinks in your workbook, including any that are broken.
- "Find and Replace" Function: Use Ctrl+H (or Command+H on a Mac) to open the "Find and Replace" dialog box. In the "Find what" field, enter
=HYPERLINKand leave the "Replace with" field blank. This will highlight all hyperlink formulas. You can then manually inspect these formulas to identify broken links.
3. Using the "Hyperlink" Function
The HYPERLINK function is used to create hyperlinks in Excel. To find hyperlinks using this function:
- Formulas Tab: Go to the "Formulas" tab and click the "Insert Function" button.
- Search for "HYPERLINK": Type "HYPERLINK" in the "Search for a function" box and click "Go".
- Enter Arguments: In the "Function Arguments" dialog box, enter the URL in the "Link_location" field and the text to display in the "Friendly_name" field.
Example: =HYPERLINK("https://www.google.com", "Google") will create a hyperlink that displays "Google" and links to the Google website.
By following these steps, you can easily find and manage hyperlinks in your Excel spreadsheets.
