Reaaly basic question - deleting "html link" text

[Malthus101]

Hi

Super basic problem but it confounds me and probably always has! I want to know the solution.

I had a link copied into a cell then got rid of it - instead I just need basic text in that cell now.

But as soon as I start typing, it turns it into a blue, underlined "link" type of text. If I backspace it, it reappears. If I "delete" the whole cell content, it still reappears. I'm sure in Word there is a "remove hyperlink" context menu option but not here.

How do I stop it formatting this way?

Thanks.

 

[Candyman8019]

In the 'editing' section of the ribbon you'll find an eraser button that you can use. Click the down arrow and choose 'clear formats'

 

[Malthus101]

Oh yes, I found it.

Cool thanks!