Ask Your Question

calc: how do I get rid of just a hyperlink

asked 2018-10-31 18:16:03 +0200

Todd2 gravatar image

I have two cells with hyperlinks in them somehow. I want to leave all other formatting in tact but remove just the hyperlinks. The text of the hyperlink needs to remain.

Also, in the format menus is there a way to tell certain cells to NEVER insert a hyperlink?

Many thanks, -T

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-11-01 09:21:25 +0200

ebot gravatar image

Select the cell (s), choose Format>Delete Direct Formatting from the menu.

edit flag offensive delete link more


But you have to put everything back if you do that.

Todd2 gravatar imageTodd2 ( 2018-11-03 06:35:39 +0200 )edit

Why is this answer marked/checked correct then?

erAck gravatar imageerAck ( 2018-11-03 19:44:19 +0200 )edit

answered 2018-11-03 06:29:46 +0200

Todd2 gravatar image

I copied the link to a text editor, erased the link, pasted the text back with shift ctrl v

Never did figure out how to turn them off completely

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-10-31 18:16:03 +0200

Seen: 135 times

Last updated: Nov 03 '18