How to Remove Mass Links in Excel 2007

Hyperlinks to websites and other workbooks can be added to a spreadsheet in the Microsoft Office Excel 2007 program. Links added to an Excel 2007 worksheet allow you to quickly reference other data. However, you may need to remove more than one link at once if you no longer want the links to appear in your worksheet. You can use the Paste Special feature to remove the mass links at any time.

Instructions

1. Open the Microsoft Excel 2007 file on your computer that contains the links you want to remove.

2. Enter "1" into a blank cell within your worksheet. Right-click on the cell with your mouse and then click on the "Copy" option.

3. Hold down the "CTRL" key on your keyboard and select each link in your worksheet that you want to remove.

4. Click the "Home" tab. Click the arrow below the "Paste" field in the "Clipboard" group. Click the "Paste Special" option.

5. Click the "Multiply" option and then click the "OK" button. Click the "Home" tab again and then click the "Cell Styles" option from the "Styles" group.

6. Select the "Normal" option below the "Good, Bad, and Neutral" field and all of the links you selected will be removed.

References

• Microsoft Office: Create, Select, Edit or Delete a Hyperlink
• Microsoft Office: Select a Hyperlink Without Activating the Link