How to remove multiple hyperlinks in a spreadsheet in Excel

Written by frank luger Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to remove multiple hyperlinks in a spreadsheet in Excel
How to Remove Multiple Hyperlinks in a Spreadsheet in Excel (Microsoft Corporation)

Being able to add hyperlinks -- links to other locations on your computer or online -- in Excel is very useful. However, removing them can be difficult because as you click them, they take you to the linked location or begin to do so. There are various ways of removing multiple hyperlinks in Excel, depending on how they are set out on the spreadsheet.

Other People Are Reading

Whole sheet

If the sheet has nothing else but hyperlinks and you want to remove all of them, first hold down the “Ctrl” key. Then tap the “A” key. This will select all the cells in the sheet, including all the hyperlinks. Now press the “Delete” key. The hyperlinks will be removed.

Rows and columns

Use a different approach if multiple hyperlinks form part of a sheet, occupying different rows. The sheet may have other things on other rows that you wish to keep. Click the numbered row heading at the left of the sheet for the first row with hyperlinks. This will select everything in that row. Hold down the “Ctrl” or “Alt Gr” key and click the other rows with hyperlinks. Now press the “Delete” key. The hyperlinks will be removed. Remove a whole column of hyperlinks in a similar way by first clicking the relevant column heading at the top of the sheet. Hold down the “Ctrl” or “Alt Gr” key and click the other columns with hyperlinks. Press the “Delete” key to remove them.

Individual cells

Another method is used for removing multiple hyperlinks spread throughout the sheet, rather than in the same columns and rows. Click an individual cell with a hyperlink but keep the mouse button pressed down until the cursor changes into a plus sign. Hold down the “Ctrl” or “Alt Gr” key and click the other cells with hyperlinks. Right click over one of the cells and click “Remove Hyperlinks.”

Hidden hyperlinks

It is possible to hide hyperlinks in Excel by adding friendly names. The friendly name may be a short version of the hyperlink, or other clue to what the cell links to. It replaces the hyperlink text but still works as a hyperlink. You can recognise hidden hyperlinks because the text is blue and underlined. They can be removed in the same way as other hyperlinks, as detailed above. The arrangement of the hidden hyperlinks on the sheet will determine the best way of removing them.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.