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
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.
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.”
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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for