However, you can alter the code to work on every sheet in the workbook and do many other things. The macro above removes all hyperlinks from the “active” worksheet-not the workbook. Press the Alt + F8 hotkey combo to open a Macro window, select ThisWorkbook.RemoveAllHyperlinks from the list, and then press the Run button. Option 2: Close the VBA window and go back to the active Excel spreadsheet.Option 1: You can run the sub in VBA if you like at this point by selecting Run at the top, but you won’t see the changes on the spreadsheet unless you move the VBA Window out of the way.Copy and paste the following code into the VB code window:.Double-click on ThisWorkbook in the VBAProject panel.Press the Alt + F11 hotkey to open the VB editor in Excel.So why not set up a macro that removes all hyperlinks from an Excel sheet? The complete Excel application includes a macro-recording tool to record macros, but you can also set up macros manually by entering the Visual Basic for Applications (VBA) code. This Tech Junkie post (and its video) tells you how to record macros in Windows.
Macros are a recorded sequence of selected options. The pasted cell now shows the URL without a hyperlink.In Excel at cell D3 or your preferred cell, right-click it and select Paste Text Only (T), which is the clipboard icon with the big letter A.As an example, copy the following URL:.Nevertheless, 2007 users can still remove links from spreadsheets using the “Paste Special” trick. As such, you can’t select that option in Excel 2007. Not all Excel versions include the “Remove Hyperlink” context menu option. Right-click on any cell and select Remove Hyperlink to convert all the links to plain text.To remove all hyperlinks from a sheet, press the Ctrl + A hotkey to select all the spreadsheet cells.Right-click on one of the selected cells and select the Remove Hyperlink option.To remove multiple hyperlinks from an Excel spreadsheet, hold the Ctrl key and select several cells with URLs at once.That will convert the hyperlink to a plain text URL. Then, you can right-click that cell and select the Remove Hyperlink option on the context menu.Open a blank Excel spreadsheet and enter in cell B2.If you’re using a more recent version of Excel, you can remove all the hyperlinks from a sheet with a context menu option. Using the Context Menu to Remove the Hyperlink Option If you want to have a list of plain text URLs, this is how you can remove all hyperlinks from Excel spreadsheets.
0 kommentar(er)
