PDA

View Full Version : Excel: Deleted cell content but link is still there


RickJ
Feb 20, 2007, 08:03 AM
When I delete text from a cell where the text was a hyperlink, it does go away, but when I go to type new text in the cell, the new text is hyperlinked as the former text was.

How can I stop this from happening?

Thanks!

RickJ
Feb 20, 2007, 08:07 AM
Correction:

I see now that the new text is NOT hyperlinked... but it is blue and underlined like hyperlinks are.

Is this avoidable?

Thanks.

ScottGem
Feb 20, 2007, 08:16 AM
Right click on the cell and select Format Cells and change it to General or Text or whatever else is appropriate.

RickJ
Feb 20, 2007, 08:27 AM
Thanks, Scott.

I was afraid of that. Funny how we (or maybe it's just me :p ) try to reduce clicks wherever possible.

Seems like time and click-wise, your method or just clicking on the underline button and the black color button are about equal.