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-

Advertisement
  • Shanthabai

    Thank U very much

  • ginger

    This does not clear hyperlinks in Excel 2010. If you select to clear hyperlinks AND formatting then it clears hyperlinks. We can pretend everything works right in this program but it does not.

  • Mohan

    First Go to home tab->>Styles tab–>Select hyperlink down arrow button and Normal in that automatically your selected hyperlink data will come to normal text.(It is applicable on Excel 2007)

  • christina xio

    i want hyperlink of more then 5000 blogs in one web page sheet in browser how can i do that

  • xxx

    Thank you – wanted to cler all hyperlinks in a cut and paste page from the web.

    Had to google about a dozen sites before you gave exactly the info needed.

  • Keith

    Awesome! Thanks! So easy.

  • Marianne

    I just tried the suggestions from Mohan and ginger. Although my report ‘appears’ to have no hyperlinks (the text is no longer highlighted or underlined), the hyperlink remains. Very frustrating.

    • Jim

      Marianne, you are soooooo right!! When you clock on these things, you get the e-mail all set up ready to fill in…. The colors and underlining are gone, but the link is really there.
      So, the answer is “you can’t” The correct functionality is to be able to select the format for the Column and choose NO HYPERLINKS (please?)