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.