Beyond the Help files . . .

 

 

Access  ¨  Excel  ¨ FrontPage ¨ Outlook ¨ PowerPoint ¨  Word ¨    Miscellaneous  ¨  Tutorials  ¨  Windows  ¨  Free Downloads


 


 

Remove Hyperlinks in Microsoft Excel

Sure, you can use a macro if you do this on a regular basis. Click here to learn how from Excel MVP J. E. McGimpsey. Thanks to Dave McRitchie for pointing it out for us.

Excel 2000 and Below

Manually, you can copy, open Word, EditŕPaste Special as unformatted text, then copy back.

See what Microsoft has to say about preventing their creation.

Excel 2002 and Above

If you just need to do this from time to time, select the cells and copy them. Don't move your cursor! Hit EditŕPaste Special, choose Values, and hit OK.

Each method removes the underlying hyperlink, but not the text.

 

Back to top...

 

 

OfficeArtilces.com debuted on May 26, 2005.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved