Remove Hyperlinks

nhengineer · General User Joined: 21 Jun 2005 Posts: 5

Sorry if this has been asked before but I can't see how to search threads here. I've been trying to find out how to remove a hyperlink in Spreadsheet without success. Anybody able to help?

Regards,
David Lee

Dale · Posted: Tue Jun 21, 2005 6:10 pm Post subject:

There's probably a more elegant way of doing this, but

Select a cell near that which contains the hyperlink
Use tab/arrow keys to navigate to the cell with the hyperlink
Press the "Delete" key (or your system's equivalent)
Check "Delete All" and click OK
Hyperlink now banished to wherever they go when they die.
_________________
Dale
To err is human, but to destroy your slippers in the process takes a real son of a bitch: Me!

OOo documentation from the source
http://documentation.openoffice.org
Guides, FAQ, How Tos

8daysaweek.co.uk · Super User Joined: 29 Nov 2003 Posts: 2130 Location: UK

Hi nhengineer,

If you want to remove the hyperlink while retaining the text of where the link points to, then select the cell(s) - using the method that Dale describes - then select Format > Default from the menus.

Also see: http://www.8daysaweek.co.uk/forums/viewtopic.php?p=174#174

HTH Smile

,
_________________
James
www.8daysaweek.co.uk - A User-Focused OOo site

nhengineer · General User Joined: 21 Jun 2005 Posts: 5

James & Dale,

Thank for your quick response. What I had to do all yesterday was copy & paste the cell contents into NotePad, then copy & paste that back into the cell ...300 times. What fun!

Regards,
David Lee

nhengineer · General User Joined: 21 Jun 2005 Posts: 5

...and, YAHOO!!!, it WORKS

David Lee