Removing Hyperlinks without a Macro, Take Two

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:

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