Excel 2010 provides a handy feature to instantly remove formatting along with all the hyperlinks. Many a times it happens that while pasting/importing data from external sources, hyperlinks get included. If your datasheet contain hundreds of hyperlinks, removing them manually is a tedious job.This post covers how to remove it using the build-in feature.
For clearing the hyperlinks at once, select the data sheet, navigate to Home tab and from Editing group, under Clear options, click Clear Hyperlinks.
For removing Hyperlinks along with clearing formatting, from Clear button options (attach with select datasheet portion), click Clear Hyperlinks and Formats.
This will instantly clear the Hyperlinks along with the formatting.