Ask Experts Questions for FREE Help !
Ask
    RickJ's Avatar
    RickJ Posts: 7,762, Reputation: 864
    Uber Member
    		  
    #1

    Feb 20, 2007, 08:03 AM
    Excel: Deleted cell content but link is still there
    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's Avatar
    RickJ Posts: 7,762, Reputation: 864
    Uber Member
    		  
    #2

    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's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    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's Avatar
    RickJ Posts: 7,762, Reputation: 864
    Uber Member
    		  
    #4

    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Article-content [ 1 Answers ]

Hello Can anybody tell me where to find the best article and content sites?

Content Advisor [ 3 Answers ]

"Hi, My PC Win XP at work has been converted into a paper weight by our IT guy. He has restricted nearly the entire web from being displayed. Is there any back door you know of for me to make the change in content advisor without knowing his admin log-on and password?";

Content advisor [ 7 Answers ]

"Hi, My PC Win XP at work has been converted into a paper weight by our IT guy. He has restricted nearly the entire web from being displayed. Is there any back door you know of for me to make the change in content advisor without knowing his admin log-on and password?";

Display text vertically and not horizontally in 1 cell (Excel) [ 2 Answers ]

How would you display a line of text to show vertically after each text in one cell? For example: Total Activity Cost And not Total Activity Cost (in one cell)? Thank you in advance.

View more questions Search