Ask Experts Questions for FREE Help!
Ask    ||    Answer
 
Advanced  
 

Ask QuestionsprogressAnswer QuestionsprogressBuild ReputationprogressBecome an Expert
 
Free Answers in 3 Easy Steps

Register Now
3 Steps

At Ask Me Help Desk you can ask questions in any topic and have them answered for free by our experts. To ask questions or participate in answering them you must register for a free account. By registering you will be able to:
  • Get free answers from experts in any of our 300+ topics.
  • Accept money for answers that you provide.
  • Communicate privately with other members (PM).
  • See fewer ads.

Home > Computers & Technology > Software > Spreadsheets   »   Excel: Deleted cell content but link is still there

 
Thread Tools Search this Thread Display Modes
Question
 
 
#1  
Old Feb 20, 2007, 07:03 AM
RickJ's Avatar
RickJ
Über Member
RickJ is offline
 
Join Date: Aug 2005
Location: The Bogs at Windover
Posts: 7,363
RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.
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!

Reply With Quote
 
     

Answers
 
 
Old Feb 20, 2007, 07:07 AM   #2  
Über Member
RickJ is offline
 
RickJ's Avatar
 
Join Date: Aug 2005
Location: The Bogs at Windover
Posts: 7,363
RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.
Correction:

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

Is this avoidable?

Thanks.
  Reply With Quote
 
     
 
 
Old Feb 20, 2007, 07:16 AM   #3  
Computer Expert and Renaissance Man
ScottGem is offline
 
ScottGem's Avatar
 
Join Date: Jan 2003
Location: LI, NY - USA
Posts: 33,646
ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.ScottGem See this member's comment history on his/her Profile page.
Pay to call ScottGem for advice ($.75/min)
Call ScottGem via Skype™
Right click on the cell and select Format Cells and change it to General or Text or whatever else is appropriate.
  Reply With Quote
 
     
 
 
Old Feb 20, 2007, 07:27 AM   #4  
Über Member
RickJ is offline
 
RickJ's Avatar
 
Join Date: Aug 2005
Location: The Bogs at Windover
Posts: 7,363
RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.RickJ See this member's comment history on his/her Profile page.
Thanks, Scott.

I was afraid of that. Funny how we (or maybe it's just me ) 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.
  Reply With Quote
 
     

Your Answer
Email me when someone replies to my answer
Join Login





Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

 
Similar Sponsors


Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page

Similar Threads
Excel 2003 - viewing cell colors
(0 replies)
Article-content
(1 replies)
Content Advisor
(3 replies)
cONTENT aDVISOR
(7 replies)
Display text vertically and not horizontally in 1 cell (Excel)
(2 replies)

Search this Thread

Advanced Search

Bookmarks

Sponsors



Copyright ©2003 - 2009, Ask Me Help Desk.
All times are GMT -8. The time now is 07:43 AM.