Removing Hyperlinks without a Macro, Take Two

Summary: Need to get rid of hyperlinks in a worksheet? Here's an easy way to do it without using a macro. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Other issues of ExcelTips have featured macros that remove all the hyperlinks in a worksheet. If you have too few hyperlinks to justify the use of a macro (or you just don't like to deal with macros), you may be interested in an easy way to delete hyperlinks without using macros:

Use the arrow keys to select the cell containing the first hyperlink.
Press Ctrl+K. Excel displays the Edit Hyperlink dialog box. (Click here to see a related figure.)
Click Remove Link. The dialog box disappears and the hyperlink is removed.
Use the arrow keys to select the cell with the next hyperlink.
Press F4. The hyperlink disappears.
Repeat steps 4 and 5 to remove any other hyperlinks you want removed.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2831) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.

Check out ExcelTips: Filters and Filtering today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Removing Hyperlinks without a Macro, Take Two