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

Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates.

Check out Timesheet Templates today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Removing Hyperlinks without a Macro, Take Two