Browse » Home
Thursday, April 28, 2011
How to Find Links in Microsoft Excel
Links in Hyperlink
1. Open the Excel workbook containing the links you want to find.
2. Place your cursor in an empty cell and create a dummy hyperlink (so you can use its format to find other hyperlinks). To create the hyperlink, select the 'Insert' tab and click 'Hyperlink' in the 'Links' group. Select 'Existing File or Web Page' under 'Link to' in the 'Insert Hyperlink' dialog box. Type a website address (ex., 'http://some-address-123.com') into the 'Address' text field and click 'OK.'
3. Select the 'Home' tab and go to the 'Editing' group. Click 'Find Select' and 'Find.' The 'Find and Replace' dialog box appears. Click the 'Options' button to expand the dialog box.
4. Leave the 'Find what' text field blank. Click the arrow beside the 'Format' button and select 'Choose Format From Cell.' The dialog box minimizes and you are directed to your spreadsheet.
5. Click on the cell containing the dummy hyperlink you created in Step 2. The 'Find and Replace' dialog box reopens.
6. Select 'Workbook' from 'Within.' Select 'Values' under 'Look in.' Choose 'Find All.' All matching entries are displayed at the bottom of the dialog box.
7. Delete the dummy hyperlink from your spreadsheet.
Links in Cells
8. Repeat Step 3 of the previous section.
9. Type an open bracket '[' in the 'Find what' text field, representing the format of links in the formula bar.
10. Click 'Workbook' from 'Within' and 'Formulas' from 'Look In.' Press the 'Find All' button to display the matching links.
Links in Objects, Chart Titles or Data Series
11. Go to the text box, chart title, object or data series containing the link you want to find. To find it quickly, select the 'Home' tab and go to the 'Editing' group. Click 'Find' and 'Go To Special.'
12. Check 'Objects' in the 'Go To Special' dialog box and press 'OK.'
13. Press the 'Tab' key and check the formula bar for references to links.
Links in Names
14. Click the 'Formulas' tab in the ribbon and go to the 'Defined Names' group.
15. Click the 'Name Manager' button to display the 'Name Manager' dialog box.
16. Check the 'Refers To' tab for the link you want to find. Its cell address is displayed in the dialog box.