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

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.