Folks, you are very well aware about the fact that it is very difficult and time taking task to remove the multiple hyperlinks from a spreadsheet as one has to remove them one by one. It becomes quite irritating an d frustrating to remove each link one by one by right clicking the each link and then selecting ‘Remove hyperlink’. To solve your this problem, in this tutorial I have come up with very easy and simple steps to “remove multiple hyperlinks in Excel”.
Steps To Remove Multiple Hyperlinks in Excel on Selected Cells:
Step 1: Type any text in a blank cell.
Step 2: Right Click on the text and copy it.
Step 3: Now select the cells whose hyperlink you want to remove by Ctrl+ Click.
Step 4: Go to Edit Menu and select Paste Special. If you are using MS-Office 2007, then select Paste Special from Home Menu.
Step 5: Under Operation, first click Multiply and then OK.
Step 6: In case of MS -Office 2007, you have to change the cell Styles to Normal found at the Styles Group Toolbar.
Read more>>How To Add Facebook Like Box To Blogger
That’s it! you are done with removing the Multiple Hyperlinks in Excel on Selected Cells, now I would be telling you how you can remove Hyperlinks using macro.
Steps To Remove Multiple Hyperlinks in Excel Using Macro:
Step 1: Press ALT+F11 to start the Visual Basic Editor.
Step 2: Choose the Workbook, that is located at the left side of the editor by double clicking on it.
Step 3: Now, type the code given below:
Step 4: Now, save your work.
Step 5: To run Macro, press ALT+F8, or go to Tools -> Macro -> Macros
Step 6: Now select the macro that you have made and tap the Click Run button.
Well that’s all you have to do for removing the multiple Hyperlinks in Excel. Now you need not to worry about getting irritated while removing each hyperlink one by one. You can remove the multiple or selected hyperlinks at once.