Ask Your Question

How can I edit email addresses in calc

asked 2020-01-14 19:25:11 +0100

Kenwmo gravatar image

I have an address list in a spreadsheet. When I enter an email address it changes the text format and seems to make it a hyperlink of some kind. If I try to edit it, I get weird results. Example: existing: edit to insert a q after john expect to see " all i see is "q" in the automatic format.

How can I make the cell just a text format or at least be able to edit it!

Windows 10 and Version: (x64)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-01-14 19:38:34 +0100

Opaque gravatar image

updated 2020-01-15 01:08:49 +0100


  • To remove the hyperlink: Select the cell and CTRL+M
  • To edit the hyperlink: Mark the text and CTRL+K
  • To prevent creation at all: Deactivate Tools -> AutoCorrect Options ... -> Tab: Options -> Option: [ ] URL recognition

Hope that helps.

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more


Exactly what I was looking for! Thank you.

Kenwmo gravatar imageKenwmo ( 2020-01-15 00:48:21 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-14 19:25:11 +0100

Seen: 21 times

Last updated: 2 days ago