Black Friday Sale!

Ends in:

Remove All Hyperlinks Quickly in Excel

Add to Favorites
Author:
BLACK FRIDAY SALE (65%-80% Off)

Excel Courses Online
Video Lessons Excel Guides

How to quickly remove all hyperlinks or a selection of hyperlinks from Excel.

This removes the link itself and any associated formatting but keeps the visible text in place.

Sections:

Remove Hyperlinks from Excel

Remove All Hyperlinks from a Worksheet at Once

Notes

Remove Hyperlinks from Excel

  1. Select the cell that contains the hyperlink. Do this without navigating to the link by right-clicking the cell and then hitting the Esc (Escape) key to remove the menu that appears when you right-clicked the cell.
  2. Go to the Home tab and look to the right and click the small white eraser button and then click Remove Hyperlinks.
  3. That's it!

Remove All Hyperlinks from a Worksheet at Once

  1. Click the upper left corner of the spreadsheet to select the entire worksheet.
  2. Go to the Home tab and look to the right and click the small white eraser button and then click Remove Hyperlinks.
  3. That's it!

Notes

This is a simple little trick that will save you a lot of time when you have to clean-up a worksheet.

Download the sample worksheet attached to this tutorial to try this out in Excel.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Quickly Copy Cell Formatting to Other Cells in Excel
Tutorial: How to copy all of the formatting of a single cell to other cells in the spreadsheet witho...
List All Named Ranges in Excel - Displays the Name and Value for Every Named Range Within the Active Workbook in Excel
Macro: List all of the named ranges in a workbook in Excel and the corresponding values store...
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
Macro: Delete all chart sheets and tabs in Excel using this macro. This will only delete the char...
Remove (Delete) Hyperlinks from Worksheets
Macro: This macro will remove all hyperlinks from the active worksheet. It will delete the hyperl...
3 Methods to Remove Spaces Between Text in Excel
Tutorial: How to remove spaces from the middle of text in Excel.  This includes removing all space...
Remove All HTML from Text in Excel
Tutorial: How to quickly and easily remove all HTML from data copied into Excel. This tutorial inclu...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course