This is a simple way to find and delete Hyperlink in Excel
If spreadsheet Excel has many hyperlinks, then you want to remove these hyperlinks. However, with so many hyperlinks, removing hyperlinks will take a long time. So how to find and delete all hyperlinks on Excel file, please refer to the following article of Network Administrator.
1. Find and delete all Hyperlink on Excel
First select the cells you want to delete Hyperlink. To delete all available hyperlinks on the spreadsheet, press Ctrl + F to open the Find and Replace dialog box.
In the Find and Place dialog box, click the Options option .
This is a simple way to find and delete Hyperlink in Excel Picture 1
Next click on the arrow at Format tab, select Choose Format from cell.
This is a simple way to find and delete Hyperlink in Excel Picture 2
Select cell with hyperlink and it will display the preview next to the Format frame as shown below.
This is a simple way to find and delete Hyperlink in Excel Picture 3
Click on Find All and all Excel hyperlinks will be displayed on the screen.
You can select one or more hyperlinks from the list of results using the Ctrl or Shift keys .
To delete hyperlinks, right-click on the hyperlink on the cell, then select Remove Hyperlink.
This is a simple way to find and delete Hyperlink in Excel Picture 4
2. Find and delete Hyperlink on a specific text
Suppose to delete Hyperlink on Product 3, follow the steps below:
Press Ctrl + F to open the Find and Repalce dialog box.
This is a simple way to find and delete Hyperlink in Excel Picture 5
In the Find what frame, enter Product 3 . Click on the down arrow next to Format, select 'Choose Format From Cell'.
Select the cell with Product 3 and it will show the preview next to the Format frame, then click Find all.
This is a simple way to find and delete Hyperlink in Excel Picture 6
On the screen will display hyperlink Product 3.
This is a simple way to find and delete Hyperlink in Excel Picture 7
Select the tape result by pressing Ctrl or Shift key. To delete all hyperlink, right-click the selected hyperlink and select Remove Hyperlinks .
3. Delete all hyperlinks at the same time
To delete all hyperlinks on spreadsheet Excel, press Ctrl + A or click on the triangle icon on the top of the sheet as shown below to select the entire spreadsheet.
This is a simple way to find and delete Hyperlink in Excel Picture 8
Right-click anywhere on the sheet and select Remove Hyperlinks . All hyperlinks will be completely removed on the entire spreadsheet.
This is a simple way to find and delete Hyperlink in Excel Picture 9
Refer to some of the following articles:
- Summary of expensive shortcuts in Microsoft Excel
- You want to print text, data in Microsoft Excel. Not as simple as Word or PDF! Read the following article!
- These are the most basic functions in Excel that you need to understand
Good luck!
You should read it
- How to disable Hyperlink in Excel
- How to create Hyperlink to link spreadsheets in Excel
- How to create suggestions for Hyperlink in Excel
- Instructions on how to create Hyperlink in Excel
- How to use the Hyperlink function in Excel
- How to delete the link, remove Hyperlink in Word
- How to create Hyperlink to link in Excel
- Create Hyperlink in Excel
- Hyperlink (Hyperlink) in PowerPoint 2016
- How to delete links in Excel
- How to create hyperlinks in excel is extremely useful
- The hyperlink test command is being used by hackers to perform DDoS
May be interested
How to set up shortcuts on Microsoft Word 2016 yourself
Usage Simplenote notes, manages jobs
Instructions for activating the dark color Theme on Office 2016
How to create notes on Google Chrome does not need software
Fix errors not typing Vietnamese on Google Docs
Restore default settings in Word, Excel 2003, 2007, 2010, 2013