How to Find External Links in Excel on PC or Mac

This app teaches you how to find external links in Excel. You can easily search for links using the Find and Replace tool in Excel.

Steps

1
Open Excel. It's the app that has a green icon that resembles a book of spreadsheets.
2
Open an Excel spreadsheet. There is a list of recent Excel spreadsheet documents in the column to the left. If you don't see the spreadsheet you want to open in the list, click "Open other workbooks". Navigate to the spreadsheet you want to open, and click on it.

Advertisement
3
Press Ctrl+F. This will open the Find and Replace tool.
- Press Control+F on Mac.
4
Click Options. It's to the right below the two bars.
5
Type .xl next to "Find What". The "Find What" box is at the top of the popup under the "Find" tab.
6
Select Workbook next to "Within:". Use the pulldown menu in the box labeled "Within" to select "Workbook".
7
Select Formulas next to "Look In:". Use the pulldown menu in the box labeled "Look In" to select "Formulas".
8
Click Find All. It's above the list box at the bottom of the "Find and Replace" dialogue.
9
Click the cell formula in the list box. To select a link, click the cell formula in the list box.

Advertisement