Archive of Mr Excel Message Board

Back to Hyperlinks in Excel archive index
Back to archive home

Help me remove hyperlinks at once in a sheet

Posted by Deepika on April 25, 2000 4:33 AM

Kindly help me to remove all the hyperlinks that are present in a sheet.

Thanks

Deepika

Re: Help me remove hyperlinks at once in a sheet

Posted by Sherlock on April 28, 2000 11:38 AM

Hello Deepika,

Please follow the steps given below to remove all the hyperlinks from a sheet.

1. Hold down "Control" key and select all the Hyperlinks.
2. Go to "Edit" menu and select the option "Clear"
3. Now select the "Formats" Option .

All the Hyper links will be removed except for the text.

If you want to delete all the Hyperlinks along with text, select the "All" option from the Edit->Clear->All.

Regards,
Sherlock.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.