1. Home
  2. MS Office

Excel 2010: How To Clear Hyperlinks From Spreadsheet

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.

150d1273580207-how-quickly-clear-hyperlinks-excel-datasheet-4

For clearing the hyperlinks at once, select the data sheet, navigate to Home tab and from Editing group, under Clear options, click Clear Hyperlinks.

152d1273580211-how-quickly-clear-hyperlinks-excel-datasheet-3

For removing Hyperlinks along with clearing formatting, from Clear button options (attach with select datasheet portion), click Clear Hyperlinks and Formats.

153d1273580215-how-quickly-clear-hyperlinks-excel-datasheet-32

This will instantly clear the Hyperlinks along with the formatting.

151d1273580209-how-quickly-clear-hyperlinks-excel-datasheet-

Leave a comment