So many links 15



When you're working in large, link-filled Excel spreadsheets, you may get the require to count the way several links you maintain or to get the links appropriate apart. Microsoft Excel does not have some primary instrument or function to find links for you. Still, there is a technical workaround to secure links. All links with Excel are enclosed with square brackets ([ ]), so you can search for the square brackets to secure links.

Difficulty: Effortless

Directions

1 Click "Start," "All programs," "Microsoft Office" also then "Microsoft Excel."

2 Click "File" and consequently "Open." Locate the Excel spreadsheet via which you require to seek out.

3 Click "Secure & Pick out," and then click "Get."

4 Click "Options" and then type "[" (lacking quotation marks) to the "Get what" field. Select "Workbook" from the "Inside" box, also type "Formulas" inside the "Look in" box. This will search only for links.

5 Click "Discover All." You will these days find all of the cells in the worksheet in links in them.

References

Microsoft: Excel: Find external references (links) in a workbook

Print Email Share

Comments