You can select the green checkmark icon at the same time.Hyperlinks can be stored within your file as either relative or absolute.Ī relative hyperlink says, Here is how to get there from where you are now (meaning the folder in which your current document is saved) while an absolute hyperlink says, Here is how to get there no matter where you start from.Īn absolute link will stop working only if the target is moved. If this solved your problem please go to your first post use the Edit button and add to the start of the title. You only need to disable them once, for all future spreadsheet entries in every spreadsheet. Press the Help button to learn what they do.

You may want to disable additional options in the AutoCorrect Options dialog. Tell us which sheets/cells are involved and what you did with menus, toolbars, keyboard typing, mouse actions, or whatever. Explain precisely what you have tried, what happened, and what you expected to happen instead. If you need any further assistance, attach a document demonstrating the situation (remove confidential information then use Post Reply, not Quick Reply, and don't attach a picture instead of the document itself). To remove hyperlinks from cells after you have typed/pasted them, select them: Format → Default Formatting If hyperlinks are created when you enter data: Tools → AutoCorrect Options → Options → uncheck URL Recognition

If hyperlinks are created as you paste from the web, do not paste but instead: Edit → Paste Special → Unformatted Text

If you have a new question, ask it, but you need your own topic. That at least makes the links black and not underlined which is 99% there.I have no idea what the question is here. All I can do as a solution is to paint the text black and remove the underlining. I have blue urls and the formatting is already default. Jarjarjargon wrote:I have no idea what the solution is here.

Openoffice writer remove hyperlink