Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
MS Excel.... REMOVE HYPERLINK QUESTION.....?
I have never encountered this problem before using MS Excel. In order for me to work at a good pace I copy my info from my companies online source. In doing so I copy the hyperlink and paste everything into excel.
Last week and all the weeks before I would right click and chose remove hyperlink. This got rid of the pasky link that I didn't need so I can color code and outline things. I also didn't have to re-type things.
Right now the remove hyperlink thing does not show up and I can't find it in the top tool bar. Can anyone tell me where the heck I can find it. It is a valuable tool.
I found the problem. So no-one needs to answer. For all of your future answers thanks.
This is the correct answer though.
Make sure you are not in Page Break Preview. The options for editing cells is limited greatly in Page Break Preview.
I give myself 10 points.
No kidding genius that's were the problem was...it didn't show up when I right clicked.
4 Answers
- 1 decade agoFavorite Answer
Congrats....On figuring it out on your own. sorry for the waste of 5 points. Since the other idiots didn't read your comments well enough this is my answer.
- Anonymous5 years ago
CTRL + A - Select All CTRL + SHIFT + F9 - Removes all hyperlinks
- 1 decade ago
right click on the adress or what ever it is linked and select remove link from the pop up menu
