Microsoft Office Tutorials and References
In Depth Information
Removing existing hyperlinks
Removing existing hyperlinks
To remove a hyperlink from a cell (but keep the cell’s contents), right-click the cell and choose
Remove Hyperlink from the shortcut menu.
In previous versions of Excel, you were forced to delete hyperlinks one at a time. Excel 2010
finally gets it right and lets you remove multiple hyperlinks with a single action. Just select the
range, right-click, and choose Remove Hyperlinks. This command works even if the selection
includes cells that don’t contain a hyperlink. To remove all hyperlinks on a worksheet, press
Ctrl+A to select all cells. Then right-click any cell and choose Remove Hyperlinks. Depending on
the location of the cell pointer, you may need to press Ctrl+A twice to select all cells.
Search JabSto ::

Custom Search