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.