Here's how simply (Remove) Hyperlink Removal in Excel 2007 without Macro.
If the link is only one or two, still no problem, just right click on the cell which contain the link, then select remove hyperlink. Then the link is lost.
Well, the problem arises when the links that we have to remove are of tens, hundreds or even thousands.
There are two ways, first is with Macro, which it is a kind of script writing at the Macro Excel. The way is quite complicated, for the newbie might be too difficult to memorize that script like that.
There are away to remove links in Excel without Macros.
Very easy, the way is to follow the steps below:
- Prepare a blank column
- Enter any letter, for example the number one (1)
- Copy the number one
- Then paste the hyperlink cell you want it removed, using paste special>> select multiply>> OK
5. Done, and see, the link was lost.
Note:
Usually, Although the hyperlinks are gone, but the font color is blue and underlined, so it seems there is no change, whereas if we highlight the mouse over these cells was no hyperlinks anymore.
Subscribe to this comment's feed
Show/hide comments
| Next > |
|---|